The following SQL statement contains what type of subqueries?
SELECT isbn,title FROM books WHERE pubid =
(SELECT pubid FROM books WHERE title = 'SHORTEST POEMS')
AND retail-cost >
(SELECT AVG(retail-cost) FROM books) ;
A) single-row
B) multiple-row
C) multiple-column
D) inline view
Correct Answer:
Verified
Q58: Any type of subquery can be used
Q59: In Oracle12c,subqueries in a WHERE clause can
Q60: Which of the following subqueries returns more
Q61: The results of a subquery are passed
Q62: The > operator is referred to as
Q64: A subquery,except one in the FROM clause,cannot
Q65: Which of the following operators is used
Q66: The operators =,<,>,<=,>=,and <> are referred to
Q67: The <> operator is referred to as
Q68: A(n)_ subquery is one that can return
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents