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 is Referential Integrity?

3 Answers  

What is sql exception?

0 Answers  

how to insert the records in particular position

1 Answers  

What is a dynamic query?

0 Answers  

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

Why function is used in sql?

0 Answers  

How can we schedule the procedure to run automatically ?

3 Answers  

What is cursor explain with example?

0 Answers  

What is the benefit of foreign key?

0 Answers  

Why is stored procedure faster than query?

0 Answers  

What is trigger explain with example?

0 Answers  

What are the different set operators available in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories