Multiple choice

The DBA issues the following command:

SQL< alter table ORDER SHRINK SPACE

What be the result of this statement?

  1. There would be only a compacting of the data, not a release of data.

  2. There would be no impact on DML operations in the database.

  3. There would be immediate release of the free space.

  4. There would be an impact on the DML operations in the database.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

There would be an impact on the DML operations in the database.

Keep practicing — related questions