MYSQL DATABASE INTERVIEW QUESTIONS

What are arithmetic operators in MySQL and what are they used for?

Can you explain how the addition operator (+) is used in MySQL?

What does the modulus operator (%) do in MySQL?

. How would you use the subtraction operator (-) to find the difference between two column values in a table?

Describe a scenario where you might use the multiplication operator (*) in a MySQL query.

How can the division operator (/) be used to calculate averages in MySQL?

Explain how you would use arithmetic operators to calculate the total revenue from sales data in MySQL.

How might you use arithmetic operators to adjust prices by a percentage in a MySQL query?

Discuss how arithmetic operators can be combined in a single MySQL query to perform complex calculations.

In a database certification exam, you are asked to explain how arithmetic operators can be used to create a financial report that includes total sales, average sales per day, and remaining inventory value. How would you describe the process?