Structure of the BOOKS Table

question 95

Multiple Choice

Structure of the BOOKS table
Structure of the PUBLISHER table
-​Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table,as well as the name of the contact person and the phone number to call to reorder the book?

• A) SELECT title,cost,contact,phone FROM publisher,books;
• B) SELECT title,cost,contact,phone FROM publisher JOIN books USING (pubid);
• C) SELECT title,cost,contact,phone FROM publisher JOIN books USING (isbn);
• D) SELECT title,cost,contact,phone FROM publisher JOIN books USING (contact);

---

Definitions:

Scarcity

The fundamental economic problem of having seemingly unlimited human wants in a world with limited resources, leading to the necessity of choice.

Economic Problem

The fundamental issue of having limited resources to meet unlimited wants and needs, requiring choices and priorities in allocation.

Available Resources

The total assets, both natural and man-made, that can be utilized to produce goods and services.

Production Possibilities Curve

A graph that shows the maximum number of possible units a company can produce if it only produces two types of goods.