Given a Table with the Structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the Following

Multiple Choice

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate) ,which of the following would find all employees whose name begins with the letter "S" using standard SQL?

A) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C) SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*';
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
E) None of the above.