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

question 49

Multiple Choice

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 standard SQL?

• 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.

---

Definitions:

Per Share FCFE

The amount of Free Cash Flow to Equity available per share of a company's stock, indicating the dividend-paying ability and financial health of the company.

Required Rate of Return

The smallest percentage of yearly earnings from an investment necessary to attract individuals or businesses to invest in a certain security or project.

FCFF Valuation Model

The FCFF Valuation Model estimates a company's value by using its Free Cash Flow to the Firm (FCFF), discounting the cash flows to their present value using the weighted average cost of capital.

WACC

Weighted Average Cost of Capital; the average rate of return a company is expected to pay its security holders to finance its assets, integrating debt and equity.