Interview Question for Software Engineer at PayPal:

We have the following schema of a table: create table Test (id number, name varchar2(32), desc varchar2(400)); create index index_test on Test (name); Which of the following statements will invoke an index scan by oracle execution plan a) select * from test where name='name'; b) select * from test where name like 'name%'; c) select * from test where name like '%name'; d) select * from test where name like '%name%';"