Which two statements are true regarding subqueries?

Which two statements are true regarding subqueries? (Choose two.)

Which two statements are true regarding subqueries? (Choose two.)

A.
A subquery can retrieve zero or more rows.

B.
Only two subqueries can be placed at one level.

C.
A subquery can be used only in SQL query statements.

D.
A subquery can appear on either side of a comparison operator.

E.
There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Leandro Saes

Leandro Saes

Alguém sabe explicar o motivo da ‘E’ estar incorreta e a ‘D’ correta?

Percy Dominguez

Percy Dominguez

Oracle allows a maximum nesting of 255 subquery levels in a WHERE clause. There is no limit for nesting subqueries expressed in a FROM clause.In practice, the limit of 255 levels is not really a limit at all because it is rare to encounter subqueries nested beyond three or four levels.