Which one of the following pairs of aggregate functions do
you use with character fields?

1. COUNT(field) and MAX(field)
2. AVG(field) and COUNT(field)
3. MIN(field) and SUM(field)
4. AVG(field) and MAX(field)
5. COUNT(field) and SUM(field)

Answer Posted / santhosh , hyd

COUNT(field) and MAX(field)

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pl sql architecture?

686


What is a database? Explain

788


how can we destroy the cookie? : Sql dba

743


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

798


What is the difference between join and natural join?

655






What is $$ in sql?

728


Is keyword pl sql?

732


what are all different types of collation sensitivity? : Sql dba

710


How to add a column ‘salary’ to a table employee_details?

771


What is difference between joins and union?

748


Can two tables have same primary key?

731


How can we find duplicate records in a table?

664


What are triggers in sql?

749


Is there a way to automate sql execution from the command-line, batch job or shell script?

746


What packages are available to pl/sql developers?

811