logo

CuriousTab

CuriousTab

Discussion


Home Database The Relational Model and Normalization Comments

  • Question
  • Row is synonymous with the term:


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

  • Correct Answer
  • record. 


  • The Relational Model and Normalization problems


    Search Results


    • 1. A relation is considered a:

    • Options
    • A. Column.
    • B. one-dimensional table.
    • C. two-dimensional table.
    • D. three-dimensional table.
    • Discuss
    • 2. The following are components of a database except ________ .

    • Options
    • A. user data
    • B. metadata
    • C. reports
    • D. indexes
    • Discuss
    • 3. Which of the following is not considered to be a basic element of an enterprise-class database system?

    • Options
    • A. Users
    • B. Database applications
    • C. DBMS
    • D. COBOL programs
    • Discuss
    • 4. Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

    • Options
    • A. IDMS
    • B. DB2
    • C. dBase-II
    • D. R:base
    • Discuss
    • 5. SQL stands for ________ .

    • Options
    • A. Structured Query Language
    • B. Sequential Query Language
    • C. Structured Question Language
    • D. Sequential Question Language
    • Discuss
    • 6. The different classes of relations created by the technique for preventing modification anomalies are called:

    • Options
    • A. normal forms.
    • B. referential integrity constraints.
    • C. functional dependencies.
    • D. None of the above is correct.
    • Discuss
    • 7. A relation in this form is free of all modification anomalies.

    • Options
    • A. First normal form
    • B. Second normal form
    • C. Third normal form
    • D. Domain/key normal form
    • Discuss
    • 8. One solution to the multivalued dependency constraint problem is to:

    • Options
    • A. split the relation into two relations, each with a single theme.
    • B. change the theme.
    • C. create a new theme.
    • D. add a composite key.
    • Discuss
    • 9. 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
    • 10. 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


    Comments

    There are no comments.

Enter a new Comment