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

What are the various data types available in db2?

1094

What are the rules for db2 programming?

1089

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8292

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

2126

What is database reorganization?

1128

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

What is the maximum size of varchar data type in db2?

1135

What is syscat in db2?

1010

can we view the access paths created by dbrm ? how ? thx

7098

Is db2 relational database?

979

What is a buffer in memory?

1058

Can we insert update delete in view?

972

What is the physical storage length of timestamp data type?

1095

What is deadlock in db2?

1070

What is schema in db2?

1022