A Guide to MySQL - Complete Test test bank - exam questions - quizzes (updated 2022)

Chapter 1: Introduction to Premiere Products, Henry Books, and Alexamara
Marina Group




TRUE/FALSE



1. Premiere Products sells software, hardware, and appliances.


ANS: F PTS: 1 REF: 2



2. The Premiere Products order form was not created in MySQL.


ANS: T PTS: 1 REF: 3



3. The overall order total is stored in the Premiere Products database.


ANS: F PTS: 1 REF: 4



4. All the sales representatives at Premiere Products get the same commission rate.


ANS: F PTS: 1 REF: 4



5. At Premiere Products, the three sections of an order are the top, body, and bottom.


ANS: T PTS: 1 REF: 4



6. 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

, 7. The Premiere Products database includes four tables.


ANS: F PTS: 1 REF: 4-5



8. Because Premiere Products wants the flexibility to quote and charge different prices to different
customers, the QUOTED_PRICE column is included in the ORDER_LINE table.


ANS: T PTS: 1 REF: 8



9. In the Henry Books database. the AUTHOR table contains the author's number, name, and
address.


ANS: F PTS: 1 REF: 10



10. Each branch of Henry Books has a number that uniquely identifies the branch.


ANS: T PTS: 1 REF: 8



11. At Alexamara Marina Group, marina slips are numbered within each section.


ANS: T PTS: 1 REF: 16



12. The WROTE table in the Henry Books database relates publishers and books.


ANS: F PTS: 1 REF: 12



13. The Henry Books database uses a two-digit number to represent the publisher code.


ANS: F PTS: 1 REF: 9

,14. The BOOK table at Henry Books includes the author number.


ANS: F PTS: 1 REF: 11



15. The INVENTORY table at Henry Books includes a column that stores the number of books on
hand.


ANS: T PTS: 1 REF: 12



16. The Alexamara Marina Group database uses two uppercase letters to represent an owner number.


ANS: F PTS: 1 REF: 15



17. Alexamara provides a variety of boat repair and maintenance services to the boat owners.


ANS: T PTS: 1 REF: 15



18. The LENGTH column in the MARINA_SLIP table in the Alexamara Marina Group stores the
length of the slip in feet.


ANS: T PTS: 1 REF: 16



19. The Unix operating system is an example of a popular open source program.


ANS: F PTS: 1 REF: 20



20. To work with a database in a computer, you must use a database management system.


ANS: T PTS: 1 REF: 20

, 21. 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



22. The part description is stored with the information about parts.


ANS: T PTS: 1 REF: 4



23. SQL stands for Syntactical Question Language.


ANS: F PTS: 1 REF: 20



24. Each author is uniquely identified by his or her AUTHOR_NUM.


ANS: T PTS: 1 REF: 10



25. The BRANCH table is used to indicate the number of copies of a particular book that are
currently on hand at a particular branch of Henry Books.


ANS: F PTS: 1 REF: 12



26. The AUTHOR table is used to relate books and authors.


ANS: F PTS: 1 REF: 12



27. 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