Database Concepts: Relational vs. Non-Relational, Tables, Rows, Fields, Primary/foreign Keys. IT-FUNDAMENTALS-ITF-CERTIFICATION Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

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

   • ATo establish a relationship between two tables by referencing the primary key of another table.
   • BTo speed up queries by creating an index on a column.
   • CTo uniquely identify each row within its own table.
   • DTo store encrypted data for security purposes.
   Reveal Solution Discussion Select an answer first
2. 17application · easy

   In a school database, the 'Students' table has columns: StudentID, Name, Grade, and HomeroomTeacher. A new student named Alex joins the school. What is added to the table to represent Alex's data?

   • AA new column
   • BA new primary key
   • CA new table
   • DA new row
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which of the following would be the most appropriate primary key for a table storing customer information?

   • APhoneNumber
   • BAddress
   • CFirstName
   • DCustomerID
   Reveal Solution Discussion Select an answer first
5. 19application · easy

   A company's employee database has a table named 'Employees'. The table contains columns: EmployeeID, FirstName, LastName, Department, and Salary. A manager wants to find the department of employee with EmployeeID 104. In this context, what is 'Department'?

   • AA primary key for the table
   • BA row in the table
   • CA field in the table
   • DA separate table
   Reveal Solution Discussion Select an answer first
6. 20application · easy

   An online store has an 'Orders' table and a 'Customers' table. The 'Customers' table has a primary key 'CustomerID'. The 'Orders' table has 'OrderID', 'OrderDate', and 'CustomerID'. What is the role of the 'CustomerID' column in the 'Orders' table?

   • AIt is a redundant column that duplicates data from the Customers table.
   • BIt is the primary key of the Orders table.
   • CIt is a secondary index used to speed up queries on the Orders table.
   • DIt is a foreign key that links each order to a specific customer.
   Reveal Solution Discussion Select an answer first