38 + Mcqs in Transforming Data Models Into Database Designs Page 1 McqOptions

1.	When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
A.	1
B.
Answer» B.

Discussion

2.	Intersection tables are ID-dependent on both their parent tables.
A.	1
B.
Answer» B.

Discussion

3.	When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
A.	1
B.
Answer» B.

Discussion

4.	Surrogate keys have much meaning for users.
A.	1
B.
Answer» C.

Discussion

5.	Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
A.	1
B.
Answer» C.

Discussion

6.	An intersection table is required to represent M:N relationships.
A.	1
B.
Answer» B.

Discussion

7.	When the parent entity is required, a new parent row can always be inserted.
A.	1
B.
Answer» B.

Discussion

8.	For every relationship, there are six possible referential integrity actions.
A.	1
B.
Answer» B.

Discussion

9.	All primary keys are required.
A.	1
B.
Answer» B.

Discussion

10.	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.	1
B.
Answer» B.

Discussion

11.	For every relationship, there are six possible sets of minimum cardinalities.
A.	1
B.
Answer» C.

Discussion

12.	An ideal primary key is short, numeric and seldom changing.
A.	1
B.
Answer» B.

Discussion

13.	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.	1
B.
Answer» B.

Discussion

14.	The terms alternate key and candidate key mean the same thing.
A.	1
B.
Answer» B.

Discussion

15.	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

16.	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

17.	In a 1:1 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» B. the parent table.

Discussion

18.	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

19.	(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
A.	1
B.
C.	1
D.
Answer» C. 1

Discussion

20.	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

21.	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

22.	A foreign key is:
A.	a column containing the primary key of another table.
B.	used to define data types.
C.	used to define null status.
D.	all of the above are above correct.
Answer» B. used to define data types.

Discussion

23.	The DBMS allows surrogate keys to be changed.
A.	1
B.
C.	1
D.
Answer» C. 1

Discussion

24.	In 1:N relationships, which entity becomes the parent entity is arbitrary.
A.	1
B.
Answer» C.

Discussion

25.	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

26.	Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
A.	A domain constraint
B.	A range constraint
C.	An intrarelation constraint
D.	An interrelation constraint
Answer» D. An interrelation constraint

Discussion

27.	Each entity is represented as a(n):
A.	tuple.
B.	table.
C.	attribute.
D.	file.
Answer» C. attribute.

Discussion

28.	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

29.	When the parent entity is required, a new child row can always be inserted.
A.	1
B.
C.	1
D.
Answer» C. 1

Discussion

30.	In a 1:1 relationship, the primary key placement is arbitrary.
A.	1
B.
Answer» B.

Discussion

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

Discussion

32.	The identifier of an entity will become the ________ of the new table.
A.	foreign key
B.	main attribute
C.	primary key
D.	identity key
Answer» D. identity key

Discussion

33.	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

34.	A foreign key is used to implement relationships between tables.
A.	1
B.
C.	1
D.
Answer» B.

Discussion

35.	Which of the following situation requires the use of ID-dependent entities?
A.	Association relationships only
B.	Multivalued attributes only
C.	Archetype/instance relationships only
D.	All of the above use ID dependent entities
Answer» E.

Discussion

36.	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

37.	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

38.	Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
A.	A domain constraint
B.	A range constraint
C.	An intrarelation constraint
D.	An interrelation constraint
Answer» B. A range constraint

Discussion

Explore topic-wise MCQs in Database.

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

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

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

Surrogate keys have much meaning for users.

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

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

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

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

All primary keys are required.

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.

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

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

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

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

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

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?

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

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

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

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 would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?

A foreign key is:

The DBMS allows surrogate keys to be changed.

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

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

Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

Each entity is represented as a(n):

Which is not true about surrogate keys?

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

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

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

The identifier of an entity will become the ________ of the new table.

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

A foreign key is used to implement relationships between tables.

Which of the following situation requires the use of ID-dependent entities?

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

A primary key should be defined as:

Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?