For each SQL query below, recommended an index or set of indexes, and explain your decision

SELECT * FROM EMP WHERE Name=John Doe Will benefit from (a) Tree-index on Name (b) Hash-index on Name (c) Tree-Index on Salary (d) Hash-Index on Salary (e) Both (a) and (b) (f) Both (c) and (d) explain

SELECT * FROM EMP WHERE LName=Smith AND Salary < 10000 Will benefit the most from (a) Tree-index on Name, Salary (b) Hash-index on Name, Salary (c) Tree-Index on Salary (d) Hash Index on Salary explain