Oracle Database SQL — Question 158

You issued this command:

DROP TABLE hr.employees;

Which three statements are true? (Choose three.)

Answer options

• A. Sequences used to populate columns in the HR.EMPLOYEES table are dropped.
• B. Synonyms for HR.EMPLOYEES are dropped.
• C. Views referencing HR.EMPLOYEES are dropped.
• D. All constraints defined on HR.EMPLOYEES are dropped.
• E. The HR.EMPLOYEES table may be moved to the recycle bin.
• F. All indexes defined on HR.EMPLOYEES are dropped

Correct answer: D, E, F

Explanation

The correct answers D, E, and F are accurate because when a table is dropped, all constraints, indexes, and the possibility of moving the table to the recycle bin are affected. Options A, B, and C are incorrect as sequences, synonyms, and views remain unaffected by the drop command on the table.