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 UNIQUE pubid,title FROM books;
B) both b and c
C) SELECT DISTINCT pubid FROM books;
D) SELECT DISTINCT category FROM books;
Correct Answer:

Verified
Correct Answer:
Verified
Q9: To indicate which database table contains the
Q10: Which of the following symbols represents all
Q11: A(n)_ is an alternative column heading displayed
Q12: The DESCRIBE command is used to view
Q13: Choosing specific columns to be displayed by
Q15: Contents of the BOOKS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q16: Contents of the PUBLISHER table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q17: A(n)_ can consist of numbers,characters,or special symbols
Q18: Explain how the DISTINCT keyword effects a
Q19: Each section of a SQL command that