Which two statements about sub queries are true? (Choose two.)
A.
A sub query should retrieve only one row.
B.
A sub query can retrieve zero or more rows.
C.
A sub query can be used only in SQL query statements.
D.
Sub queries CANNOT be nested by more than two levels.
E.
A sub query CANNOT be used in an SQL query statement that uses group functions.
F.
When a sub query is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the sub query should contain only one column.
Suggested Answer:BF🗳️
sub query can retrieve zero or more rows, sub query is used with an inequality comparison operator in the outer SQL statement, and the column list in the SELECT clause of the sub query should contain only one column. Incorrect answer: Asub query can retrieve zero or more rows Csub query is not SQL query statement
Dsub query can be nested - Egroup function can be use with sub query
"A sub query can retrieve zero or more rows." - any query can retrieve zero or more rows not only sub query.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.1z0-051 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
nadzeya_bdc
4 years, 10 months ago