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:

Vision

A company's long-term aspirations, detailing what it hopes to achieve or accomplish in the future.

Idea

A thought or suggestion as to a possible course of action, concept, or mental impression.

Objective

A specific result that a person or system aims to achieve within a time frame and with available resources.

Goal

A desired result or achievement toward which effort is directed; an aim or end.