The new employee badging scheme requires a complete update of the employee numbers in the
employee table. The employee number is not the primary key. What is the best CONTROL
directive to use for the update?

A.
Let the system choose the best CONTROL TABLE SEQUENTIAL BLOCKSPLIT SYSTEM
default for splitting blocks.

B.
Use the directive CONTROL TABLE employee SEQUENTIAL BLOCKSPLIT ON to ensure that
no disk space will be wasted during the update.

C.
Do not use the CONTROL TABLE SEQUENTIAL BLOCKSPLIT because it only applies to
inserts.

D.
Use the CONTROL TABLE employee SEQUENTIAL BLOCKSPLIT ON UPDATE directive to
ensure that no disk space will be wasted during the
update.