
Distributed Query Processing
■
211
(viii) Redundant predicates are eliminated in
a. Normalization step
b. Simplification step
c. Query restructuring step
d. Analysis step.
(ix) Reduction techniques are used in
a. Query decomposition
b. Query fragmentation
c. Global query optimization
d. Local query optimization.
(x) Which of the following techniques is used in
reduction of horizontal fragmentation?
a. Reduction with selection operation
b. Reduction with join operation
c. None of these
d. All of these.
(xi) Which of the following is done in reduction
of mixed fragmentation?
a. Removal of empty relations
b. Removal of useless relations
c. Removal of ...