Logical Database Design(Database ) Questions and Answers

Question 1. The entity integrity rule states that:
  1.    no primary key attribute may be null.
  2.    no primary key can be composite.
  3.    no primary key may be unique.
  4.    no primary key may be equal to a value in a foreign key.
Explanation:-
Answer: Option A. -> no primary key attribute may be null.
Question 2. A transitive dependency is which of the following?
  1.    A functional dependency between two or more key attributes.
  2.    A functional dependency between two or more nonkey attributes.
  3.    A relation that is in first normal form.
  4.    A relation that is in second normal form.
Explanation:-
Answer: Option B. -> A functional dependency between two or more nonkey attributes.
Question 3. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
  1.    First normal form
  2.    Second normal form
  3.    Third normal form
  4.    Fourth normal form
Explanation:-
Answer: Option B. -> Second normal form
Question 4. A foreign key is which of the following?
  1.    Any attribute
  2.    The same thing as a primary key
  3.    An attribute that serves as the primary key of another relation
  4.    An attribute that serves no purpose
Explanation:-
Answer: Option C. -> An attribute that serves as the primary key of another relation
Question 5. When mapping a many-to-many unary relationship into a relation which of the following is true?
  1.    One relation is created.
  2.    Two relations are created.
  3.    Three relations are created.
  4.    Four relations are created.
Explanation:-
Answer: Option B. -> Two relations are created.
Question 6. When mapping a multivalued attribute into a relation which of the following is true?
  1.    One relation is created.
  2.    Two relations are created.
  3.    Three relations are created.
  4.    Four relations are created.
Explanation:-
Answer: Option B. -> Two relations are created.
Question 7. If no multivalued attributes exist in a relation, then the relation is in what normal form?
  1.    First normal form
  2.    Second normal form
  3.    Third normal form
  4.    Fourth normal form
Explanation:-
Answer: Option B. -> Second normal form
Question 8. When mapping a binary many-to-many relationship into a relation which of the following is true?
  1.    One relation is created.
  2.    Two relations are created.
  3.    Three relations are created.
  4.    Four relations are created.
Explanation:-
Answer: Option C. -> Three relations are created.
Question 9. The relational model consists of:
  1.    data in the form of tables.
  2.    data redundancy.
  3.    operations using non-SQL languages.
  4.    unorganized data.
Explanation:-
Answer: Option A. -> data in the form of tables.
Question 10. A primary key is which of the following?
  1.    Any attribute
  2.    An attribute that uniquely identifies each row
  3.    An attribute that uniquely identifies each column
  4.    A derived attribute
Explanation:-
Answer: Option B. -> An attribute that uniquely identifies each row
© Lakshya_Education.com, All Right Reserved.
Contact Us services