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%';
C
You might also like to view...
In a ________, the manager is responsible for generating revenues and controlling costs.
A) cost center B) profit center C) revenue center D) transfer pricing center
If possible the salesperson should have the prospect view, touch, or test the product during the presentation.
Answer the following statement true (T) or false (F)
Which of the following models is a picture or drawing of reality?
A) physical model B) schematic model C) scale model D) mathematical model E) analytical model
One does not need to determine if the operating expenses are in line with industry averages
Indicate whether the statement is true or false