Database Concepts FC0-U71 Practice Questions (Page 7)

Questions 31–35

1. 31foundation · easy

   Which of the following is a problem that normalization helps to solve?

   • ASlow network connections between users
   • BInsufficient storage space on the server
   • CLack of user interface design
   • DData redundancy leading to update anomalies
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   What is the purpose of the WHERE clause in a SQL query?

   • ATo join two tables together
   • BTo sort the results in ascending order
   • CTo group rows that have the same values
   • DTo filter records based on specified conditions
   Reveal Solution Discussion Select an answer first
4. 33application · medium

   A company uses a database to manage inventory. Several employees need to add, update, and query product data, but they should not be able to delete records. The manager wants to ensure that all changes are logged and that concurrent updates do not corrupt data. Which component provides these capabilities?

   • AThe Database Management System (DBMS)
   • BThe SQL SELECT statement
   • CThe primary key constraint on the product ID
   • DThe database backup file
   Reveal Solution Discussion Select an answer first
5. 34foundation · easy

   What is the purpose of access control in database security?

   • ATo monitor network traffic for intrusions
   • BTo restrict which users can view or modify data
   • CTo back up data regularly
   • DTo encrypt data at rest and in transit
   Reveal Solution Discussion Select an answer first
6. 35foundation · easy

   What is the purpose of a foreign key in a relational database?

   • ATo speed up query performance by creating an index
   • BTo establish a relationship between two tables by referencing the primary key of another table
   • CTo store encrypted data in a table
   • DTo uniquely identify each record in the same table
   Reveal Solution Discussion Select an answer first