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

question 5

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

---

Definitions:

COUNT Aggregate Function

A function in SQL that returns the number of items in a group, often used in queries to count the number of records that match certain criteria.

Query Design View

A graphical interface in database software that allows users to design or modify queries by visually arranging tables and setting criteria.

Values

Represents the data encoded within variables or constants in programming and computing contexts.

Table Datasheet View

A view in database software that displays data in rows and columns, similar to a spreadsheet, allowing for data entry and editing.