36 + Mcqs in Data Models Into Database Designs Page 1 McqOptions

1.	Which is true about surrogate keys?
A.	They are short.
B.	They are fixed.
C.	They have meaning to the user.
D.	They are numeric.
Answer» D. They are numeric.

Discussion

2.	An ideal primary key is short, numeric and seldom changing.%!
A.	True
B.	False
Answer» B. False

Discussion

3.	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» B. False

Discussion

4.	An intersection table is required to represent M:N relationships.%!
A.	True
B.	False
Answer» B. False

Discussion

5.	In a 1:1 relationship, the primary key placement is arbitrary.%!
A.	True
B.	False
Answer» B. False

Discussion

6.	For every relationship, there are six possible referential integrity actions.%!
A.	True
B.	False
Answer» B. False

Discussion

7.	Surrogate keys have much meaning for users.%!
A.	True
B.	False
Answer» C.

Discussion

8.	For every relationship, there are six possible sets of minimum cardinalities.%!
A.	True
B.	False
Answer» C.

Discussion

9.	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» B. False

Discussion

10.	When the parent entity is required, a new parent row can always be inserted.%!
A.	True
B.	False
Answer» B. False

Discussion

11.	When transforming an entity-relationship model into a relational database design, each entity is represented as a table.%!
A.	True
B.	False
Answer» B. False

Discussion

12.	Intersection tables are ID-dependent on both their parent tables.%!
A.	True
B.	False
Answer» B. False

Discussion

13.	In 1:N relationships, which entity becomes the parent entity is arbitrary.%!
A.	True
B.	False
Answer» C.

Discussion

14.	When the parent entity is required and the parent has a surrogate key, update actions can be ignored.%!
A.	True
B.	False
Answer» B. False

Discussion

15.	Cascading updates refers to child rows being automatically deleted when a parent row is deleted.%!
A.	True
B.	False
Answer» C.

Discussion

16.	All primary keys are required.%!
A.	True
B.	False
Answer» B. False

Discussion

17.	The terms alternate key and candidate key mean the same thing.%!
A.	True
B.	False
Answer» B. False

Discussion

18.	(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.%!
A.	True
B.	False
Answer» C.

Discussion

19.	The DBMS allows surrogate keys to be changed.%!
A.	True
B.	False
Answer» C.

Discussion

20.	When the parent entity is required, a new child row can always be inserted.%!
A.	True
B.	False
Answer» C.

Discussion

21.	A foreign key is used to implement relationships between tables.%!
A.	True
B.	False
Answer» B. False

Discussion

22.	Which of the following column properties would be used to specify that cells in a column must contain a monetary value?%!
A.	Null status
B.	Data type
C.	Default value
D.	Data constraints
Answer» C. Default value

Discussion

23.	*$_Which of the following column properties would be used to specify that cells in a column must contain a monetary value??
A.	Null status
B.	Data type
C.	Default value
D.	Data constraints
Answer» C. Default value

Discussion

24.	/_For every relationship, how many possible types of actions are there when enforcing minimum cardinalities??
A.	Two
B.	Three
C.	Four
D.	Six
Answer» E.

Discussion

25.	/_Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000??
A.	Null status
B.	Data type
C.	Default value
D.	Data constraints
Answer» D. Data constraints

Discussion

26.	/_Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row??
A.	Null status
B.	Data type
C.	Default value
D.	Data constraints
Answer» E.

Discussion

27.	/_A primary key should be defined as:?
A.	NULL.
B.	NOT NULL.
C.	Either of the above can be used.
D.	None of the above are correct.
Answer» C. Either of the above can be used.

Discussion

28.	%_A primary key should be defined as:_%
A.	NULL.
B.	NOT NULL.
C.	Either of the above can be used.
D.	None of the above are correct.
Answer» C. Either of the above can be used.

Discussion

29.	_ Which is not true about surrogate keys?$?
A.	They are short.
B.	They are fixed.
C.	They have meaning to the user.
D.	They are numeric.
Answer» D. They are numeric.

Discussion

30.	_ If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.$?
A.	the primary key
B.	any alternate key
C.	a surrogate key
D.	a foreign key
Answer» B. any alternate key

Discussion

31.	_Which of the following column properties specifies whether or not cells in a column must contain a data value?$?
A.	Null status
B.	Data type
C.	Default value
D.	Data constraints
Answer» B. Data type

Discussion

32.	A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):$?
A.	primary key.
B.	foreign key.
C.	composite key.
D.	surrogate key.
Answer» E.

Discussion

33.	Which of the following columns is(are) are required in a table?$?
A.	A foreign key
B.	An alternate key
C.	A primary key
D.	A surrogate key
Answer» D. A surrogate key

Discussion

34.	For every relationship, how many possible sets of minimum cardinalities are there?$?
A.	Two
B.	Three
C.	Four
D.	Six
Answer» D. Six

Discussion

35.	In a 1:N relationship, the foreign key is placed in:$?
A.	either table without specifying parent and child tables.
B.	the parent table.
C.	the child table.
D.	either the parent table or the child table.
Answer» D. either the parent table or the child table.

Discussion

36.	In a 1:N relationship, the foreign key is placed in:?
A.	either table without specifying parent and child tables.
B.	the parent table.
C.	the child table.
D.	either the parent table or the child table.
Answer» D. either the parent table or the child table.

Discussion

Explore topic-wise MCQs in Database.

Which is true about surrogate keys?

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

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.%!

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

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

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

Surrogate keys have much meaning for users.%!

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

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

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

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

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

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

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

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

All primary keys are required.%!

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

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

The DBMS allows surrogate keys to be changed.%!

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

A foreign key is used to implement relationships between tables.%!

Which of the following column properties would be used to specify that cells in a column must contain a monetary value?%!

*$_Which of the following column properties would be used to specify that cells in a column must contain a monetary value??

*/*_For every relationship, how many possible types of actions are there when enforcing minimum cardinalities??

*/*_Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000??

*/*_Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row??

*/*_A primary key should be defined as:?

%_A primary key should be defined as:_%

_ Which is not true about surrogate keys?$?

_ If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.$?

_Which of the following column properties specifies whether or not cells in a column must contain a data value?$?

A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):$?

Which of the following columns is(are) are required in a table?$?

For every relationship, how many possible sets of minimum cardinalities are there?$?

In a 1:N relationship, the foreign key is placed in:$?

In a 1:N relationship, the foreign key is placed in:?

/_For every relationship, how many possible types of actions are there when enforcing minimum cardinalities??

/_Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000??

/_Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row??

/_A primary key should be defined as:?