Multiple Choice
What is the result of the following SQL query?
SELECT ename
FROM employee
WHERE esalary = (SELECT MAX(salary) FROM employee) ;
A) The query displays the number that represents how many employees share the highest salary
B) The query displays the salary of the employee (or employees) with the highest salary
C) The query displays the name and the salary of the employee (or employees) with the highest salary
D) The query displays the name of the employee (or employees) with the highest salary
Correct Answer:

Verified
Correct Answer:
Verified
Q90: What is determined by the WHERE condition
Q91: HAPPY INSURANCE<br>Observe the HAPPY INSURANCE DATABASE:<br>CLIENT<br>
Q92: HAPPY INSURANCE<br>Observe the HAPPY INSURANCE DATABASE:<br>CLIENT<br>
Q93: VEHICLE<br>Observe the table VEHICLE that contains
Q94: STUDENT<br>Observe the table STUDENT:<br>STUDENT<br> <br> <span
Q95: Which of the following statements would be
Q96: VEHICLE<br>Observe the table VEHICLE that contains
Q97: VEHICLE<br>Observe the table VEHICLE that contains
Q99: List the SQL aggregate functions.
Q100: Why is the following query invalid:<br>SELECT productname,COUNT