Which Function Can You Use in Oracle, MySQL, and SQL

question 7

Multiple Choice

Which function can you use in Oracle, MySQL, and SQL Server to truncate everything to the right of the decimal point?

• A) TRUNCATE
• B) FLOOR
• C) ROUND
• D) TRIM

---

Definitions:

Computed

Refers to something that has been determined or calculated using a computer or calculator.

Net Present Value

A method used in capital budgeting to assess the profitability of an investment or project, calculated by discounting the expected future cash flows to their present values and subtracting the initial investment.

Present Value

The immediate value of a future amount of money or a series of payments, discounted at a given rate of return.

Compound Interest

Interest calculated on the initial principal and also on the accumulated interest of previous periods.