Barc cse 2023 online exam

Question

Which of the following are true

a. A relational table can have atmost one foreign key

b. The main purpose of foreign key is to optimize the queries by query optimizer.

Answer 1

Both statements are false.

a. A relational table can have more than one foreign key. It is not necessary to have atmost one foreign key.

b. The main purpose of foreign key is not to optimize the queries by query optimizer. It may help but main purpose is to enforce referential integrity between tables.