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:

Severe Punishment

A form of harsh discipline intended to correct or deter undesirable behaviors.

Fear

A distressing emotion aroused by impending danger, evil, or pain, whether the threat is real or imagined.

Anger

A strong feeling of annoyance, displeasure, or hostility triggered by what one perceives as wrong or threatening.

Magnitude

The size, extent, or importance of something, often quantifiable and used in various contexts to indicate scale or degree.