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 issuing the DROP TABLE command on HR.EMPLOYEES, all associated constraints and indexes on the HR.EMPLOYEES table are also dropped. Additionally, depending on the database configuration, the HR.EMPLOYEES table may be moved to the recycle bin, allowing for potential recovery. Sequences, synonyms, and views that reference the table are not automatically dropped but may become invalid.
DEF for me
DEF, I think synonyms and views are invalidated but not dropped
B,C,D are correct
DEF is correct
I think the same as lucemqy and jm9999
Views and synonyms are not dropped but invalid
For me, only EF proved to be true. The constraint was still listed in user_constraints after issuing the drop. I think ABC are definitely false and you have to pick 3 so ....
D,E,F are correct