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

The SHRINK SPACE operation compacts data and can release free space, but it requires exclusive locks on segments. During this operation, DML (Data Manipulation Language) operations like INSERT, UPDATE, DELETE are blocked, causing an impact on database operations.

Keep practicing — related questions