What Is the Result of the Following SQL Query

question 98

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

---

Definitions:

Output

The total amount of goods or services produced by a firm, industry, or economy in a given period.

Average Fixed Costs

The fixed costs of production divided by the quantity of output produced, decreasing as production increases.

Annual Fixed Cost

The total of all business expenses that remain constant regardless of any change in production levels or sales volume over a year.

Total Output

The aggregate quantity of goods or services produced by an economy, sector, or production process over a specific period.