Database Concepts FC0-U71 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   What is the purpose of a primary key in a database table?

   • ATo uniquely identify each record in the table
   • BTo establish a relationship with another table
   • CTo store large amounts of text data
   • DTo speed up queries by creating an index
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which data type would be most appropriate for storing a person's date of birth?

   • AINTEGER
   • BBOOLEAN
   • CVARCHAR
   • DDATE
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which of the following best describes the primary purpose of a database?

   • ATo store and organize data in a structured way for efficient retrieval and management
   • BTo provide a user interface for entering data into spreadsheets
   • CTo create charts and graphs from raw data
   • DTo permanently store data in a format that cannot be modified
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A database has a table named Employees with columns EmployeeID (INT), FirstName (VARCHAR), LastName (VARCHAR), and Salary (DECIMAL). A manager wants to increase the salary of all employees in the 'Sales' department by 5%. However, the Employees table does not have a Department column. What should the manager do?

   • ACreate a new table with only Sales employees and update that table.
   • BRun an UPDATE statement that increases all salaries by 5% without any filter.
   • CAdd a Department column to the Employees table, then run an UPDATE statement that filters by Department = 'Sales'.
   • DUse a SELECT statement to find employees with high salaries and update them manually.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Why is encryption important for database security?

   • AIt prevents users from accidentally deleting data
   • BIt protects data from being read if it is intercepted or stolen
   • CIt creates backups of the database
   • DIt speeds up database queries
   Reveal Solution Discussion Select an answer first