EMP_IDX is an index on the EMP.ENO column.
EMP and EMP_IDX reside in the TBS1 tablespace.
During an INSERT into EMP, you get this error:
Which two actions would you take to correct the space problem in TBS1 without affecting uncommitted transactions on EMP? (Choose two.)
A. Drop and re-create EMP_IDX.
B. Coalesce EMP_IDX.
C. Shrink EMP.
D. Rebuild EMP_IDX online in a tablespace with sufficient space.
E. Shrink TBS1.
|
Download Printable PDF. VALID exam to help you PASS. |
 |