Contents

How many advantages of data allocation?
a) one    

b) two    

c) three  

d) four

b

Explanation: efficiency, security


Which of the following are disadvantages of data allocation?
a) inconsistent access speeds           
b) backup vulnerability
c) efficiency                         

d) both a & b

d

Which of the following is/are advantage/s of data replication?
a) faster and consistent access
b) reliability
c) node decoupling             

d) all of these

d

How many disadvantages of data replication?
a) one    

b) two    

c) three  

d) four

b

Explanation: update complexity, increased storage requirements


Which of the following replication is combination of fragmentation and replication?
a) complete replication                                      
b) selective replication
c) moderate replication

d) all of these

b

How many functions of DDMS?
a) one    

b) three 

c) five   

d) seven

c

Explanation: extended communication services, extended system catalog, distributed query processing, extended concurrency control, extended recovery services