Contents of BOOKS Table

question 4

Multiple Choice

Contents of BOOKS table
​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will return the category and title of all books stored in the BOOKS table presented in order of their category and,for the books in the same category,sort the title of the books in descending order?

• A) ​SELECT category,title FROM books ORDERED BY 1,2 DESC;
• B) ​SELECT category,title FROM books ORDER BY 1 ASC,2 DESC;
• C) ​SELECT category,title FROM books SORTED BY 1 ASC,2 DESC;
• D) ​SELECT category,title FROM books SORT BY 1,2 DESC;

---

Definitions:

Job Applicants

Individuals who apply for a position of employment, offering their skills and qualifications for consideration by an employer.

Sweepstakes

A type of contest or promotion where prizes are awarded to participants selected by random drawing.

False Positives

Instances where a test incorrectly indicates the presence of a condition or attribute.

Disease Test

A medical test performed to detect the presence or absence of a disease in an individual.