1. Home
    2. database questions

    the relational model and normalization




    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:
    A   A → B.   
    B   A → C.   
    C   A → (B,C).   
    D   (B,C) → A.   
    ANS: A - A → B.

    No answer description available for this question

    2).
    The different classes of relations created by the technique for preventing modification anomalies are called:
    A   normal forms.   
    B   referential integrity constraints.   
    C   functional dependencies.   
    D   None of the above is correct.   
    ANS: A - normal forms.

    No answer description available for this question

    3).
    A relation is in this form if it is in BCNF and has no multivalued dependencies:
    A   second normal form   
    B   third normal form   
    C   fourth normal form   
    D   domain/key normal form   
    ANS: C - fourth normal form

    No answer description available for this question

    4).
    Row is synonymous with the term
    A   record   
    B   relation   
    C   column   
    D   field   
    ANS: A - record

    No answer description available for this question

    5).
    The primary key is selected from the:
    A   composite keys   
    B   determinants   
    C   candidate keys.   
    D   foreign keys   
    ANS: C - candidate keys.

    No answer description available for this question

    6).
    Which of the following is a group of one or more attributes that uniquely identifies a row?
    A   Key   
    B   Determinant   
    C   Tuple   
    D   Relation   
    ANS: A - Key

    No answer description available for this question

    7).
    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):
    A   transitive dependency   
    B   insertion anomaly   
    C   referential integrity constraint   
    D   normal form   
    ANS: C - referential integrity constraint

    No answer description available for this question

    8).
    A relation is considered a:
    A   Column   
    B   one-dimensional table   
    C   two-dimensional table   
    D   three-dimensional table   
    ANS: C - two-dimensional table

    No answer description available for this question

    9).
    In the relational model, relationships between relations or tables are created by using
    A   composite keys   
    B   determinants   
    C   candidate keys   
    D   foreign keys   
    ANS: D - foreign keys

    No answer description available for this question

    10).
    A functional dependency is a relationship between or among:
    A   tables   
    B   rows   
    C   relations   
    D   attributes   
    ANS: D - attributes

    No answer description available for this question