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

Carissa

2 months ago

Wait, are we supposed to index the index's index? Inception level's getting too high here.

upvoted 0 times

Xochitl

4 days ago

E) Indexes are used to enforce unique constraints.

upvoted 0 times

...

Shasta

10 days ago

C) Indexes contain rows sorted by key values.

upvoted 0 times

...

Reuben

15 days ago

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

upvoted 0 times

...

Sherill

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

Cassie

14 days ago

D) Indexes reduce disk space used.

upvoted 0 times

...

Una

16 days ago

C) Indexes contain rows sorted by key values.

upvoted 0 times

...

Allene

1 months ago

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

upvoted 0 times

...

Marg

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

2 months ago

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

upvoted 0 times

Izetta

1 months ago

D) Indexes reduce disk space used.

upvoted 0 times

...

Malinda

1 months ago

C) Indexes contain rows sorted by key values.

upvoted 0 times

...

Aleta

1 months ago

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

upvoted 0 times

...

Yasuko

2 months ago

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

upvoted 0 times

...

Donette

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

Berry

1 months ago

C is also true because indexes store rows sorted by key values.

upvoted 0 times

...

Lonna

1 months ago

I think A is true because index access is usually faster than scanning the whole table.

upvoted 0 times

...

Krystal

2 months ago

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

upvoted 0 times

...

Kristeen

2 months ago

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

upvoted 0 times

...

Pamella

2 months ago

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

upvoted 0 times

...

Dolores

2 months ago

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

upvoted 0 times

...

Hailey

2 months ago

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

upvoted 0 times

...