You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? | Oracle

A. SELECT last_name FROM EMP WHERE last_name LIKE'_A%;
B. SELECT last_name FROM EMP WHERE last name='*A%
C. SELECT last_name FROM EMP WHERE last name ='* _A%;
D. SELECT last_name FROM EMP WHERE last name LIKE '* a%

Ans:A