Home - Database - Data Models Into Database Designs

Data Models Into Database Designs Online Exam Quiz

Important questions about Data Models Into Database Designs. Data Models Into Database Designs MCQ questions with answers. Data Models Into Database Designs exam questions and answers for students and interviews.

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

Options

A : the primary key

B : any alternate key

C : a surrogate key

D : a foreign key

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

Options

A : Null status

B : Data type

C : Default value

D : Data constraints

3. 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?

Options

A : A domain constraint

B : A range constraint

C : An intrarelation constraint

D : An interrelation constraint

4. 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?

Options

A : Null status

B : Data type

C : Default value

D : Data constraints

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

Options

A : foreign key

B : main attribute

C : primary key

D : identity key

6. Each entity is represented as a(n):

Options

A : tuple.

B : table.

C : attribute.

D : file.

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

Options

A : Association relationships only

B : Multivalued attributes only

C : Archetype/instance relationships only

D : All of the above use ID dependent entities

8. A primary key should be defined as:

Options

A : NULL.

B : NOT NULL.

C : Either of the above can be used.

D : None of the above are correct.

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

Options

A : either table without specifying parent and child tables.

B : the parent table.

C : the child table.

D : either the parent table or the child table.

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

Options

A : either table without specifying parent and child tables.

B : the parent table.

C : the child table.

D : either the parent table or the child table.

1. The DBMS allows surrogate keys to be changed.

Options

A : True

B : False

C :

D :

2. For every relationship, there are six possible referential integrity actions.

Options

A : True

B : False

C :

D :

3. In 1:N relationships, which entity becomes the parent entity is arbitrary.

Options

A : True

B : False

C :

D :

4. A foreign key is used to implement relationships between tables.

Options

A : True

B : False

C :

D :

5. All primary keys are required.

Options

A : True

B : False

C :

D :

6. When the parent entity is required, a new parent row can always be inserted.

Options

A : True

B : False

C :

D :

7. When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

Options

A : True

B : False

C :

D :

8. An intersection table is required to represent M:N relationships.

Options

A : True

B : False

C :

D :

9. In a 1:1 relationship, the primary key placement is arbitrary.

Options

A : True

B : False

C :

D :

10. For every relationship, there are six possible sets of minimum cardinalities.

Options

A : True

B : False

C :

D :

Database more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.019660949707031