Database Use FC0-U71 Practice Questions (Page 4)

Questions 16–20

1. 16application · medium

   A company stores customer payment information in a database. To protect this sensitive data from unauthorized access, which security measure should be implemented?

   • AEncrypting the data at rest and in transit
   • BIncreasing the database cache size
   • CUsing a faster CPU for the database server
   • DRegularly defragmenting the database files
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A database has a 'orders' table with a foreign key referencing 'customers'. An attempt is made to delete a customer who has existing orders. What is the most likely outcome if referential integrity is enforced?

   • AThe delete will fail because the customer is referenced by orders.
   • BThe customer and all their orders will be deleted automatically.
   • CThe customer will be deleted, and the orders will remain with a NULL customer reference.
   • DThe delete will succeed, and the orders will become orphaned.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A database has a 'products' table with a primary key on 'product_id'. An application attempts to insert a new product with a product_id that already exists. What will happen?

   • AThe database will create a new table to store the duplicate.
   • BThe new row will overwrite the existing row.
   • CThe insert will fail because the primary key constraint enforces uniqueness.
   • DThe insert will succeed and create a duplicate row.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   An employee has left the company and their record must be removed from the 'employees' table. The employee's ID is 245. Which SQL statement should be used?

   • ADELETE FROM employees;
   • BUPDATE employees SET employee_id = NULL WHERE employee_id = 245;
   • CDROP TABLE employees;
   • DDELETE FROM employees WHERE employee_id = 245;
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A small business needs to store customer and order data with relationships between them. They want a system that enforces referential integrity and supports complex queries. Which type of database management system is most appropriate?

   • ARelational database management system (RDBMS)
   • BGraph database
   • CDocument database
   • DKey-value store
   Reveal Solution Discussion Select an answer first