Question

1.) Which of the following statements is false?

a. Distribution transparency allows a distributed database to be treated as a single physical database.

b. Transaction transparency allows a transaction to update data at more than one network site.

c. Failure transparency ensures that the system will continue to operate in the event of a node or network failure.

d. Performance transparency allows the system to perform as if it were a centralized DBMS.

e. Heterogeneity transparency allows the integration of several different local DBMSs (relational, network, and hierarchical) under a common, or global, schema.

2.) What of the following statements is true?

a. A fully replicated database stores multiple copies of each database fragment at multiple sites.

b. A semi replicated database stores single copy of each database fragment at multiple sites.

c. A partially replicated database stores multiple copies of some database fragments at a single site.

d. An unreplicated database stores each database fragment at multiple sites

e. All of the above

f. None of the above

3.) Which of the following statements is false?

a. Two-phase commit protocol (2PC) In a DDBMS, an algorithm used to ensure atomicity of transactions and database consistency as well as integrity in distributed transactions.

b. DO-UNDO-REDO protocol A protocol used by a data processor (DP) to roll back or roll forward transactions with the help of a system's transaction log entries.

c. Write-ahead protocol A protocol that ensures transaction logs are written to permanent storage before any database data is actually updated.

d. Coordinator In a DDBMS, a data processor (DP) node that participates in a distributed transaction using the two-phase COMMIT protocol.

e. All of the above

f. None of the above

Answer 1

Question 1) Answer Option B

Reason: Option A is true because the work of distributed transparency is to allow database to work as a single database.

Option B is false because it does not allow data to be update at two points as it violates integrity.

Option C is true because it ensures the transparency still works even when there is a failure.

Option D is true because it allows the DB to works a centralised DB

Option E is true because heterogeneity allows multiple local db to work as one.

Question 2) answer Option A

Reason: Option A is true because it used to replicate one data and store at multiple sites.

Option B is false because it stores semi replicated data across multiple points

Option C is false because partial replicated database it stores some copy of a data and some not

Option D is false as it stores database fragment at one site

Question 3) Answer Option F None of the above

Option A is true because it two phase commit protocol ensures that the atomicity is maintained.

Option B is true because the do undo feature is used to provide roll back and roll forward transaction

Option C is true because write ahead ensures that data is changed before they are updated.

Option D is true because coordinator ensures that data processor participates in two phase lock protocol.

If you liked the solution then give a thumbs up ? it will be really appreciated ?