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...

If a table has a column "dept" (declared to have nulls) and
there are 10 rows in the table of which 3 have a null value
in the dept column, what will select count(*) and select
count(distinct dept) return?

Answer Posted / austin

MADHURI IS CORRECT.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is db2 relational database?

979


When reorg is used?

1129


What is the clustering index in the db2 database?

1001


What is check constraint in db2?

1089


What does db2 plan contain?

1021


How to get the ddl of a table in db2?

1131


What is the role of union all and union

1129


What is a db2 package?

1058


What is runstats and reorg in db2?

1304


What is copy pending status in db2?

1127


What is temporal table in db2?

1041


What is precompiler in db2?

1022


What is lock escalation in db2?

1033


How does cobol compile db2 program?

1059


Explain packages.

1113