Multiple Choice
The following SQL statement contains which type of subquery?
SELECT title,retail,category FROM books
WHERE retail IN (SELECT MAX(retail) FROM books
GROUP BY category) ;
A) single-row
B) multiple-row
C) multiple-column
D) correlated
Correct Answer:
Verified
Correct Answer:
Verified
Q52: Valid <u>multiple-row</u> operators include =,>,<,>=,<=._
Q53: Explain the difference between multiple-row and multiple-column
Q54: The<u> EXISTED</u> operator is used to determine
Q55: A multiple-column subquery nested in the <u>SELECT</u>
Q56: The _ operator indicates that the records
Q58: If a subquery's result must be compared
Q59: A(n)single-row subquery can be nested in a(n)<u>SELECT</u>
Q60: In Oracle12c,a MERGE statement compares data between
Q61: A subquery,except one in the FROM clause,can't
Q62: The _ operator indicates that a value