Database Concepts FC0-U71 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   What does data integrity refer to in a database?

   • AThe accuracy, consistency, and reliability of data throughout its lifecycle
   • BThe visual design of the database interface
   • CThe speed at which data can be retrieved from the database
   • DThe physical security of the database server
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A school wants to store information about courses and the instructors who teach them. Each course is taught by exactly one instructor, but an instructor can teach multiple courses. Which table structure correctly models this relationship?

   • AA single table with all course and instructor fields, using the instructor name as the primary key.
   • BA Courses table with an InstructorID foreign key that references the Instructors table.
   • CA separate junction table with CourseID and InstructorID as a composite primary key.
   • DAn Instructors table with a CourseID foreign key that references the Courses table.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is the main goal of database normalization?

   • ATo increase the number of tables in a database
   • BTo encrypt all data in the database
   • CTo reduce data redundancy and improve data integrity
   • DTo make queries run faster by denormalizing data
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   In a relational database, what is the term for a single record in a table?

   • APrimary key
   • BRow
   • CColumn
   • DSchema
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which SQL statement is used to retrieve data from a database?

   • AINSERT
   • BSELECT
   • CUPDATE
   • DDELETE
   Reveal Solution Discussion Select an answer first