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 / austin

6 Answers
8546 Views
I also Faced
E-Mail Answers

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

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1057

How is deadlock resolved?

1111

What are db2 tables?

1075

Can we delete records from view?

940

How to create backup table in db2?

1059

What is page size in db2?

938

Explain about dbrm.

1013

What is rct?

1199

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1014

How does a cursor work?

944

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1045

Which isolation level provides highest data integrity?

1077

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1248

What is package in cobol db2?

1098

What is reorg and runstats in db2?

1181