Oracle Exam 1Z0-082 Topic 16 Question 90 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 90
Topic #: 16

[All 1Z0-082 Questions]

Which three statements are true regarding indexes? (Choose three.)

AA UNIQUE index can be altered to be non-unique

BA SELECT statement can access one or more indices without accessing any tables

CA table belonging to one user can have an index that belongs to a different user

DAn update to a table can result in updates to any or all of the table's indexes

EWhen a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

FAn update to a table can result in no updates to any of the table's indexes

Show Suggested Answer

Suggested Answer: A, C

by Hassie at Apr 24, 2024, 06:13 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Eva

2 days ago

E is also incorrect. When a table goes to the recycle bin, its indexes don't disappear forever.

upvoted 0 times

...

Reita

7 days ago

B is just plain wrong. You can't access an index without accessing the underlying table.

upvoted 0 times

...

Nakisha

9 days ago

A and D are the correct answers here. Indexes can be altered, and updates to a table can definitely affect its indexes.

upvoted 0 times

...

Hyman

16 days ago

I think statement D is true as well. An update to a table can result in updates to its indexes.

upvoted 0 times

...

Theresia

18 days ago

I agree with you, Omega. I also believe statement B is true because a SELECT statement can access indices without accessing tables.

upvoted 0 times

...

Omega

20 days ago

I think statement A is true because a UNIQUE index can be altered.

upvoted 0 times

...