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

What is dbrm in db2 database?

1035

What is a db2 table?

959

What is concurrency?

1153

What is dclgen (declaration generator)?

1012

What is syscat in db2?

952

define clustering index.

980

Is db2 free?

1038

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2125

What is the advantage in De-normalizing tables in DB2?

1117

What do you mean by between and in? Is between inclusive of specified range values?

1041

What is query_cache_limit?

930

Describe major components of db2?

1044

Is ibm db2 free?

955

What is buffer pool?

1033

What is a collection in db2?

986