logo

CuriousTab

CuriousTab

Discussion


Home Database Database Redesign See What Others Are Saying!
  • Question
  • Database redesign is not terribly difficult if the:


  • Options
  • A. database is structured.
  • B. database is well-designed.
  • C. database has no data.
  • D. database is relatively small.

  • Correct Answer
  • database has no data. 


  • More questions

    • 1. Which of the following is an SQL trigger supported by Oracle?

    • Options
    • A. BEFORE
    • B. INSTEAD OF
    • C. AFTER
    • D. All of the above.
    • Discuss
    • 2. The primary mechanism for providing context for data is metadata.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. Data scrubbing is which of the following?

    • Options
    • A. A process to reject data from the data warehouse and to create the necessary indexes
    • B. A process to load the data in the data warehouse and to create the necessary indexes
    • C. A process to upgrade the quality of data after it is moved into a data warehouse
    • D. A process to upgrade the quality of data before it is moved into a data warehouse
    • Discuss
    • 4. The entity integrity rule states that:

    • Options
    • A. no primary key attribute may be null.
    • B. no primary key can be composite.
    • C. no primary key may be unique.
    • D. no primary key may be equal to a value in a foreign key.
    • Discuss
    • 5. Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

    • Options
    • A. LIKE only.
    • B. IN only.
    • C. NOT IN only.
    • D. Both IN and NOT IN.
    • Discuss
    • 7. Static extract is used for ongoing warehouse maintenance.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Which of the following is true concerning an ODBMS?

    • Options
    • A. They have the ability to store complex data types on the Web.
    • B. They are overtaking RDBMS for all applications.
    • C. They are most useful for traditional, two-dimensional database table applications.
    • D. All of the above.
    • Discuss
    • 9. Which of the following statements is true concerning routines and triggers?

    • Options
    • A. Both consist of procedural code.
    • B. Both have to be called to operate.
    • C. Both run automatically.
    • D. Both are stored in the database.
    • Discuss
    • 10. With SQL Server, parameters and variables in T-SQL start with the "%" sign.

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


    Comments

    There are no comments.

Enter a new Comment