Skip to main content

Test Bank For A Guide to SQL, 8th Edition

Page 1

Chapter 1: Introduction to Premiere Products, Henry Books, and Alexamara Marina Group TRUE/FALSE 1. Premiere Products sells appliances, toys, and kitchen gadgets. ANS: F

PTS: 1

REF: 2

2. An example of a relationship between categories is the relationship that exists in the Premiere Products database between sales reps and customers. ANS: T

PTS: 1

REF: 2

3. At Premiere Products, the body of the order contains the order number and date; the customer’s number, name, and address; and the sales rep number and name. ANS: F

PTS: 1

REF: 3

4. At Premiere Products, the three sections of an order are the heading, body, and footing. ANS: T

PTS: 1

REF: 3

5. The overall order total is stored in the Premiere Products database. ANS: F

PTS: 1

REF: 3

6. The customer’s name and address and the number of the sales rep who represents the customer are stored with sales rep information. ANS: F

PTS: 1

REF: 3

7. The part description is stored with the information about parts. ANS: T

PTS: 1

REF: 3

8. All the sales representatives at Premiere Products get the same commission rate. ANS: F

PTS: 1

REF: 4

9. Each row in the ORDER_LINE table has an order number, part number, number ordered, quoted price, and total amount. ANS: F

PTS: 1

REF: 5


Turn static files into dynamic content formats.

Create a flipbook