The following query is an example of a(n)____.
SELECT TABLESPACE_NAME,BLOCK_SIZE
FROM DBA_TABLESPACES
WHERE TABLESPACE_NAME IN
(SELECT TABLESPACE_NAME FROM DBA_DATA_FILES);
A) join query
B) aggregated query
C) sorted query
D) subquery

Question

Quizplus · Accepted Answer

The query includes a subquery within the parentheses of the WHERE clause to select the TABLESPACE_NAME from the DBA_DATA_FILES table. Therefore, it is a subquery.

The Following Query Is an Example of A(n)____