Contents

Which of the following is/are disadvantage/s of distributed databases?
a) high cost          

b) processing overheads
c) data integrity   

d) all of these

d

The database may be broken into logical units is called…….
a) fragments                       

b) integrity
c) replication                        

d) none of these

a

How many types of data fragmentation?
a) one    

b) two    

c) three  

d) four

b

Explanation: vertical fragmentation, horizontal fragmentation


The table that is broken into two or more sets of columns is called……
a) horizontal fragmentation                             
b) vertical fragmentation
c) medium fragmentation                                 
d) data replication

b

The table that is broken into two or more sets of rows is called……
a) horizontal fragmentation                          
b) vertical fragmentation
c) medium fragmentation                                 
d) data replication

b

The copy of data fragment may be stored at several sites is known as……..
a) horizontal fragmentation             
b) vertical fragmentation
c) medium fragmentation                 
d) data replication

d