logo

CuriousTab

CuriousTab

Discussion


Home Database The Relational Model and Normalization Comments

  • Question
  • A relation is considered a:


  • Options
  • A. Column.
  • B. one-dimensional table.
  • C. two-dimensional table.
  • D. three-dimensional table.

  • Correct Answer
  • two-dimensional table. 


  • The Relational Model and Normalization problems


    Search Results


    • 1. The following are components of a database except ________ .

    • Options
    • A. user data
    • B. metadata
    • C. reports
    • D. indexes
    • Discuss
    • 2. 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
    • 3. 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
    • 4. SQL stands for ________ .

    • Options
    • A. Structured Query Language
    • B. Sequential Query Language
    • C. Structured Question Language
    • D. Sequential Question Language
    • Discuss
    • 5. An Enterprise Resource Planning application is an example of a(n) ________ .

    • Options
    • A. single-user database application
    • B. multiuser database application
    • C. e-commerce database application
    • D. data mining database application
    • Discuss
    • 6. Row is synonymous with the term:

    • Options
    • A. record.
    • B. relation.
    • C. column.
    • D. field.
    • Discuss
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. 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


    Comments

    There are no comments.

Enter a new Comment