True Or False

Question 1 :

A foreign key is used to implement relationships between tables.


A). True
B). False
Answer : Option A

Question 2 :

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


A). True
B). False
Answer : Option A

Question 3 :

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


A). True
B). False
Answer : Option B

Question 4 :

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 : Option A

Question 5 :

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


A). True
B). False
Answer : Option A

Question 6 :

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


A). True
B). False
Answer : Option B

Question 7 :

All primary keys are required.


A). True
B). False
Answer : Option A

Question 8 :

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


A). True
B). False
Answer : Option A

Question 9 :

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


A). True
B). False
Answer : Option B

Question 10 :

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


A). True
B). False
Answer : Option A

Question 11 :

The DBMS allows surrogate keys to be changed.


A). True
B). False
Answer : Option B

Question 12 :

Cascading updates refers to child rows being automatically deleted when a parent row is deleted.


A). True
B). False
Answer : Option B

Question 13 :

When transforming an entity-relationship model into a relational database design, each entity is represented as a table.


A). True
B). False
Answer : Option A

Question 14 :

Surrogate keys have much meaning for users.


A). True
B). False
Answer : Option B

Question 15 :

When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.


A). True
B). False
Answer : Option A

Question 16 :

(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.


A). True
B). False
Answer : Option B

Question 17 :

When the parent entity is required and the parent has a surrogate key, update actions can be ignored.


A). True
B). False
Answer : Option A

Question 18 :

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


A). True
B). False
Answer : Option A

Question 19 :

For every relationship, there are six possible referential integrity actions.


A). True
B). False
Answer : Option A

Question 20 :

An ideal primary key is short, numeric and seldom changing.


A). True
B). False
Answer : Option A