A: This is true. Using PURGE in the DROP TABLE command will permanently remove the table and its dependent objects so that it cannot be recovered, and the action cannot be rolled back.
B: This statement is true. Dropping the base table will result in the removal of all views that are based on the DEPARTMENTS table.
C: This statement is false. The PURGE option removes the table and does not just delete rows.
D: This statement is true. The DROP TABLE command will remove the DEPARTMENTS table from the database.
E: This statement is true. When a table is dropped, all synonyms for that table are also removed.
F: This statement is true. Dropping a table will automatically drop all indexes associated with the table.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit