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

what are the advantages of sql ? : Sql dba

0 Answers  

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

Can we perform dml on view?

0 Answers  

When is the update_statistics command used?

0 Answers  

What is equi join in sql?

0 Answers  

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

What are commit, rollback, and savepoint?

0 Answers  

Explain isolation levels. : Transact sql

0 Answers  

What is normalization sql?

0 Answers  

What are the differences between implicit and explicit cursors?

0 Answers  

what is autonomouse transaction?

3 Answers   Oracle,

How do I view a table in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories