MSSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the ABS() function in MSSQL, and how do you use it?

How do you use the CEILING() function in MSSQL?

How do you use the FLOOR() function in MSSQL?

How do you use the ROUND() function in MSSQL to round a number to a specified number of decimal places?

How do you use the POWER() function in MSSQL to raise a number to a specified power?

How do you use the SQRT() function in MSSQL to calculate the square root of a number?

How do you use the LOG() function in MSSQL to calculate the natural logarithm of a number?

How do you use the EXP() function in MSSQL to calculate the exponential value of a number?

How do you use the TRUNCATE() function in MSSQL to truncate a number to a specified number of decimal places?

Explain a scenario where using numeric functions in MSSQL is crucial for a business application and describe how you would implement it.