Free CompTIA Tech+ FC0-U71 Practice Question

A company has two tables in their database: 'Employees' and 'Departments'. Each employee is assigned to one department. To ensure that the 'Employees' table references the correct department data, what kind of special field should be included in the 'Employees' table?

  • A composite key made from combining employee and department data

  • A unique key in the 'Employees' table for each department

  • A foreign key that references the 'Departments' primary key

  • An additional primary key in the 'Employees' table for department data

This question's topic:
CompTIA Tech+ FC0-U71 / 
Data and Database Fundamentals
Your Score:

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot