Contents of BOOKS Table

question 38

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 books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?

• A) ​SELECT * FROM books WHERE pubid = 1 OR pubid = 2 OR retail >= 42;
• B) ​SELECT * FROM books WHERE pubid IN (1,2)OR retail => 42;
• C) ​SELECT * FROM books WHERE pubid = 1 AND pubid=2 OR retail >=42;
• D) ​both a and b

---

Definitions:

Quota Rent

The earnings exceeding normal profits received by license holders when import quotas are in place.

Demand Price

The price of a good or service dictated by the desire and ability of consumers to purchase it at certain price levels.

Import Quota

A government-imposed limit on the quantity or monetary value of certain goods that can be imported into the country over a specified period of time.

Quota

A government-imposed trade restriction that limits the number or monetary value of goods that can be imported or exported during a specified period.