logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Logical Database Design Comments
  • Question

  • Well-structured relations encourage anomalies of data.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • Logical Database Design problems

    Search Results

    • 1. If a relation is in third normal form, it does not need to be in second normal form.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A synonym is two or more attributes that have different names but the same meaning.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. A composite attribute does not get mapped into a relation.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. A candidate key must uniquely identify each row.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. A null value is assigned when no other value applies.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. A foreign key may be null and still adhere to the referential integrity constraint.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The primary key in a relation does not need to be underlined.

    • Options
    • A. True
    • B. False
      • 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. There should be one condition within the WHERE clause for each pair of tables being joined.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. 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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.