DBMS-Distributed Database Systems Questions and Answers
Practice ModeShowing 10 of 49 questions
Q1
In a distributed database system, each site is typically managed by a DBMS that is dependent on the other sites
Answer: Option A
Q2
Distributed database systems arose from the need to offer local database autonomy at gegraphially distributed locations.
Answer: Option A
Q3
Distributed database systems arose from the need to offer local database autonomy at gegraphially distributed locations.
Answer: Option A
Q4
The main aim of client/server architecture is to utilise the processing power on the desktop while retaining the best aspects of centralised data processing.
Answer: Option A
Q5
Distribued transaction atomicity property enables users to ask queries without specifying where the reference relations, or copies or frangments of the relations, are located.
Answer: Option B
Q6
Distributed data independence property enables users to write transactions that access and update data at several sites just as they would write transactions over purily local data.
Answer: Option B
Q7
Distributed data independence property enables users to write transactions that access and update data at several sites just as they would write transations over purely local data.
Answer: Option B
Q8
Although geographically dispersed, a distributed database system manages and controls the entire database as single collection of data
Answer: Option A
Q9
Although geographically dispersed, a distributed database system manages and controls the entire database as a single collection of data
Answer: Option A
Q10
In homogeneous DDBS, there are several sites, each running their own applications on the same DBMS software.
Answer: Option A