Multiple Choice
Contents of the BOOKS table
-Based on the contents of the BOOKS table,which line of the following SQL statement contains an error?
1 SELECT isbn,title
2 FROM books
3 WHERE pubid =
4 (SELECT pubid
5 FROM books
6 WHERE title = 'SHORTEST POEMS')
7 AND retail-cost >
8 (SELECT AVG(retail-cost)
9 FROM books) ;
A) Line 3
B) Line 5
C) Line 7
D) none of the above
Correct Answer:
Verified
Correct Answer:
Verified
Q7: A single-row subquery can be nested in
Q8: The greater than operator,>,is a valid operator
Q9: A subquery,except one in the FROM clause,cannot
Q10: A single-row subquery can return several columns,but
Q11: The <u>IN </u>operator can be used with
Q13: The = operator is referred to as
Q14: Which operator will instruct Oracle12c to list
Q15: A correlated subquery is one in which
Q16: When used with a multiple-row subquery,the IN
Q17: The equal sign,=,is a valid single-row operator.