D is worng: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9012.htm
When you drop a table, any indexes on the table are dropped and put into the recycle bin along with the table. If subsequent space pressures arise, then the database reclaims space from the recycle bin by first purging indexes. In this case, when you flash back the table, you may not get back all of the indexes that were defined on the table.
ChatGPT find E also correct:
E. A table belonging to one user cannot have an index that belongs to a different user.
Indexes must belong to the same schema as the table. This means that if a table is owned by one user (in one schema), an index on that table must be created within the same schema. The system won’t allow you to create an index on a table that belongs to one user while placing the index under another user’s schema.
D is wrong.
When a table is moved to the recycle bin, indexes on that table are also moved to the recycle bin and can be restored at the same time as the table.
I also think D is not accurate. Because when a table is dropped and moved to the recycle bin (if the recycle bin is enabled), any associated indexes on that table are also moved to the recycle bin.
The recycle bin in Oracle holds dropped objects for a period of time, during which they can be restored if needed. However, the objects in the recycle bin are not permanently dropped until the bin is purged. If an index is dropped along with a table and is moved to the recycle bin, it is not permanently dropped until the recycle bin is purged.
Hi Averagenoob.
You can flashback the table and restore the indexes, it just will be a different name, will it not?
upvoted 5 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.
holdfaststrongly
Highly Voted 2 years, 3 months agoKuraudio
Highly Voted 2 years, 1 month agoPsili
Most Recent 3 months, 2 weeks agoalelejaja
7 months, 3 weeks agolucemqy
1 year, 2 months agoKizTine
1 year, 3 months agoHassanMkhlalati
1 year, 4 months agoTheOracleWasTaken
1 year, 5 months agozouve
1 year, 6 months agoPoke90
1 year, 9 months agoEltelwany
1 year, 10 months agoEltelwany
1 year, 10 months agodexdinh91
2 years agoAveragenoob
2 years, 4 months agoKashka
2 years, 4 months ago