Which of the following is the correct syntax to run a basic VACUUM on a table named employees?

easy📝 Syntax Q3 of 15

PostgreSQL - Transactions and Concurrency

Which of the following is the correct syntax to run a basic VACUUM on a table named employees?

AVACUUM employees;

BVACUUM TABLE employees;

CRUN VACUUM ON employees;

DEXECUTE VACUUM employees;

Step-by-Step Solution

Solution:

Step 1: Recall the basic VACUUM syntax
The correct syntax is simply VACUUM followed by the table name.
Step 2: Eliminate incorrect syntax forms
Keywords like TABLE, RUN, or EXECUTE are not part of VACUUM syntax.
Final Answer:
VACUUM employees; -> Option A
Quick Check:
Basic VACUUM syntax = VACUUM table_name; [OK]

Quick Trick: Use VACUUM table_name; to clean a table [OK]

Common Mistakes:

Master "Transactions and Concurrency" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free