The actions possible using the ALTER TABLE command:
E . Rename a table: The ALTER TABLE command can be used to rename a table, although the syntax typically involves RENAME TO as part of table management.
F . Enable or disable constraints on a table: This is a standard use of the ALTER TABLE command, allowing for constraints to be enabled or disabled, which is critical for managing table integrity during data loads or maintenance.
Incorrect options:
A: You cannot drop pseudo columns from a table as they are not explicitly defined or managed like regular columns.
B: The ALTER TABLE command does not directly restrict DML statements; this would typically be managed through security roles or other database mechanisms.
C: Dropping all columns from a table simultaneously is not possible; a table must retain at least one column.
D: Locking a set of rows is performed with SQL commands like SELECT FOR UPDATE, not with ALTER TABLE.