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

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)

Question Posted / tulsi

6 Answers
16354 Views
HCL, I also Faced
E-Mail Answers

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 an exception in PL/SQL? What are the two types of exceptions?

1312

Why cross join is used?

1078

What is the difference between row level and statement level trigger?

1023

Why do we use joins in sql?

971

What is compiled query?

1038

Where is sql database stored?

983

What are sql*plus environment variables?

1096

What is the difference between the implicit and explicit cursors?

1052

What are all the different types of indexes?

1148

Mention what pl/sql package consists of?

999

how many sql dml commands are supported by 'mysql'? : Sql dba

1124

How do you change a value in sql?

1020

how many values can the set function of mysql take? : Sql dba

989

What is a constraint?

1023

Explain 3 basic parts of a trigger.

1324