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 / tulsi

1)THE COUNT(field) and MAX(field) CAN BE USED WITH
CHARACTER FIELDS

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql a dbms?

732


What is pl/sql language case sensitive?

828


What is recursive stored procedure?

818


How does an execution block start and end in pl sql?

674


How can we implement rollback or commit statement in a trigger?

789






Is sql injection illegal?

771


What is left join in sql?

753


What is sql exception?

705


What is the advantage of nosql?

735


what is the difference between undefined value and null value? : Sql dba

783


What does where 1/2 mean in sql?

762


Can you join a table to itself?

712


Why plvtab is considered as the easiest way to access the pl/sql table?

835


how to present a past time in hours, minutes and seconds? : Sql dba

739


What is auto increment feature in sql?

819