Lalit, I contradict your answe because the question itself says that ther

what will be the output of the below given query, if no
matching records are found : (a.) 0 (b.) null (c.) error

select Avg(salary)
from TableA
where Deptno = 'insurance'

Question Posted / guest.

10 Answers
16297 Views
Amdocs, I also Faced
E-Mail Answers

Answer Posted / guest.

Lalit, I contradict your answe because the question itself
says that there is no matching record with
deptno='insurance'. So (b)is the correct answer.

Is This Answer Correct ?

20 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is db2 bind process?

1223

What is nvl in db2?

1085

What is the difference between cursor stability and repeatable read isolation levels?

1153

What is the use of reorg in db2?

1068

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

7059

Which isolation level provides highest data integrity?

1098

Which is faster delete or truncate?

1110

What is reorg?

1132

What is check constraint in db2?

1063

What is the syntax for FETCH in DB2 ?

1187

What is the difference between using bind () and rebind () methods of naming class?

1376

What is scrollable cursor in db2?

1042

What is meant by explain?

1113

What is a db2 cursor?

1033

Explain the contents that are a part of dclgen.

1073