My SQL statement SELECT AVG(SALARY) FROM EMP-TAB

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-TABLE yields inaccurate results. why?

Because SALARY is not declared to have Null's and the employees for whom the salary is not known are also counted

(Continued on next question...)

Other Job Interview Questions

• Describe the elements of the SELECT query syntax?
• Explain the use of the WHERE clause?
• What is the basic differnce between a join and a union?
• What is an index key?
• When do you use a LINK statement ?
• What is a tuple?
• What is normalization and what are the five normal forms?
• What are foreign keys?
• Explain the use of the WHERE clause?
• What are foreign keys?
• More...