Vidyalelo
Database · all questions

Logical Database Design
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

30

Questions

1/2

Page

Pick an option on a question to see the right answer and solution.

The entity integrity rule states that:

Select an option to see the answer and solution.

When mapping a many-to-many unary relationship into a relation which of the following is true?

Select an option to see the answer and solution.

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

Select an option to see the answer and solution.

A foreign key is which of the following?

Select an option to see the answer and solution.

A transitive dependency is which of the following?

Select an option to see the answer and solution.

When mapping a multivalued attribute into a relation which of the following is true?

Select an option to see the answer and solution.

If no multivalued attributes exist in a relation, then the relation is in what normal form?

Select an option to see the answer and solution.

A primary key is which of the following?

Select an option to see the answer and solution.

The relational model consists of:

Select an option to see the answer and solution.

When mapping a binary many-to-many relationship into a relation which of the following is true?

Select an option to see the answer and solution.

A relation has which of the following properties?

Select an option to see the answer and solution.

When mapping a ternary relationship with an associative entity into a relation which of the following is true?

Select an option to see the answer and solution.

When mapping a regular entity into a relation which of the following is true?

Select an option to see the answer and solution.

When mapping a supertype/subtype relationship which of the following is true?

Select an option to see the answer and solution.

Relations are:

Select an option to see the answer and solution.

An enterprise key is a primary key whose value is unique for a given relation.

Select an option to see the answer and solution.

A composite attribute does not get mapped into a relation.

Select an option to see the answer and solution.

A relation is a two-dimensional table.

Select an option to see the answer and solution.

Weak entities do not get mapped into a relation.

Select an option to see the answer and solution.

A primary key may be null.

Select an option to see the answer and solution.