Structure of the BOOKS Table

question 53

Multiple Choice

Structure of the BOOKS table
Structure of the PUBLISHER table
-Which of the following SQL statements will display the name of each publisher that publishes a book classified in the COMPUTER category?​

• A) SELECT UNIQUE name FROM books,publisher;
• B) SELECT UNIQUE name FROM books NATURAL JOIN publisher WHERE category = 'COMPUTER';
• C) SELECT DISTINCT name FROM books JOIN publisher WHERE category = 'COMPUTER';
• D) ​both b and c

---

Definitions:

Common

Occurring often or widely accepted; prevalent or usual.

General

Refers to something that applies broadly or commonly, without being restricted to specifics or details.

Reason Abstractly

The capacity to contemplate concepts, principles, and entities that are not tangible or visible.

Information Processing

The way individuals encode, store, and retrieve information, drawing similarities between the mind's functioning and computer operations.