Multiple choice technology databases

What command is used to reclaim unused space for table TABLE1?

  1. ALTER TABLE TABLE1 SHRINK;

  2. ALTER TABLE TABLE1 SHRINK SPACE;

  3. ALTER TABLE TABLE1 SHRINK UNUSED;

  4. ALTER TABLE TABLE1 SHRINK ROWs;
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The correct Oracle SQL syntax to reclaim unused space from a table is ALTER TABLE SHRINK SPACE;. The other options use incorrect keywords like SHRINK, SHRINK UNUSED, or SHRINK ROWs which are syntactically invalid.

Keep practicing — related questions