Data Models into Database Designs - Database MCQ Questions and answers- Technical Aptitude Page-3 section-1

21.
A foreign key is used to implement relationships between tables.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

22.
The terms alternate key and candidate key mean the same thing.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

23.
In 1:N relationships, which entity becomes the parent entity is arbitrary.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

24.
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

25.
In a 1:1 relationship, the primary key placement is arbitrary.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

26.
When the parent entity is required, a new child row can always be inserted.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

27.
All primary keys are required.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

28.
Intersection tables are ID-dependent on both their parent tables.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

29.
For every relationship, there are six possible sets of minimum cardinalities.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

30.
An intersection table is required to represent M:N relationships.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

Data Models into Database Designs - Database MCQ Questions and answers- Technical Aptitude

21. A foreign key is used to implement relationships between tables.

Answer & Solution

22. The terms alternate key and candidate key mean the same thing.

Answer & Solution

23. In 1:N relationships, which entity becomes the parent entity is arbitrary.

Answer & Solution

24. When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

Answer & Solution

25. In a 1:1 relationship, the primary key placement is arbitrary.

Answer & Solution

26. When the parent entity is required, a new child row can always be inserted.

Answer & Solution

27. All primary keys are required.

Answer & Solution

28. Intersection tables are ID-dependent on both their parent tables.

Answer & Solution

29. For every relationship, there are six possible sets of minimum cardinalities.

Answer & Solution

30. An intersection table is required to represent M:N relationships.

Answer & Solution

21.
A foreign key is used to implement relationships between tables.

22.
The terms alternate key and candidate key mean the same thing.

23.
In 1:N relationships, which entity becomes the parent entity is arbitrary.

24.
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

25.
In a 1:1 relationship, the primary key placement is arbitrary.

26.
When the parent entity is required, a new child row can always be inserted.

27.
All primary keys are required.

28.
Intersection tables are ID-dependent on both their parent tables.

29.
For every relationship, there are six possible sets of minimum cardinalities.

30.
An intersection table is required to represent M:N relationships.