A large table $D.A.T (EmployeeNo(primaryKey), Name, LastName, Salary, Dept, Address) has an
index (Name, LastName). Which statement can avoid a table scan?

A.
Select * from $D.A.T where Name like “%N”;

B.
Select * from $D.A.T where Name like “%N”and LastName =”bbb”;

C.
Select * from $D.A.T;

D.
Select * from $D.A.T where Name = “ANN”;