1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Answers were Sorted based on User's Feedback



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

Answer / tulsi

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

Is This Answer Correct ?    14 Yes 1 No

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

Answer / guru manohar

You can use COUNT(field),MIN(field),MAX(field) functions for
character fields.

For example there is a table called DEPARTMENTS contains the
data as shown below:

DEPARTMENT_ID DEPARTMENT_NAME
---------------------------------
10 Administrator
20 Marketing
50 Shipping
60 IT

1)SELECT COUNT(department_name)
From DEPARTMENTS;

Output: 4

Note: Bcoz there are 4 rows with DEPARTMENT_NAME

2)SELECT MAX(department_name)
From DEPARTMENTS;

Output: Shipping
Note: Bcoz Shipping comes last in sorting by Ascending

3)SELECT MIN(department_name)
From DEPARTMENTS;

Output: Administrator
Note: Bcoz Administrator comes first in sorting by Ascending

Is This Answer Correct ?    7 Yes 0 No

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

Answer / menan

COUNT(field) and MAX(field)

Is This Answer Correct ?    5 Yes 0 No

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

Answer / santhosh , hyd

COUNT(field) and MAX(field)

Is This Answer Correct ?    5 Yes 1 No

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

Answer / sanjeev

You can use COUNT(field),MIN(field),MAX(field) functions for
character fields.

Is This Answer Correct ?    3 Yes 0 No

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

Answer / paresh

COUNT(field) and SUM(field)

Is This Answer Correct ?    2 Yes 8 No

Post New Answer

More SQL PLSQL Interview Questions

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

Is coalesce faster than isnull?

0 Answers  

What is a unique key?

0 Answers  

Why do we use joins in sql?

0 Answers  

how view used for security purposes?

3 Answers   Glam India,




Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

What is the difference between microsoft access and sql?

0 Answers  

What is a ddl command?

0 Answers  

What are basic techniques of indexing?

0 Answers  

What is lookup table in sql?

0 Answers  

What is sql profiling in oracle?

0 Answers  

What is an escape character in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories