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

What is the difference between the implicit and explicit cursors?

523


What are the events on which a database trigger can be based?

593


What is sap sql anywhere?

533


Why primary key is required?

554


what is error ora-03113: end-of-file on communication channel?

599






how to enter binary numbers in sql statements? : Sql dba

487


How do I make sql search faster?

552


Explain commit, rollback and savepoint.

603


What is data definition language?

619


What is keys and its types?

538


what are date and time intervals? : Sql dba

564


How is a process of pl/sql compiled?

598


What is graph sql?

524


Why do we use %rowtype & %type in plsql?

601


What are hotfixes and patches?

527