logo

CuriousTab

CuriousTab

Discussion

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

  • The generic two-level data warehouse architecture includes which of the following?


  • Options
  • A. At least one data mart
  • B. Data that can extracted from numerous internal and external sources
  • C. Near real-time updates
  • D. All of the above.

  • Correct Answer
  • Data that can extracted from numerous internal and external sources 

    • More questions

    • 1. OLE DB tabular data providers present data in the form of rowsets.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A tuple is a(n):

    • Options
    • A. column of a table.
    • B. two dimensional table.
    • C. row of a table.
    • D. key of a table.
      • Discuss
    • 3. Which of the following types of databases are the most common?

    • Options
    • A. Personal
    • B. Workgroup
    • C. Department
    • D. Enterprise
      • Discuss
    • 4. In unsupervised data mining, explanations are created after patterns are found.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Java bytecode is machine-specific code.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. A star schema has what type of relationship between a dimension and fact table?

    • Options
    • A. Many-to-many
    • B. One-to-one
    • C. One-to-many
    • D. All of the above.
      • Discuss
    • 7. A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. SQL*Plus will finish the statement and execute it when the user types in this:

    • Options
    • A. A left slash ( \ ) followed by [Enter].
    • B. A colon ( : ) followed by [Enter].
    • C. A semicolon ( ; ) followed by [Enter].
    • D. A period ( . ) followed by [Enter].
      • Discuss
    • 9. Business Intelligence (BI) systems do not obtain data from operational databases.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Centralized systems are more susceptible to security threats than client/server architectures.

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