Multiple Choice
The following SQL statement contains which type of subquery?
SELECT title,retail, (SELECT AVG(retail) FROM books)
FROM books;
A) single-row
B) multiple-row
C) multiple-column
D) inline view
Correct Answer:
Verified
Correct Answer:
Verified
Q94: The results of a subquery are passed
Q95: With a MERGE statement,a series of _
Q96: In Oracle12c,subqueries nested in a WHERE clause
Q97: Contents of the BOOKS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q98: Which of the following subqueries returns more
Q100: The <<u>ANY</u> operator indicates that a value
Q101: IN is a valid <u>multiple-row</u> subquery operator._
Q102: Which operator will instruct Oracle12c to list
Q103: Contents of the BOOKS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q104: If a subquery references a column from