Contents of BOOKS Table

question 109

Multiple Choice

Contents of BOOKS table
​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?

• A) ​SELECT title FROM books WHERE category = 'BUSINESS' OR 'COMPUTER' AND retail >35;
• B) ​SELECT title FROM books WHERE category = 'BUSINESS' OR category ='COMPUTER' AND retail >35;
• C) ​SELECT title FROM books WHERE (category = 'BUSINESS' OR category ='COMPUTER' )AND retail >35;
• D) ​SELECT title FROM books WHERE category = 'BUSINESS' OR category ='COMPUTER' AND (retail >35);

---

Definitions:

Chattel

Personal property that is movable, as opposed to real property or real estate.

Profit a Prendre

A right to take something (such as minerals, game, or timber) from another's land.

Easement

A right to cross or otherwise use someone else's land for a specified purpose.

House

A structure serving as a dwelling for one or more persons, especially for a family.