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:

Customer-Facing

Customer-Facing refers to functions, activities, or interactions that directly involve or impact the customer, typically aimed at improving service, support, and satisfaction.

CRM Application

Customer Relationship Management application, software that helps businesses manage interactions and relationships with customers, improve engagement, and streamline processes.

Near Field Communications

A set of communication protocols that enable two electronic devices, one of which is often a portable device such as a smartphone, to establish communication by bringing them within a few centimeters of each other.

Showrooming

The practice of examining merchandise in a traditional brick-and-mortar retail store without purchasing it, then shopping online to buy the same item at a lower price.