Multiple Choice
Contents of the BOOKS table
-Based upon the contents of the BOOKS table, which of the following SQL statements will display five rows in its results?
A) SELECT DISTINCT category FROM books;
B) SELECT DISTINCT pubid FROM books;
C) SELECT UNIQUE pubid, title FROM books;
D) both b and c
Correct Answer:
Verified
Correct Answer:
Verified
Q8: Structure of the ORDERS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1928/.jpg"
Q12: Which of the following is a mandatory
Q13: Contents of the BOOKS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1928/.jpg"
Q14: Contents of the BOOKS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1928/.jpg"
Q17: A(n)_ can consist of numbers,characters,or special symbols
Q27: If the results of a SELECT statement
Q60: A script file containing SQL statements can
Q69: Combining the contents of two or more
Q76: A(n)<u>WHERE</u> statement allows a user to retrieve
Q79: What are the mandatory clauses of a