Database MCQ - English

Logical Database Design MCQ Questions and Answers

Home | Database | Logical Database Design

In this section we provide lots of objective question of Logical Database Design in Database Management System.

Page: 1/2

1) The entity integrity rule states that:

    no primary key attribute may be null.
    no primary key can be composite.
    no primary key may be unique.
    no primary key may be equal to a value in a foreign key.

Answer : A Discuss

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

    One relation is created.
    Two relations are created.
    Three relations are created.
    Four relations are created.

Answer : B Discuss

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

    First normal form
    Second normal form
    Third normal form
    Fourth normal form

Answer : B Discuss

4) A foreign key is which of the following?

    Any attribute
    The same thing as a primary key
    An attribute that serves as the primary key of another relation
    An attribute that serves no purpose

Answer : C Discuss

5) A transitive dependency is which of the following?

    A functional dependency between two or more key attributes.
    A functional dependency between two or more nonkey attributes.
    A relation that is in first normal form.
    A relation that is in second normal form.

Answer : B Discuss

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

    One relation is created.
    Two relations are created.
    Three relations are created.
    Four relations are created.

Answer : B Discuss

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

    First normal form
    Second normal form
    Third normal form
    Fourth normal form

Answer : A Discuss

8) A primary key is which of the following?

    Any attribute
    An attribute that uniquely identifies each row
    An attribute that uniquely identifies each column
    A derived attribute

Answer : B Discuss

9) The relational model consists of:

    data in the form of tables.
    data redundancy.
    operations using non-SQL languages.
    unorganized data.

Answer : A Discuss

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

    One relation is created.
    Two relations are created.
    Three relations are created.
    Four relations are created.

Answer : C Discuss

Jump to Pages:

1 2

MCQ Category