A large table $D.A.T (EmployeeNo (primaryKey), Name, LastName, Salary, Dept, Address) has an
index (Name, LastName) Which statement will most likely use index-only access?
A.
SELECT EmployeeNo from $D.A.T.
B.
SELECT EmployeeNo, Salary from $D.A.T.
C.
SELECT Name, LastName from $D.A.T order by Name.
D.
SELECT LastName, EmployeeNo from $D.A.T where EmployeeNo > 100.