From the objective of OSS-DB Exam Gold
- Advanced Server Administration - Commands for database administration
Sample Question
1.08
If the user executing VACUUM does not have the necessary privileges to perform VACUUM on the target table, an error will occur.
B. VACUUM operations performed within a transaction block can be rolled back using ROLLBACK.
C. A standard VACUUM, even without specifying any options, might return unused space to the operating system.
D. VACUUM ANALYZE should be executed after a significant number of rows have been added or deleted.
-
If the user executing VACUUM does not have the necessary privileges to perform VACUUM on the target table, an error will occur.
-
VACUUM operations performed within a transaction block can be rolled back using ROLLBACK.
-
A standard VACUUM, even without specifying any options, might return unused space to the operating system.
-
VACUUM ANALYZE should be executed after a significant number of rows have been added or deleted.
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2025/05/29
Answer and Explanation
A. A WARNING is generated, and the VACUUM operation on the target table is skipped. However, this is not considered an error.
B. VACUUM cannot be performed within a transaction block.
C. If the end of the target table consists of empty pages and an exclusive lock can be obtained, that space may be returned to the operating system.
D. When a large number of rows have been updated or deleted, unused space should be reclaimed and statistics updated.
Therefore, the correct answers are C and D.