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
8722 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 database alias db2?

1132

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2860

What is netezza database?

1032

Who uses db2?

1056

What is package in db2 mainframe?

992

What is the picture clause of null indicator variable?

1138

What is image copy in db2?

1023

How do you concatenate the firstname and lastname from emp table to give a complete name?

1077

Can you use max on a char column?

1097

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1111

Highlight all the advantages that are attached to a package.

1121

What is clone table?

1054

i want to maintain uniqueness on pdf without make lf??????????

2158

Can there be more than one cursor open for any program?

1173

Is db2 a mainframe database?

1006