Q: 3
You issued this command: DROP TABLE hr. employees; Which three statements are true?
Options
Discussion
Option A. B, E. Official guide covers DROP TABLE effects, worth a review if unsure.
My vote is it's A, B, E. Drop table takes out all constraints and indexes tied to the table, and unless you use PURGE, it goes to the recycle bin. Sequences and synonyms aren't affected directly. Open to pushback on this though.
C or D. Had something like this in a mock and picked those, seemed right at the time.
B. A, E imo. Drop table always removes constraints and indexes, and the table itself usually lands in the recycle bin unless PURGE is added. Sequences and synonyms stay, that's a common trap on this kind of question.
D imo. Sequences are independent, so not dropped with the table. Anyone else think C is a trap?
A B, E tbh. Constraints and indexes go with the table, and it hits the recycle bin unless PURGE is used.
Be respectful. No spam.