Oracle Exam 1Z0-909 Topic 4 Question 8 Discussion

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

Question #: 8
Topic #: 4

Examine these statements which execute successfully:

Which two changes will improve this query performance?

ACREATE INDEX 1X7 ON users (user_name) USING HASH;

BCREATE INDEX 1X4 ON Locations (site_id, loc_shared);

CCREATE INDEX IX1 ON locations (loc_shareci) ;

DCREATE INDEX 1X6 ON users (user_name);

ECREATE INDEX 1X3 ON locations <loc_site_id) ;

FCREATE INDEX 1X2 ON locations (loc_mapping) USING HASH; fH

GCREATE INDEX 1X5 ON users (loc_id);

Show Suggested Answer

Suggested Answer: A, D

by Allene at Sep 18, 2022, 08:55 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!