Hmm Virender is correct

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?

Question Posted / keshireddy

6 Answers
8891 Views
I also Faced
E-Mail Answers

Answer Posted / keshireddy

Hmm Virender 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

How does a cursor work?

1038

What is check constraint. Explain with example.

1159

What is a storage group (stogroup)?

1284

What is ibm db2 used for?

1129

What is cascading rollback?

1274

What is a db2 tablespace?

1118

What are the prerogatives?

1127

Can one database have multiple instances?

1095

How do we specify index to include or not during bind process.

2173

What is commit in db2?

1104

What is a trigger in the db2 database?

1140

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1319

What do you mean by cursor?

1030

What is the role of union all and union

1186

Explain the function of data manager.

1095