Which two statements are true regarding indexes? (Choose two.)
Which two statements are true regarding indexes? (Choose two.)
When a table is updated, any indexes on the table may also need to be updated to reflect the changes, which makes option A correct. However, if the update does not affect the indexed columns, no updates to the indexes are needed, which supports option B. Option C is incorrect because a UNIQUE index typically cannot be altered to be non-unique; a new index would usually need to be created. For option D, when a table is moved to the recycle bin, its indexes are also moved there and are not permanently dropped initially, making this incorrect. Option E is incorrect as indexes can belong to different users than the table owner.
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.
A and B can co-exist. Answer should be ABD.
D is wrong, indexes can be restored
for me ABE
a and b. I tried E out and you can create an index on someone else's table
D is definitely not correct since index are moved to recycle bin not permanently removed
ABD it should be
Hi Averagenoob. You can flashback the table and restore the indexes, it just will be a different name, will it not?
BD are correct
A is correct as well, it should be ABD.
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.
AB exactly
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.
D can not be correct. Indexes are sent to the recycle bin as well