What is the result of this query if no rows are

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

(Continued from previous question...)

What is the result of this query if no rows are selected:

SELECT SUM(SALARY)
FROM EMP
WHERE QUAL=‘MSC’;
NULL

(Continued on next question...)

Other Job Interview Questions

• What is the difference between SYNONYM and ALIAS?
• What is a thread?
• What do you accomplish by GROUP BY ... HAVING clause? ––
• What is a clustered index?
• What is filter factor?
• Is there any advantage to denormalizing DB2 tables?
• How do you select a row using indexes in DB2?
• What is a clustering index ?
• What are aggregate functions?
• What is a cursor? why should it be used? –
• More...