ORACLE DATABASE INTERVIEW QUESTIONS

What is the purpose of the COUNT function in SQL?

How do you use the SUM function to calculate the total of a numeric column in Oracle?

What does the AVG function do in SQL?

How do you use the MIN function to find the smallest value in a column in Oracle?

How do you use the MAX function to find the largest value in a column in Oracle?

Can you combine aggregate functions with the GROUP BY clause in Oracle? Provide an example.

How do you handle NULL values in aggregate functions in Oracle?

How can you use multiple aggregate functions in a single query in Oracle?

How do you use aggregate functions with the HAVING clause in Oracle?

Explain a scenario where you need to use COUNT, SUM, AVG, MIN, and MAX together in a complex query and how you would implement it in Oracle?