Multiple choice technology databases

What is true about FOREIGN KEY constraint? Choose all that apply

  1. Defines relations between the tables

  2. The table that includes the foreign key is called the dependent or child table

  3. The table that includes the foreign key is called the parent table

  4. The table that is referenced by the foreign key is called the parent table

  5. The table that is referenced by the foreign key is called the dependent or child table
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

A foreign key establishes a relationship between two tables, ensuring referential integrity. The table containing the foreign key is the dependent or child table, while the referenced table containing the primary or unique key is the parent table, confirming the selected options.

Keep practicing — related questions