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.
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.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
cf1f99b
1 month, 3 weeks agoit6567306
8 months, 1 week agoit6567306
8 months, 1 week agosobrinho
8 months, 2 weeks ago