Select the index that should be created in CUSTOMER_INFO table to improve the performance of the below query: SELECT name, address FROM CUSTOMER_INFO WHERE phone = 7265776867;

create index customer_index on customer_info (name, address)

create index customer_index on customer_info(name, address, phone)

create index customer_index on customer_info(phone)

All of the above

Correct Option - c

To get all Infosys Certified MySQL Associate Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in