DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS

My SQL statement SELECT AVG(SALARY) FROM EMP yie

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.

(Continued on next question...)

Other Job Interview Questions