Table Relationships

Questions

Settings

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Quiz on Creating and Modifying Table Relationships.

Questions and Answers

1.

This feature ensures that relationships between records in related tables are valid and and that you don't accidentally delete or change related data.
- A.
  
  Referential Integrity
- B.
  
  Cascade Update Related Fields
- C.
  
  Cascade Delete Related Records
Correct Answer
A. Referential Integrity
2.

This feature enables deletion of all related records in the related tables when a record in the primary table is deleted.
- A.
  
  Referential Integrity
- B.
  
  Cascade delete related records
- C.
  
  Cascade update related fields
Correct Answer
B. Cascade delete related records
3.

This relationship is established when one record in a table has only one matching record in another table.
- A.
  
  One-to-one
- B.
  
  One-to-many
- C.
  
  Many-to-many
Correct Answer
A. One-to-one
4.

We can edit an existing relationship by clicking TOOLS then ____________.
- A.
  
  Relationships
- B.
  
  Primary Key
- C.
  
  Records
Correct Answer
A. Relationships
5.

This relationship is established when one record from a table is related to many matching records in other tables.
- A.
  
  One-to-one
- B.
  
  One-to-many
- C.
  
  Many-to-many
Correct Answer
B. One-to-many
6.

It is an association between two tables in which one record in either table can relate to many records in the other table.
- A.
  
  One-to-one
- B.
  
  One-to-many
- C.
  
  Many-to-many
Correct Answer
C. Many-to-many
7.

A one-to-many relationship is created if only one of the related columns is a ___________.
- A.
  
  Records
- B.
  
  Relationships
- C.
  
  Primary key
Correct Answer
C. Primary key
8.

It updates all related records in the related table or tables when a record in the primary table is changed.
- A.
  
  Cascade delete
- B.
  
  Cascade update
- C.
  
  Referential integrity
Correct Answer
B. Cascade update
9.

Table relationship is what makes a database relational.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True
10.

Table relationships can be enforced without activating cascade update related fields and cascade delete related records.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Jul 30, 2011

Quiz Edited by
ProProfs Editorial Team
Feb 02, 2010

Quiz Created by
Rizsess

Table Relationships

This feature ensures that relationships between records in related tables are valid and and that you don't accidentally delete or change related data.

This feature enables deletion of all related records in the related tables when a record in the primary table is deleted.

This relationship is established when one record in a table has only one matching record in another table.

We can edit an existing relationship by clicking TOOLS then ____________.

This relationship is established when one record from a table is related to many matching records in other tables.

It is an association between two tables in which one record in either table can relate to many records in the other table.

A one-to-many relationship is created if only one of the related columns is a ___________.

It updates all related records in the related table or tables when a record in the primary table is changed.

Table relationship is what makes a database relational.

Table relationships can be enforced without activating cascade update related fields and cascade delete related records.