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

Which is faster delete or truncate?

1121

What is db2 bind process?

1233

What is lock escalation in db2?

1021

What is cobol db2?

991

What is the reason behind not using select * in embedded sql programs?

1100

What is scrollable cursor in db2?

1050

How can you classify the locks in db2?

1085

What are iseries servers?

1068

What is the max length of sqlca?

1212

What is performance tuning db2?

1056

What is a page in db2?

1025

Is db2 relational database?

971

What is the syntax for seeing the columns and data types of a table in the db2 database?

1161

How to fetch the last row from the table in SQL (db2)?

1645

what is diffrence b/w file-aid tool and file-aid utility???

4886