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%';

Question

Quizplus · Accepted Answer

The SQL statement "SELECT * FROM EMPLOYEE WHERE Name LIKE 'S%'" will find all employees whose name begins with the letter "S". The % wildcard character after the "S" will match any number of characters after the "S", allowing for any name that begins with "S" to be selected. Option A is incorrect because the IN operator is used to match specific values in a list, not a pattern. Option B is incorrect because the LIKE operator requires a wildcard character to match a pattern. Option C is incorrect because it tries to select from the Name column, which is not a valid table or column in this scenario.

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