logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Design Using Normalization See What Others Are Saying!
  • Question

  • When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • More questions

    • 1. Each entity is represented as a(n):

    • Options
    • A. tuple.
    • B. table.
    • C. attribute.
    • D. file.
      • Discuss
    • 2. The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. A multifield transformation does which of the following?

    • Options
    • A. Converts data from one field into multiple fields
    • B. Converts data from multiple fields into one field
    • C. Converts data from multiple fields into multiple fields
    • D. All of the above
      • Discuss
    • 4. An enterprise key is a primary key whose value is unique for a given relation.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Normalization is a formal process for deciding which attributes should be grouped together in a relation.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Which of the following indicates the maximum number of entities that can be involved in a relationship?

    • Options
    • A. Minimum cardinality
    • B. Maximum cardinality
    • C. ERD
    • D. Greater Entity Count (GEC)
      • Discuss
    • 7. XML is:

    • Options
    • A. a subset of SGML only.
    • B. a hybrid of document processing and database processing only.
    • C. a standardized yet customizable way to describe the content of documents only.
    • D. XML is all of the above.
      • Discuss
    • 8. The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.

    • 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.