POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the ROUND() function in PostgreSQL, and how do you use it with numeric values?

How does the CEILING() function work in PostgreSQL?

Explain the use of the FLOOR() function in PostgreSQL.

What does the MOD() function do in PostgreSQL, and can you provide an example?

Describe the purpose of the TRUNC() function in PostgreSQL and how it differs from ROUND().

How would you use the POWER() function in PostgreSQL to calculate the square and cube of a number?

How does PostgreSQL handle division of two integers when using the DIV() function, and what should you be aware of?

Explain how the SIGN() function is used in PostgreSQL and provide an example where it might be useful.

How would you use the LN() function in PostgreSQL to compute the natural logarithm, and why is it important in certain calculations?

In PostgreSQL, how would you calculate the standard deviation of a numeric column using built-in functions, and why is this metric important?