logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ The Relational Model and Normalization See What Others Are Saying!
  • Question

  • A candidate key is a determinant that determines all the other columns is a relation.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • More questions

    • 1. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

    • Options
    • A. First normal form
    • B. Second normal form
    • C. Third normal form
    • D. Fourth normal form
      • Discuss
    • 2. Which of the following is true concerning systems information in an RDBMS?

    • Options
    • A. RDBMS store database definition information in system-created tables.
    • B. This information can be accessed using SQL.
    • C. This information often cannot be updated by a user.
    • D. All of the above.
      • Discuss
    • 3. To eliminate definition duplication, XML Schemas define:

    • Options
    • A. an intersection table.
    • B. global elements.
    • C. a normalized definition table.
    • D. None of the above is correct.
      • Discuss
    • 4. When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:

    • Options
    • A. first step.
    • B. second step.
    • C. third step.
    • D. fourth step.
      • Discuss
    • 5. A relationship should be specified how in the ODL?

    • Options
    • A. One direction starting with the first class
    • B. One direction starting with the second class
    • C. Neither direction.
    • D. Both directions.
      • Discuss
    • 6. SQL query and modification commands make up a(n) ________ .

    • Options
    • A. DDL
    • B. DML
    • C. HTML
    • D. XML
      • Discuss
    • 7. The database approach requires additional costs and risks.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. The only time that case matters is inside quotation marks of strings.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Adding null columns to a table is straightforward.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.