You issued this command:
DROP TABLE hr.employees;
Which three statements are true? (Choose three.)
You issued this command:
DROP TABLE hr.employees;
Which three statements are true? (Choose three.)
When the HR.EMPLOYEES table is dropped, all indexes defined on the table are dropped as well since they are dependencies of the table. The table may be moved to the recycle bin, particularly in Oracle 10g and later, unless the recycling feature is disabled or the PURGE option is used. All constraints on HR.EMPLOYEES are also dropped since they are tied to the table structure. Synonyms, sequences, and views are independent objects and are not dropped when the HR.EMPLOYEES table is dropped.
Correct answers: A. All indexes defined on HR.EMPLOYEES are dropped C. The HR.EMPLOYEES table may be moved to the recycle bin. E. All constraints defined on HR.EMPLOYEES are dropped.
Reason for option C being correct: C. The HR.EMPLOYEES table may be moved to the recycle bin: In Oracle 10g and later versions, when a DROP TABLE statement is executed, the table may not be immediately deleted but instead moved to the recycle bin. This allows for the possibility of restoring the table from the recycle bin if it was dropped by mistake. However, if the recycle bin is disabled or the PURGE clause is used, the table is completely deleted.
D. Sequences used to populate columns in the HR.EMPLOYEES table are not dropped. Sequences are independent objects from tables, and dropping a table does not delete the associated sequences.