Data Models into Database Designs - General Questions (2)

9.

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

Explanation:

No answer description available for this question. Let us discuss.

10.

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

Explanation:

No answer description available for this question. Let us discuss.

11.

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

Explanation:

No answer description available for this question. Let us discuss.

12.

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

Explanation:

No answer description available for this question. Let us discuss.

13.

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

Explanation:

No answer description available for this question. Let us discuss.

14.

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

Explanation:

No answer description available for this question. Let us discuss.

15.

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

Explanation:

No answer description available for this question. Let us discuss.

16.

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

Explanation:

No answer description available for this question. Let us discuss.

1
2
3