Database Concepts FC0-U71 Practice Questions (Page 6)

Questions 26–30

1. 26expert · hard

   A financial firm stores sensitive client data in a database. The compliance team requires that data be protected both when stored and when transmitted over the network. The database administrator also needs to restrict access so that only certain employees can view salary information. Which set of measures should be implemented?

   • AGrant all employees full access to the database and rely on the firewall to block external threats.
   • BUse a strong password for the database administrator account and back up the database daily.
   • CNormalize the database to reduce redundancy and improve performance.
   • DEncrypt the database files and use TLS for network connections, and implement role-based access control.
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A database has an Authors table and a Books table. Each book is written by one author, and an author can write many books. The Books table currently has an AuthorID column. What is the purpose of the AuthorID column in the Books table?

   • AIt is a data type that stores the author's name.
   • BIt is an index that speeds up queries on the Books table.
   • CIt is a foreign key that links each book to its author.
   • DIt is a primary key that uniquely identifies each book.
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A library database has a Books table with ISBN, Title, Author, and PublicationYear. The ISBN is a unique 13-digit number assigned to each book. The librarian wants to ensure that no two books can have the same ISBN. Which constraint should be applied?

   • ADefault value of 0 for ISBN
   • BIndex on Title
   • CForeign key on ISBN referencing another table
   • DPrimary key on ISBN
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   A small business tracks customer orders in a single spreadsheet. Each row contains customer name, address, and order details, so the same customer's information appears in many rows. When a customer moves, the staff must update the address in every row for that customer, and they sometimes miss some. The business wants to move this data into a relational database to reduce this problem. Which database design change directly addresses the issue?

   • AUse a DBMS that automatically encrypts the spreadsheet file when it is saved.
   • BSplit customer data into a separate Customers table and reference it from an Orders table using a foreign key.
   • CAdd more columns to the spreadsheet for each possible order so all data fits in one row per customer.
   • DCreate a single table with all fields and use a composite primary key of customer name and order date.
   Reveal Solution Discussion Select an answer first
6. 30application · medium

   A database designer is normalizing a table that contains OrderID, CustomerName, CustomerAddress, ProductName, and ProductPrice. The designer notices that CustomerName and CustomerAddress repeat for every order by the same customer, and ProductName and ProductPrice repeat for every order of the same product. Which normalization step should be taken first?

   • ACreate separate Customers and Products tables, and link them to Orders with foreign keys.
   • BCombine all data into one large table to simplify queries.
   • CAdd a composite primary key of OrderID and ProductID to the existing table.
   • DRemove the CustomerName and ProductName columns because they are redundant.
   Reveal Solution Discussion Select an answer first