logo

CuriousTab

CuriousTab

Discussion

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

  • Which of the following is true concerning a global transaction?


  • Options
  • A. The required data are at one local site and the distributed DBMS routes requests as necessary.
  • B. The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
  • C. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
  • D. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

  • Correct Answer
  • The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary. 

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