Author Question: SQL Server supports three types of indexes: clustered, unclustered, and random. Indicate whether ... (Read 60 times)

gonzo233 · **on:** Jul 7, 2018

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