logo

CuriousTab

CuriousTab

Discussion

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

  • The extract process is which of the following?


  • Options
  • A. Capturing all of the data contained in various operational systems
  • B. Capturing a subset of the data contained in various operational systems
  • C. Capturing all of the data contained in various decision support systems
  • D. Capturing a subset of the data contained in various decision support systems

  • Correct Answer
  • Capturing a subset of the data contained in various operational systems 

    • More questions

    • 1. SQL Server 2000 stored procedures can:

    • Options
    • A. never be kept within the database.
    • B. be kept within the database and invoked by application programs.
    • C. be stored on the users' computer.
    • D. support BEFORE, INSTEAD OF and AFTER types.
      • Discuss
    • 2. When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. In a relation, the columns are sometimes called "attributes."

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. ROLLBACK WORK asks SQL to empty the log file.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. An attribute's value is always literal.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Information systems and organizations do not just influence each other; they create each other.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. SQL Server automatically creates an index on all primary and foreign keys.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Mirrored databases are almost always provided in high-availability systems.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. An attribute is a(n):

    • Options
    • A. column of a table.
    • B. two dimensional table.
    • C. row of a table.
    • D. key of a table.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.