MYSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the ABS() function in MySQL?

How does the ROUND() function work in MySQL?

What does the CEIL() function do in MySQL?

Can you explain the difference between the FLOOR() and CEIL() functions in MySQL?

What is the purpose of the MOD() function in MySQL, and how is it used?

How does the TRUNCATE() function differ from the ROUND() function in MySQL?

Describe how the POW() function works in MySQL and provide a use case.

What is the SQRT() function, and when would you use it in MySQL?

Explain the SIGN() function and its typical applications in MySQL.

During a database certification exam, you are asked to explain how you would use numeric functions to handle rounding errors in financial calculations. What would be your approach?