Database Management Systems & Architecture Chapter Exam

Exam Instructions:

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

Page 1

Question 1 1. How would you remove the following transitive dependency for the table Customer, with fields CustomerID, CustomerCity and CustomerZipCode?

Question 2 2. What does a database model provide?

Question 3 3. Where is a multi-user database typically located?

Question 4 4. Which of the following database models uses parent-child relationships where each child can have multiple parents?

Question 5 5. What are the three fundamental elements of a database management system?

Page 2

Question 6 6. Can 3NF go too far?

Question 7 7. Which of the following is an advantage of a hierarchical data model?

Question 8 8.

The Customer table has the following fields: CustomerID, CustomerFirstName, CustomerLastName, CustomerZipCode, and CustomerCityName.

Which fields have a transitive dependency?

Question 9 9. Which of the following DBMS models would be used to manage a collection of audio files ?

Question 10 10. What makes a relational database so effective ?

Page 3

Question 11 11. Which of the following is NOT a potential advantage of a database management system (DBMS)?

Question 12 12.

In the following table (artist), which fields have a transitive dependency?

artistIDartistNamecountryCodegenreCodedateAdded

Question 13 13. A table is considered to be in third normal form when it is in second normal form and:

Question 14 14. What does the acronym DBMS stand for?

Question 15 15. The database administrator has already set permissions for several people to use the system. Three of the users need to be able to use the database at the same time. What function does the administrator need to set?

Database Management Systems & Architecture Chapter Exam Instructions

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

Big Data Tutorial & Training  /  Business Courses
Support