Database MCQ - English

Data Models into Database Designs MCQ Questions and Answers

Home | Database | Data Models into Database Designs

In this section we provide lots of objective question of Data Models into Database Designs in Database Management System.

Page: 1/2

1) 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

Answer : A Discuss

2) 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.

Answer : C Discuss

3) 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

Answer : A Discuss

4) A primary key should be defined as:

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

Answer : B Discuss

5) 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

Answer : B Discuss

6) 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

Answer : D Discuss

7) 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.

Answer : A Discuss

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

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

Answer : C Discuss

9) 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.

Answer : A Discuss

10) 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

Answer : C Discuss

Jump to Pages:

1 2

MCQ Category