MADHURI 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 / i go crazy

6 Answers
8892 Views
I also Faced
E-Mail Answers

Answer Posted / i go crazy

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

Discuss about db2 bind?

1154

Explain various types of locks in db2?

1204

What are the contents of a dclmgen?

1176

What is a bind card?

1278

What do you mean by cursor?

1030

What is nvl in db2?

1147

How is the value function used?

1207

What is cursor stability in db2?

1414

What are the uses of db2 optimizer?

1351

What is the use of commit in db2?

1139

What does reorg do in db2?

1074

Explain in detail about buffer manager and its functionalities?

1139

Explain about rct in db2?

1160

How do I add a column to an existing table in db2?

1080

what are bind concepts in db2 cobol?

1137