logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Redesign See What Others Are Saying!
  • Question

  • Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.


  • Options
  • A. optimistic
  • B. skeptical
  • C. ambivalent
  • D. None of the above is correct.

  • Correct Answer
  • skeptical 

    • More questions

    • 1. A point of synchronization between the database and the transaction log is generally referred to as a stop point.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

    • Options
    • A. The multivalue, multicolumn problem
    • B. The inconsistent values problem
    • C. The missing values problem
    • D. The general-purpose remarks column problem
      • Discuss
    • 3. ODL supports the abstract keyword for classes and operations.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Multiplicity is the same as what concept for an ERD?

    • Options
    • A. Relationship
    • B. Attribute
    • C. Entity
    • D. Cardinality
      • Discuss
    • 5. BI reporting systems summarize the current status of business activities in order to predict future activities.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:

    • Options
    • A. first step.
    • B. second step.
    • C. third step.
    • D. fourth step.
      • Discuss
    • 7. It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. The SQL keyword(s) ________ is used with wildcards.

    • Options
    • A. LIKE only
    • B. IN only
    • C. NOT IN only
    • D. IN and NOT IN
      • Discuss
    • 9. A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Denormalized tables are in BCNF.

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