Which three statements about subqueries are true? (Choose three)

The correct answer is B. A single row subquery can retrieve only one row but many columns. C. A multiple row subquery can retrieve multiple rows and multiple columns. E. A single row subquery can use the IN operator. B: A single row sub-query can retrieve only one row but many columns. C: A multiple row sub-query can retrieve one row or multiple rows and multiple columns. E: A single row subquery can use the "IN" Operator. Although the IN Operator is a multiple row operator it can be used…

Displaying Data from Multiple Tables and Subqueries

Question

Options

AA single row subquery can retrieve only one column and one row.
BA single row subquery can retrieve only one row but many columns.
CA multiple row subquery can retrieve multiple rows and multiple columns.
DA multiple row subquery can be compared by using the ">" operator.
EA single row subquery can use the IN operator.
FA multiple row subquery can use the "=" operator.

How the community answered

(32 responses)

A
6% (2)
B
75% (24)
D
3% (1)
F
16% (5)

Explanation

B: A single row sub-query can retrieve only one row but many columns. C: A multiple row sub-query can retrieve one row or multiple rows and multiple columns. E: A single row subquery can use the "IN" Operator. Although the IN Operator is a multiple row operator it can be used for comparisons with single-row subqueries and it will not result in an Incorrect Answers A: A single row sub-query can retrieve only one row, but many columns.. D: Multiple row subquery cannot use the ">" Operator because this is a single row operator. F: A multiple row sub-query cannot use the "=" operator.

Topics

#single-row subquery#multiple-row subquery#IN operator#subquery operators

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice