Consider the employee table with column PROJECT

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

(Continued from previous question...)

Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project ?

SELECT EMPNO FROM EMP WHERE PROJECT IS NULL;

(Continued on next question...)

Other Job Interview Questions

• Describe a primary key?
• What is the difference between static and dynamic SQL?
• What is the syntax for a CREATE TABLE statement ?
• Any SQL implementation covers data types in couple of main categories. Which of the following are those data types?
• What is a foreign key?
• What is the syntax for a CREATE TABLE statement ?
• What is a tuple?
• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• Describe a primary key?
• What is a cursor? Why should it be used ?
• More...