Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers  

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

what is unique key constraint? : Sql dba

0 Answers  

What is a sql driver?

0 Answers  

What is dba in sql? : SQL DBA

0 Answers  

Why do we need pl sql?

0 Answers  

When is a declare statement required?

0 Answers  

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

what is explain plan?

4 Answers  

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

For more SQL PLSQL Interview Questions Click Here
Categories