logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Data Warehousing See What Others Are Saying!
  • Question

  • A data warehouse is which of the following?


  • Options
  • A. Can be updated by end users.
  • B. Contains numerous naming conventions and formats.
  • C. Organized around important subject areas.
  • D. Contains only current data.

  • Correct Answer
  • Organized around important subject areas. 

    • More questions

    • 1. Locking may cause which of the following problems?

    • Options
    • A. Erroneous updates
    • B. Deadlock
    • C. Versioning
    • D. All of the above.
      • Discuss
    • 2. It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The UML notation is useful for graphically depicting an object-oriented analysis or design model.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Which of the following is true concerning the following statement: class Manager extends Employee

    • Options
    • A. Manager is a concrete class and a superclass.
    • B. Manager is a concrete class and a subclass.
    • C. Manager is an abstract class and a superclass.
    • D. Manager is an abstract class and a subclass.
      • Discuss
    • 6. Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?

    • Options
    • A. REPEATABLE READ
    • B. SERIALIZABLE
    • C. READ COMMITTED
    • D. READ UNCOMMITTED
      • Discuss
    • 7. Data warehouse data are usually normalized.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Business rules and policies are universal.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. SQL Server program code that is executed after an SQL command has been processed is called a(n):

    • Options
    • A. INSTEAD OF trigger.
    • B. BEFORE trigger.
    • C. AFTER trigger.
    • D. BEGIN trigger.
      • Discuss
    • 10. The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?

    • Options
    • A. Overlapping rule
    • B. Disjoint rule
    • C. Total specialization rule
    • D. Partial specialization rule
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.