ORACLE DATABASE INTERVIEW QUESTIONS

What is the purpose of the ROUND function in Oracle SQL?

How do you use the TRUNC function to truncate a number in Oracle SQL?

How do you find the absolute value of a number using the ABS function in Oracle SQL?

How do you use the CEIL function in Oracle SQL?

How do you use the FLOOR function in Oracle SQL?

How do you use the MOD function to find the remainder of a division in Oracle SQL?

How do you use the POWER function to calculate the power of a number in Oracle SQL?

How do you use the SQRT function to find the square root of a number in Oracle SQL?

How do you use the EXP function to calculate the exponential value in Oracle SQL?

Explain a scenario where you need to use multiple numeric functions in a real-world application and how you would implement it in Oracle.