Interface table stores the foreign keys of the table having M:M relationships.

  1. True

  2. False


Correct Option: B

AI Explanation

To answer this question, you need to understand the concept of M:M (many-to-many) relationships in database design.

In a many-to-many relationship, multiple records from one table can be associated with multiple records from another table. To represent this relationship, an intermediary table, often called an "interface table" or a "join table," is used. This table contains the foreign keys of the tables involved in the relationship.

Therefore, the statement "Interface table stores the foreign keys of the table having M:M relationships" is incorrect.

Option A) True - This option is incorrect because the interface table stores the foreign keys of the tables involved in the M:M relationship, not just one of the tables.

Option B) False - This option is correct because the interface table stores the foreign keys of both tables involved in the M:M relationship, not just one of the tables.

The correct answer is B) False. This option is correct because the interface table stores the foreign keys of both tables involved in the M:M relationship.

Find more quizzes: