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

question 16

Multiple Choice

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate) ,which of the following is not a valid ANSI SQL command?

• A)SELECT *
• FROM EMPLOYEE
• WHERE Name LIKE 'Ja%';
• B)SELECT COUNT(*)
• FROM EMPLOYEE
• WHERE Salary < 30000;
• C)SELECT HireDate,COUNT(*)
• FROM EMPLOYEE
• GROUP BY HireDate;
• D)SELECT HireDate,COUNT(*)
• FROM EMPLOYEE
• WHERE Salary < 30000;

---

Definitions:

Ointment

A semi-solid preparation applied topically to the skin or mucous membranes for therapeutic reasons.

Parenteral

Any medical therapy administered in a way other than through the digestive system, commonly including injections through intravenous, intramuscular, or subcutaneous methods.

Enema

A procedure in which liquid or gas is injected into the rectum to expel its contents or to introduce drugs or permit X-ray imaging.

Prescription

A written order from a healthcare professional authorizing a patient to be provided a medicine or treatment.