Test Bank For A Guide to SQL - 9th - 2015 All Chapters - 9781111527273

,Test Bank For A Guide to SQL
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

1. TAL Distributors sells appliances, toys, and kitchen gadgets.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 2

2. An example of a relationship between categories is the relationship that exists in the TAL Distributors database
between sales reps and customers.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: 2

3. At TAL Distributors, 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.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 3

4. At TAL Distributors, the three sections of an order are the heading, body, and footing.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: 3

5. The overall order total is stored in the TAL Distributors database.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 4

6. The customer’s name and address and the number of the sales rep who represents the customer are stored with sales rep
information.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 4


1

,Test Bank For A Guide to SQL
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group


7. The item description is stored with the information about items.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: 4

8. All the sales representatives at TAL Distributors get the same commission rate.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 4

9. Each row in the ORDER_LINE table has an order number, item number, number ordered, quoted price, and total
amount.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 5

10. The TAL Distributors database includes four tables.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 4/5

11. The ORDER_LINE table in the TAL Distributors database contains information about the date an order was placed.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 5

12. In some database systems, the word “order” has a special purpose.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: 6



2

, Test Bank For A Guide to SQL
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

13. Because TAL Distributors wants the flexibility to quote and charge different prices to different customers, the
QUOTED_PRICE column is included in the ORDER_LINE table.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: 8

14. Each trip that Colonial Adventure Tours offers has a number that uniquely identifies the trip.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: 9

15. The Colonial Adventure Tours database uses a two-digit number to represent the guide number.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 9

16. In the Colonial Adventure Tours database, the GUIDE table contains the guide’s number, name, address, and salary.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 9

17. Each guide is uniquely identified by his or her GUIDE_NUM.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: 9

18. The TRIP table at Colonial Adventure Tours includes the guide number.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 10

19. The TRIP table in the Colonial Adventure Tours database includes a column for the trip cost.


3