Data Models Designs(Ict-Basic)Q1

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

1 Mark(s)

surrogate key.
foreign key.
composite key.
primary key.

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

1 Mark(s)

MUST COVER
None of the above is correct.
MUST NOT
Both of the above.

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.

1 Mark(s)

the primary key
a surrogate key
any alternate key
a foreign key

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

1 Mark(s)

primary key
identity key
main attribute
foreign key

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

1 Mark(s)

An alternate key
A surrogate key.
A foreign key
A primary key

A primary key should be defined as:

1 Mark(s)

NOT NULL.
NULL.
Either of the above can be used.
None of the above are correct.

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

1 Mark(s)

the child table.
either the parent table or the child table.
either table without specifying parent and child tables.
the parent table.

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?

1 Mark(s)

Data type
Data constraints
Default value
Null status

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

1 Mark(s)

Archetype/instance relationships only
All of the above use ID dependent entities
Multivalued attributes only
Association relationships only

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?

1 Mark(s)

Null status
Default value
Data constraints
Data type

A foreign key is:

1 Mark(s)

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

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?

1 Mark(s)

An interrelation constraint
An intrarelation constraint
A range constraint
A domain constraint

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

1 Mark(s)

Default value
Data type
Data constraints
Null status

Which is not true about surrogate keys?

1 Mark(s)

They are numeric.
They have meaning to the user.
They are short.
They are fixed.

Each entity is represented as a(n):

1 Mark(s)

file.
attribute.
table.
tuple.

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

1 Mark(s)

Six
Two
Three
Four

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

1 Mark(s)

either table without specifying parent and child tables.
the parent table.
the child table.
either the parent table or the child table.

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?

1 Mark(s)

An interrelation constraint
A domain constraint
A range constraint
An intrarelation constraint

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

1 Mark(s)

Null status
Data constraints
Data type
Default value

Data Models Designs(Ict-Basic)Q1 : Question 1 of 19

Career Academy