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

Sarah

28 days ago

I'd write a clever comment about index puns, but I'm too in-dexed right now.

upvoted 0 times

...

Marvel

1 months ago

F is a bit of a trick question. Of course an update can affect the indexes - that's kind of the whole point of having them!

upvoted 0 times

Janey

16 days ago

User1: A, B, and D are true.

upvoted 0 times

...

Eva

1 months ago

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

upvoted 0 times

Keva

8 days ago

B) A SELECT statement can access one or more indices without accessing any tables

upvoted 0 times

...

Yuki

16 days ago

A) A UNIQUE index can be altered to be non-unique

upvoted 0 times

...

Reita

1 months ago

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

upvoted 0 times

Owen

4 days ago

User3: C is also true, a table belonging to one user can have an index that belongs to a different user.

upvoted 0 times

...

Bronwyn

8 days ago

User2: D is true, an update to a table can result in updates to any or all of the table's indexes.

upvoted 0 times

...

Angelyn

9 days ago

User1: A is correct, a UNIQUE index can be altered to be non-unique.

upvoted 0 times

...

Nakisha

1 months 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

2 months 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

2 months 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

2 months ago

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

upvoted 0 times

...