A. Write
B. Insert
C. Execute
D. Read
View Answer
Distributed Database Management Systems MCQs
In case of any shut down during transaction before commit which of the following statement is done automatically.
A. View
B. Commit
C. Rollback
D. Flashback
View Answer
The global query decomposition process is highly dependent on the _____________ information.
A. Schema integration
B. Schema decomposition
C. Relational schema
D. Database
View Answer
Committing a nested transaction has no effect on the state of the parent transaction.
A. True
B. False
View Answer
Which guarantees that the transaction is being performed successfully.
A. Concurrency
B. Consistency
C. Serializability
D. Non serializability
View Answer
___________ takes as input the decomposed query on global relations and applies data distribution information to the query in order to localize its data.
A. Data localization
B. Query Processing
C. Query decomposition
D. Transactions
View Answer
Which of the following terms does refer to the correctness and completeness of the data in a database.
A. Data security
B. Data constraint
C. Data independence
D. Data integrity
View Answer
In……. design alternative, at each site, one copy of all the database tables is stored.
A. Non-replicated and non-fragmented
B. Fully replicated
C. Partially replicated
D. Fragmented
View Answer
When data is stored close to the site of usage, efficiency of the database system is.
A. Increased
B. Decreased
C. Remain same
D. None
View Answer
Fragmentation should be done in a way so that the original table can be reconstructed from the.
A. Replication
B. Fragments
C. Both
D. None
View Answer