Database Concepts FC0-U71 Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   Which of the following is a common method used to maintain data integrity in a database?

   • AStoring all data in a single large table
   • BDisabling all validation checks to speed up data entry
   • CEnforcing constraints such as primary keys and foreign keys
   • DAllowing duplicate records to exist in tables
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A database has a Students table and an Enrollments table. Each enrollment record includes a StudentID that must refer to an existing student. The administrator wants to prevent anyone from entering an enrollment for a student who does not exist. Which database feature enforces this rule?

   • AA primary key constraint on Enrollments.EnrollmentID.
   • BAn index on Enrollments.StudentID to speed up lookups.
   • CA foreign key constraint on Enrollments.StudentID referencing Students.StudentID.
   • DA default value of 0 for Enrollments.StudentID.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which of the following is a required characteristic of a primary key?

   • AIt must be the first column in the table
   • BIt must be automatically generated by the database
   • CIt must be a numeric value
   • DIt must be unique for each record and cannot be NULL
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A database administrator is designing a table to store employee information. Each employee must have a unique identifier that never changes, even if the employee's name or department changes. Which column should be designated as the primary key?

   • AEmployeeID, an auto-incrementing integer assigned when the employee is hired.
   • BHireDate, because it is set once and never changes.
   • CDepartment, because it groups employees by team.
   • DLastName, because it is easy to remember and type.
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   Which data type is best suited for storing a product price like $19.99?

   • AVARCHAR
   • BDECIMAL
   • CINTEGER
   • DBOOLEAN
   Reveal Solution Discussion Select an answer first