The Relational Model And Normalization(Database ) Questions and Answers

Question 1. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
  1.    A → B.
  2.    A → C.
  3.    A → (B,C).
  4.    (B,C) → A.
Explanation:-
Answer: Option A. -> A → B.
Question 2. The primary key is selected from the:
  1.    composite keys.
  2.    determinants.
  3.    candidate keys.
  4.    foreign keys.
Explanation:-
Answer: Option C. -> candidate keys.
Question 3. A relation is in this form if it is in BCNF and has no multivalued dependencies:
  1.    second normal form.
  2.    third normal form.
  3.    fourth normal form.
  4.    domain/key normal form.
Explanation:-
Answer: Option C. -> fourth normal form.
Question 4. Row is synonymous with the term:
  1.    record.
  2.    relation.
  3.    column.
  4.    field.
Explanation:-
Answer: Option A. -> record.
Question 5. The different classes of relations created by the technique for preventing modification anomalies are called:
  1.    normal forms.
  2.    referential integrity constraints.
  3.    functional dependencies.
  4.    None of the above is correct.
Explanation:-
Answer: Option A. -> normal forms.
Question 6. Which of the following is a group of one or more attributes that uniquely identifies a row?
  1.    Key
  2.    Determinant
  3.    Tuple
  4.    Relation
Explanation:-
Answer: Option A. -> Key
Question 7. In the relational model, relationships between relations or tables are created by using:
  1.    composite keys.
  2.    determinants.
  3.    candidate keys.
  4.    foreign keys.
Explanation:-
Answer: Option D. -> foreign keys.
Question 8. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
  1.    transitive dependency.
  2.    insertion anomaly.
  3.    referential integrity constraint.
  4.    normal form.
Explanation:-
Answer: Option C. -> referential integrity constraint.
A referential integrity constraint is defined as part of an association between two entity types. The definition for a referential integrity constraint specifies the following information: The principal end of the constraint. (An entity type whose entity key is referenced by the dependent end.)
Question 9. A relation is considered a:
  1.    Column.
  2.    one-dimensional table.
  3.    two-dimensional table.
  4.    three-dimensional table.
Explanation:-
Answer: Option C. -> two-dimensional table.
Question 10. A functional dependency is a relationship between or among:
  1.    tables.
  2.    rows.
  3.    relations.
  4.    attributes.
Explanation:-
Answer: Option D. -> attributes.
© Lakshya_Education.com, All Right Reserved.
Contact Us services