nerdexam
CompTIACompTIA

DA0-001 · Question #432

DA0-001 Question #432: Real Exam Question with Answer & Explanation

The correct answer is D: Many-to-many. A joining table is used to resolve a many-to-many relationship in relational databases. Since many-to-many relationships cannot be directly implemented in relational database tables, a joining table acts as a bridge between the two related tables, containing foreign keys that mod

Data Concepts and Environments

Question

Which of the following relationships is necessary to define a third table called a "joining table" in relational databases?

Options

  • AOne-to-many
  • BOne-to-one
  • CNon-relational
  • DMany-to-many

Explanation

A joining table is used to resolve a many-to-many relationship in relational databases. Since many-to-many relationships cannot be directly implemented in relational database tables, a joining table acts as a bridge between the two related tables, containing foreign keys that modeled and queried.

Topics

#Relational databases#Many-to-many relationships#Joining tables#Database design

Community Discussion

No community discussion yet for this question.

Full DA0-001 PracticeBrowse All DA0-001 Questions