Given a Table with the Structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the Following
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 Name
WHERE EMPLOYEE LIKE 'S*';
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
E) None of the above.
Correct Answer:
Verified
Q53: Only two tables can be queried by
Q54: Two or more tables are joined by
Q56: The clause SELECT COUNT (*)results in a
Q61: In an SQL query,which SQL keyword must
Q62: In an SQL query,which of the following
Q64: In an SQL query,which built-in function is
Q65: In an SQL query,which SQL keyword is
Q66: In an SQL query,which of the following
Q67: In an SQL query,which built-in function is
Q68: In an SQL query,which built-in function is
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents