Data Management Tasks DS0-001 Practice Questions (Page 3)

Questions 11–14

1. 11foundation · easy

   Which database design technique is specifically used to minimize data redundancy?

   • APartitioning
   • BDenormalization
   • CIndexing
   • DNormalization
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   You are designing a database for a library. A book can have multiple authors, and an author can write multiple books. You need to establish a relationship between the BOOKS and AUTHORS tables. What is the correct approach?

   • AStore a list of author names in a single column in the BOOKS table.
   • BAdd a BookID foreign key to the AUTHORS table.
   • CAdd an AuthorID foreign key to the BOOKS table.
   • DCreate a junction table BOOK_AUTHORS with composite primary key (BookID, AuthorID).
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   You are designing a database for a hospital. A patient can have multiple appointments, and each appointment is with one doctor. A doctor can have many appointments. What is the correct way to model the relationship between PATIENTS, DOCTORS, and APPOINTMENTS?

   • AAdd a DoctorID foreign key to the PATIENTS table.
   • BCreate an APPOINTMENTS table with PatientID and DoctorID as foreign keys.
   • CAdd a PatientID foreign key to the DOCTORS table.
   • DCreate a junction table between PATIENTS and DOCTORS only.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What is a view in a relational database?

   • AA physical copy of a table stored separately
   • BA backup of the database
   • CA stored query that presents data as a virtual table
   • DA type of index
   Reveal Solution Discussion Select an answer first