Database Concepts FC0-U71 Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A database stores product prices. The prices can have up to two decimal places, such as 19.99 or 129.95. Which data type is most appropriate for the Price column?

   • ADECIMAL(10,2)
   • BFLOAT
   • CINT
   • DVARCHAR(10)
   Reveal Solution Discussion Select an answer first
2. 7expert · hard

   A database designer is normalizing a table that stores order data. The current table has OrderID, CustomerName, CustomerAddress, ProductName, ProductPrice, and Quantity. The designer wants to eliminate redundancy and ensure that each fact is stored only once. Which design best achieves this?

   • ACreate separate Customers, Products, and Orders tables, with an OrderDetails table linking Orders and Products.
   • BKeep the single table but add a composite primary key of OrderID and ProductID.
   • CCreate a single table with all fields and use CustomerName as the primary key.
   • DCreate separate Customers and Products tables, but keep OrderID and Quantity in the Orders table.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A hospital stores patient records in a database. The IT department wants to ensure that only authorized medical staff can view patient data, and that the data is protected even if the physical storage device is stolen. Which combination of measures should be implemented?

   • AA strong password for the database administrator account only.
   • BRegular backups of the database to an external drive.
   • CUser authentication and role-based access control, plus encryption of the database files.
   • DNormalization of the patient data into multiple tables.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   An online store has a Customers table and an Orders table. Each order must be linked to exactly one customer, and a customer can have many orders. Which column should be added to the Orders table to establish this relationship?

   • ACustomerName, which is copied from the Customers table.
   • BOrderDate, which records when the order was placed.
   • COrderID, which is the primary key of the Orders table.
   • DCustomerID, which references the primary key of the Customers table.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which of the following best describes the structure of a relational database?

   • AA collection of tables composed of rows and columns, where relationships are defined between tables
   • BA flat file where all data is stored in a single list
   • CA graph of nodes and edges representing data relationships
   • DA hierarchical tree structure where each record has one parent
   Reveal Solution Discussion Select an answer first