DBA > Job Interview Questions > Database developer interview questions

Which one of the following correctly selects row

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

(Continued from previous question...)

11. Which one of the following correctly selects rows from the table myTable that have null in column column1?

11. Which one of the following correctly selects rows from the table myTable that have null in column column1?
1. SELECT * FROM myTable WHERE column1 is null
2. SELECT * FROM myTable WHERE column1 = null
3. SELECT * FROM myTable WHERE column1 EQUALS null
4. SELECT * FROM myTable WHERE column1 NOT null
5. SELECT * FROM myTable WHERE column1 CONTAINS null

(Continued on next question...)

Other Job Interview Questions