Structure of the BOOKS Table

question 14

Multiple Choice

Structure of the BOOKS table
Structure of the PUBLISHER table
-Which of the following will display the title,publication date,and publisher name of each book in the BUSINESS category?​

• A) SELECT title,pubdate,name FROM publisher JOIN books USING (pubid) WHERE category = 'BUSINESS';
• B) SELECT title,pubdate,name FROM publisher JOIN books ON (pubid) WHERE category = 'BUSINESS';
• C) SELECT title,pubdate,name FROM publisher OUTER JOIN books USING (pubid) WHERE category = 'BUSINESS';
• D) SELECT title,pubdate,name FROM publisher CROSS JOIN books USING (pubid) WHERE category = 'BUSINESS';

---

Definitions:

Profit Difference

The variance between the estimated profit and the actual profit realized, indicating effectiveness of financial management and operations.

Weight Allocation

Weight allocation refers to the method of assigning proportions of a total, such as costs or resources, based on the relative weight or importance of various components or activities.

Physical Units Method

An inventory costing method that allocates costs based on the actual physical units of goods available for sale or use.

By-Product

A secondary product derived from the manufacturing process or chemical reaction that is incidental to the main product.