The greatest disadvantage of distributed database is the ……….. availability.
a) security risk
b) cost/complexity
c) control of integrity problem
d) none of these
A distributed
database has which of the following advantages over a centralized database?
a) software complexity
b) slow
response
c) modular growth
d) software
cost
Which of the following is storing a separate copy of database at multiple locations?
a) horizontal partitioning
b) vertical partitioning
c) data replication
d) both a & b
Which of the following is not one of the stages in the evolution of distributed DBMS?
a) remote unit of work
b) distributed unit of work
c) unit of work
d) centralized unit of work
A distributed transaction can be ……… if queries are issued at one or more nodes
a) full read-write
b) partially read-write
c) partially read only
d) fully read only
In case of entity integrity, the primary key may be………
a) any value
b) not null
c) null
d) none of these
