A) A transaction processor manager (TPM) is responsible for a. Receiving and pro

Question

A) A transaction processor manager (TPM) is responsible for a. Receiving and processing only local applications data requests b. Receiving and processing only remote applications data requests c, Receiving and processing both local and remote applications data request d. None of the above Which of the following refers to the operation of copying and maintaining database objects in multiple physical databases belonging to a distributed system? a. Backup b. Recovery c. Replication d. All the above c) In a heterogeneous distributed DBMS a. Two different sites can use different DBMS products, but data model must be the same b. Two different sites can use different data models, but DBMS must be the same c. Two different sites can use different DBMS products and different data models d. Two different sites can use different DBMS products but SQL languages must be the same 4d) Which of the following is an objective of data distribution in the distributed system? a. Data is located where it is consumed b. Availability and reliability c. Communication cos d. All the above e) Location independence represents a. Users are aware of the location of the data b. Users are unaware of the location of the data c. Users are aware of physical names of database objects d. None of the above 4f) An Application calls the TM when a. The transaction starts only b. The transaction completes only c. The transaction starts and completes d. A new server joins the transaction g) A Resource Manager (RM) a. Uses only Redo logs to return to a consistent state after a failure b. Is only available with an Oracle database c. Is part of the TPM d. None of the above h) A Two-Phase Commit maintains a. Durability b. Atomicity c. Isolation d Consistency i) Two-Phase Commit is critical for Distributed Queries a. True b. False j) Trickle Refresh Propagation relies on XA protocol to maintain Atomicity a. True b, False

Explanation / Answer

4a) c) receiving and processing both remote and local application's data request

4b) c) Replication.

4c) c) Two different sites can use different DBMS product and different models.

4d) d)All of the above

4e) b) users are unaware of the location of data.

4f) c) when the transaction starts and completes.

4g) b) is only available with Oracle Database

4h) d) consistency

4i) b) false

4j) b) false

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.