DBMS-Distributed Database Systems Questions and Answers

Practice Mode
Showing 10 of 49 questions
Q21
Data replication decreases the availability of data to read-only transactions.
  • A TRUE
  • B FALSE
Answer: Option B
Q22
In distributed systems, each site generates unique local timestamp using either a logical counter or the local clock and concatenates it with the site identifier.
  • A TRUE
  • B FALSE
Answer: Option A
Q23
In disributted locking, the DDBS maintains a lock manager at each site whose function is to administer the lock and unlock requests for those data items that are stored at that site.
  • A TRUE
  • B FALSE
Answer: Option A
Q24
In distributed systems, each site generates unique local tmestamp using either a logical counter or the local clock and concatenates it with the site identifier.
  • A TRUE
  • B FALSE
Answer: Option A
Q25
In a recovery control, transactionl atomicity must be ensured.
  • A TRUE
  • B FALSE
Answer: Option A
Q26
The two-phase commit protocol guarantees that all database servers participating in a distributed transaction either all commit or all abort.
  • A TRUE
  • B FALSE
Answer: Option A
Q27
The use of 2PC is not tranasparent to the users.
  • A TRUE
  • B FALSE
Answer: Option B
Q28
A distributed database system allows applications to access data from
  • A local database
  • B remote database
  • C both local and remote database
  • D None of these
Answer: Option C
Q29
In homogeneous DDBS,
  • A there are several sites, each running their own applications on the same DBMS software.
  • B all sites have identical DBMS software
  • C all users (or clients) use identical software
  • D All of these
Answer: Option D
Q30
In heterogeneous DDBS
  • A different sites run under the control of different DBMSs, essentially autonomously.
  • B different sites are connected somehow to enable access to data from multiple sites.
  • C different sites may use different schemas, and different DBMS software.
  • D All of these.
Answer: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test