DBMS-Distributed Database Systems Questions and Answers

Practice Mode
Showing 10 of 49 questions
Q11
In heterogeneous DDBS, different sites run under the control of different DBMSs, essentially automously and are connected somehow to enable access to data from multiple sites.
  • A TRUE
  • B FALSE
Answer: Option A
Q12
A distributed database system allows applications to access data from local and remote databases.
  • A TRUE
  • B FALSE
Answer: Option A
Q13
Homogeneous database systems have well-accepted standards for gateway protocols to expose DBMS functionality to external applications.
  • A TRUE
  • B FALSE
Answer: Option B
Q14
Distributed database do not use client/server architecture.
  • A TRUE
  • B FALSE
Answer: Option B
Q15
In the client/server architecture, client is the provider of the resource whereas the server is a user of the resource.
  • A TRUE
  • B FALSE
Answer: Option B
Q16
The client/server architecture does not allow a single query to span multiple servers.
  • A TRUE
  • B FALSE
Answer: Option A
Q17
A horizontal fragmentation is produced by spcifying a predicate that performs a restriction on the tuples in the relation.
  • A TRUE
  • B FALSE
Answer: Option A
Q18
Data replication is used to improve the local database performance and protect the availability of  applications.
  • A TRUE
  • B FALSE
Answer: Option A
Q19
Transparrency in data replication makes the user unaware of the xistence of the copies.
  • A TRUE
  • B FALSE
Answer: Option A
Q20
The server is the machine that runs the DBMS softweare and handles the functions required for concurrent, shared data access.
  • A TRUE
  • B FALSE
Answer: Option A

📚 More from Database

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