Structure of the CUSTOMERS Table

question 62

Multiple Choice

Structure of the CUSTOMERS table
​
Structure of the ORDERS table
Structure of the ORDERITEMS table
Structure of the BOOKS table
-Which of the following SQL statements will display books that have not been ordered recently?​

• A) ​SELECT title FROM books,orderitems WHERE books.isbn <> orderitems.isbn;
• B) ​SELECT title FROM books NATURAL JOIN orderitems WHERE JOIN IS NULL;
• C) ​SELECT title FROM books NATURAL JOIN orderitems MINUS SELECT title FROM books;
• D) ​SELECT title FROM books MINUS SELECT title FROM books NATURAL JOIN orderitems;

---

Definitions:

Proposition

A declarative sentence that can be either true or false but not both.

Hypothetical Syllogism

A logical argument form where two conditional statements lead to a conclusion, essentially connecting the antecedent of one to the consequent of the other.

Modus Ponens

A form of deductive reasoning that allows one to conclude a certain proposition if a conditional statement (if-then) is true and its antecedent is true.

Modus Tollens

A form of logical argument where the denial of the consequent leads to the denial of the antecedent; typically structured as "If P, then Q. Not Q, therefore not P."