logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ The Relational Model and Normalization Comments
  • Question

  • A key:


  • Options
  • A. must always be composed of two or more columns.
  • B. can only be one column.
  • C. identifies a row.
  • D. identifies a column.

  • Correct Answer
  • identifies a row. 

    • The Relational Model and Normalization problems

    Search Results

    • 1. Which of the following is a group of one or more attributes that uniquely identifies a row?

    • Options
    • A. Key
    • B. Determinant
    • C. Tuple
    • D. Relation
      • Discuss
    • 2. 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:

    • Options
    • A. A ? B.
    • B. A ? C.
    • C. A ? (B,C).
    • D. (B,C) ? A.
      • Discuss
    • 3. A tuple is a(n):

    • Options
    • A. column of a table.
    • B. two dimensional table.
    • C. row of a table.
    • D. key of a table.
      • Discuss
    • 4. If attribute A determines both attributes B and C, then it is also true that:

    • Options
    • A. A ? B.
    • B. B ? A.
    • C. C ? A.
    • D. (B,C) ? A.
      • Discuss
    • 5. A relation is in this form if it is in BCNF and has no multivalued dependencies:

    • Options
    • A. second normal form.
    • B. third normal form.
    • C. fourth normal form.
    • D. domain/key normal form.
      • Discuss
    • 6. An attribute is a(n):

    • Options
    • A. column of a table.
    • B. two dimensional table.
    • C. row of a table.
    • D. key of a table.
      • Discuss
    • 7. If attributes A and B determine attribute C, then it is also true that:

    • Options
    • A. A ? C.
    • B. B ? C.
    • C. (A,B) is a composite determinant.
    • D. C is a determinant.
      • Discuss
    • 8. The primary key is selected from the:

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

    • Options
    • A. composite keys.
    • B. determinants.
    • C. candidate keys.
    • D. foreign keys.
      • Discuss
    • 10. Table is synonymous with the term:

    • Options
    • A. record.
    • B. relation.
    • C. column.
    • D. field.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.