SQL Server supports three types of indexes: clustered, unclustered, and random.
Indicate whether the statement is true or false
Question 2
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 Microsoft Access?
A) SELECT
FROM EMPLOYEE
WHERE Name IN 'S';
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C) SELECT
FROM EMPLOYEE
WHERE Name LIKE 'S';
D) SELECT
FROM EMPLOYEE
WHERE Name LIKE 'S';