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

• When do you use a LINK statement ?
• What is a tuple?
• When do you use a LINK statement ?
• How do you select a row using indexes?
• Describe referential integrity?
• What is a join?
• What is normalization and what are the five normal forms?
• Explain the use of the WHERE clause?
• What are foreign keys?
• Describe a primary key?
• More...