Oracle Database Administration I — Question 147

You issued this command:

DROP TABLE hr.employees;

Which three statements are true? (Choose three.)

Answer options

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

Correct answer: A, C, E

Explanation

Option A is correct because dropping a table also removes all associated indexes. Option C is true as the table can be moved to the recycle bin if the recycle bin feature is enabled. Option E is correct since all constraints on the table are dropped when the table is removed. Options B, D, and F are incorrect because synonyms, sequences, and views remain intact unless specifically dropped.