Database

Database

Data Models into Database Designs has 40 Questions

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 domain constraint
A range constraint
An intrarelation constraint
An interrelation constraint
A foreign key is used to implement relationships between tables.

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

either table without specifying parent and child tables.
the parent table.
the child table.
either the parent table or the child table.
The terms alternate key and candidate key mean the same thing.

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

Null status
Data type
Default value
Data constraints
In 1:N relationships, which entity becomes the parent entity is arbitrary.

True
False
A primary key should be defined as:

NULL.
NOT NULL.
Either of the above can be used.
None of the above are correct.
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

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

Null status
Data type
Default value
Data constraints
In a 1:1 relationship, the primary key placement is arbitrary.

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

Association relationships only
Multivalued attributes only
Archetype/instance relationships only
All of the above use ID dependent entities
When the parent entity is required, a new child row can always be inserted.

True
False
A foreign key is:

a column containing the primary key of another table.
used to define data types.
used to define null status.
all of the above are above correct.
All primary keys are required.

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

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

A foreign key
An alternate key
A primary key
A surrogate key.
For every relationship, there are six possible sets of minimum cardinalities.

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

either table without specifying parent and child tables.
the parent table.
the child table.
either the parent table or the child table.
An intersection table is required to represent M:N relationships.

True
False
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?

Null status
Data type
Default value
Data constraints
The DBMS allows surrogate keys to be changed.

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

foreign key
main attribute
primary key
identity key
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

True
False
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 domain constraint
A range constraint
An intrarelation constraint
An interrelation constraint
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

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

primary key.
foreign key.
composite key.
surrogate key.
Surrogate keys have much meaning for users.

True
False
Which is not true about surrogate keys?

They are short.
They are fixed.
They have meaning to the user.
They are numeric.
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.

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

Two
Three
Four
Six
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

True
False
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?

MUST COVER
MUST NOT
Both of the above.
None of the above is correct.
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

True
False
Each entity is represented as a(n):

tuple.
table.
attribute.
file.
When the parent entity is required, a new parent row can always be inserted.

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

Two
Three
Four
Six
For every relationship, there are six possible referential integrity actions.

True
False
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.

the primary key
any alternate key
a surrogate key
a foreign key
An ideal primary key is short, numeric and seldom changing.

True
False
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?

Null status
Data type
Default value
Data constraints