Archives

Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group Cengage Learning Testing, Powered by Cognero Page 1 1. TAL Distributors sells appliances, toys, and kitchen gadgets. a. True b. False ANSWER: False POINTS: 1 REFERENCES: 2 […]

Chapter 2: Database Design Fundamentals Cengage Learning Testing, Powered by Cognero Page 1 True / False 1. The process of determining the particular tables and columns that will comprise a database is known as database design. a. True b. False […]

Chapter 3: Creating Tables Cengage Learning Testing, Powered by Cognero Page 1 True / False 1. SQL was developed as the data manipulation language for IBM’s prototype relational model DBMS, System R. a. True b. False ANSWER: True POINTS: 1 […]

Chapter 4: Single-Table Queries Cengage Learning Testing, Powered by Cognero Page 1 True / False 1. A query is a question represented in a way that the DBMS can understand. a. True b. False ANSWER: True POINTS: 1 REFERENCES: 97 […]

Chapter 5: Multiple-Table Queries Cengage Learning Testing, Powered by Cognero Page 1 True / False 1. When joining tables, it is always necessary to qualify a column name. a. True b. False ANSWER: False POINTS: 1 REFERENCES: 134 2. You […]

Chapter 6: Updating Data Cengage Learning Testing, Powered by Cognero Page 1 1. You can create a new table using data in an existing table. a. True b. False ANSWER: True POINTS: 1 REFERENCES: 167 2. The command, CREATE TABLE […]

Chapter 7: Database Administration Cengage Learning Testing, Powered by Cognero Page 1 1. Most database management systems support the creation of views. a. True b. False ANSWER: True POINTS: 1 REFERENCES: 191 2. A view is a derived table. a. […]

Chapter 8: SQL Functions and Procedures Cengage Learning Testing, Powered by Cognero Page 1 1. In procedural languages, you can accomplish many tasks using a single command. a. True b. False ANSWER: False POINTS: 1 REFERENCES: 228 2. When you […]

A Guide to SQL, Ninth Edition Solutions 3-1 Chapter 3: An Introduction to SQL Solutions Answers to Review Questions 1. Use the CREATE TABLE command to create a table by typing the table name and then listing 4. Best Data […]

A Guide to SQL, Ninth Edition Instructor’s Manual Page 1–1 Chapter 1 Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group ©2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in […]

A Guide to SQL, Ninth Edition Solutions 1-1 Chapter 1: An Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group Solutions Answers to Review Questions Due to the nature of the material in Chapter 1, there are no […]

A Guide to SQL, Ninth Edition Page 2–1 Chapter 2 Database Design Fundamentals ©2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed […]

A Guide to SQL, Ninth Edition Solutions 2-1 Chapter 2: Database Design Fundamentals Solutions Answers to Review Questions 1. An entity is a person, place, thing, or event. 3. A relationship is an association between tables (entities). A one-to-many relationship […]

A Guide to SQL, Ninth Edition Page 3–1 Chapter 3 Creating Tables ©2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with […]

A Guide to SQL, Ninth Edition Page 4–1 Chapter 4 Single-Table Queries ©2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with […]

A Guide to SQL, Ninth Edition Solutions 4-1 Chapter 4: Single-Table Queries Solutions Answers to Review Questions 1. The basic form of the SELECT command is SELECT-FROM. Specify the columns to be listed 2. Simple conditions are written in the […]

A Guide to SQL, Ninth Edition Page 5–1 Chapter 5 Multiple-Table Queries ©2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with […]

A Guide to SQL, Ninth Edition Solutions 5-1 Chapter 5: Multiple-Table Queries Solutions Answers to Review Questions 1. Indicate in the SELECT clause all columns to display, list in the FROM clause all 2. You must qualify names if the […]

A Guide to SQL, Ninth Edition Solutions 5–13 SELECT RESERVATION_ID, TRIP_ID, TRIP_DATE FROM RESERVATION 8. SELECT LAST_NAME, FIRST_NAME FROM GUIDE, TRIP, TRIP_GUIDES WHERE TRIP.TRIP_ID = TRIP_GUIDES.TRIP_ID AND GUIDE.GUIDE_NUM = TRIP_GUIDES.GUIDE_NUM AND TYPE = ‘Paddling’; 9. SELECT LAST_NAME, FIRST_NAME FROM GUIDE […]

A Guide to SQL, Ninth Edition Page 6–1 Chapter 6 Updating Data ©2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with […]

A Guide to SQL, Ninth Edition Solutions 6-1 4. UPDATE 5. DELETE 6. COMMIT. In SQL Server, the command is COMMIT TRANSACTION. 7. ROLLBACK. Any updates that have not been committed will be reversed. In SQL Server, the command is […]

A Guide to SQL, Ninth Edition Page 7–1 Chapter 7 Database Administration ©2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with […]

A Guide to SQL, Ninth Edition Solutions 7-1 Chapter 7: Database Administration Solutions Answers to Review Questions 2. CREATE VIEW. 3. A defining query is the portion of the CREATE VIEW command that describes the data to include in the […]

A Guide to SQL, Ninth Edition Page 8–1 Chapter 8 SQL Functions and Procedures ©2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license […]

A Guide to SQL, Ninth Edition Solutions 8-1 Chapter 8 SQL Functions and Procedures Solutions Answers to Review Questions 1. Use the UPPER function to convert letters to uppercase (Oracle and SQL Server). In 2. Use the ROUND function to […]