A large table EMPLOYEES (EmployeeNo (primaryKey), FirstName, Salary, Dapt, Address) has a
composite index placed on columns (FirstName, LastName). Which statement will most likely use
index-only access?

A.
SELECT FirstName from EMPLOYEES where LastName = ‘Hogan’

B.
SELECT FirstName, LastName from EMPLOYEES where salary > 80000;

C.
SELECT LastName, EmployeeNo from EMPLOYEES where EmployeeNo > 100;

D.
SELECT LastName, FirstName from EMPLOYEES where EmployeeNo = 100;