Oracle Database SQL — Question 194

Which three actions can you perform by using the ALTER TABLE command? (Choose three.)

Answer options

• A. Drop pseudocolumns from a table.
• B. Restrict all DML statements on a table.
• C. Lock a set of rows in a table.
• D. Rename a table.
• E. Drop all columns simultaneously from a table.
• F. Enable or disable constraints on a table.

Correct answer: B, D, F

Explanation

The correct answers are B, D, and F because the ALTER TABLE command allows you to restrict DML operations (B), rename a table (D), and enable or disable constraints (F). Options A, C, and E are not valid operations that can be performed with ALTER TABLE.