You can recover space from a sparsely populated table by using the ALTER TABLE MOVE command, but what are the negative side effects? (Choose two.)
A . The rows are sorted and coalesced, but no new storage parameters are allowed.
B. The indexes must be rebuilt before they can be used.
C . All indexes are dropped because the physical ROWID no longer exists.
D . The indexes must be dropped before the move statement will succeed.
E. All indexes become invalidated because the physical ROWID of each row in the table changes.
Explanation:
Answer B and E: When the table is moved, indexes are invalidated because the ROWID for each index entry is not automatically converted to the new physical ROWID. Therefore, we must rebuild an index before it can be used. Check the STATUS column in DBA_INDEXES to verify.
No comments:
Post a Comment