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

Why left join is used in sql?

0 Answers  

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

What is file based approach?

0 Answers  

can i use global variables in stored procedure or function

1 Answers   L&T,

What are sql constraints?

0 Answers  

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

0 Answers  

How to call a javascript function from pl sql?

0 Answers  

What does over partition by mean in sql?

0 Answers  

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

Define overloaded procedure?

0 Answers  

State some properties of relational databases?

0 Answers  

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories