FC0-U61 · Question #8
Which of the following describes something in a database that refers to the unique identifier in the parent table?
The correct answer is C. Foreign key. A foreign key is a column or a set of columns in a table that refers to the unique identifier (or primary key) in another table. A foreign key establishes a relationship between two tables and ensures referential integrity. For example, in a database that stores information about
Question
Which of the following describes something in a database that refers to the unique identifier in the parent table?
Options
- AAttribute
- BConstraint
- CForeign key
- DSchema
How the community answered
(24 responses)- A4% (1)
- C92% (22)
- D4% (1)
Explanation
A foreign key is a column or a set of columns in a table that refers to the unique identifier (or primary key) in another table. A foreign key establishes a relationship between two tables and ensures referential integrity. For example, in a database that stores information about students and courses, the student table may have a column called student_id that is the primary key for each student record. The course table may have a column called student_id that is the foreign key that refers to the student_id in the student table. This way, the database can link each course record to the corresponding student record.
Topics
Community Discussion
No community discussion yet for this question.