logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Distributed Databases See What Others Are Saying!
  • Question

  • A transaction manager is which of the following?


  • Options
  • A. Maintains a log of transactions
  • B. Maintains before and after database images
  • C. Maintains appropriate concurrency control
  • D. All of the above.

  • Correct Answer
  • All of the above. 

    • More questions

    • 1. A benefit of using a stored procedure is that it can be distributed to client computers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Nonclustered indexes are faster than clustered indexes for retrieval.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. A null value is assigned when no other value applies.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. XML is a rapidly developing scripting language that may, in conjunction with XHTML, replace HTML.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. With an asynchronous system, the requesting system waits for a response in real time.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Business Intelligence (BI) systems do not obtain their data by which of the following means?

    • Options
    • A. Read and process data from an operational database
    • B. Process transactions
    • C. Process extracts from operational databases
    • D. Process data purchased from data vendors
      • Discuss
    • 9. An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. The Windows operating system and Windows applications are event driven.

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