Oracle Exam 1Z0-909 Topic 6 Question 42 Discussion

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

Question #: 42
Topic #: 6

[All 1Z0-909 Questions]

Which two are true about indexes?

ASecondary index access will always be faster than a table scan.

BIndexing all of a table's columns improves performance.

CIndexes contain rows sorted by key values.

DIndexes reduce disk space used.

EIndexes are used to enforce unique constraints.

Show Suggested Answer

Suggested Answer: A

by Malcom at Jul 09, 2024, 09:11 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sherill

3 days ago

D is right, indexes do reduce disk space. Unless you index every single column, that is. Then you're just wasting space.

upvoted 0 times

...

Marg

4 days ago

E is right, indexes are used for unique constraints. I hope they don't try to trick me with that one!

upvoted 0 times

...

Olen

8 days ago

B is definitely false. Indexing all columns would just make the index huge and slow.

upvoted 0 times

...

Yasuko

16 days ago

I disagree with A) Secondary index access will always be faster than a table scan.

upvoted 0 times

...

Donette

16 days ago

A and C seem like the correct answers, but I'm not sure about the others. I'll have to think this through carefully.

upvoted 0 times

...

Krystal

17 days ago

I believe D) Indexes reduce disk space used is also true.

upvoted 0 times

...

Kristeen

20 days ago

I think C) Indexes contain rows sorted by key values is true.

upvoted 0 times

...

Pamella

21 days ago

I disagree with A) Secondary index access will always be faster than a table scan.

upvoted 0 times

...

Dolores

22 days ago

I believe D) Indexes reduce disk space used is also true.

upvoted 0 times

...

Hailey

23 days ago

I think C) Indexes contain rows sorted by key values is true.

upvoted 0 times

...