Database Fundamentals — Question 63

Which two keys establish a relationship between two tables? (Choose two.)

Answer options

• A. candidate
• B. foreign
• C. superkey
• D. local
• E. primary

Correct answer: B, E

Explanation

The foreign key is used to link two tables by referencing the primary key of another table, thus establishing the relationship. The primary key uniquely identifies each record within its own table, making it essential for relationships, while candidate keys, superkeys, and local keys do not specifically serve this relational purpose.