What is meant by null?

COBOL SQL Interview Questions

(Continued from previous question...)

What is meant by null?

This is a special value that indicates the absence of data in a column. This value is indicated by a negative value, usually -1.

(Continued on next question...)

Other Interview Questions

• Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project ?
• Can one add columns to a table after it has been defined?
• Describe a primary key?
• What do you accomplish by GROUP BY ... HAVING clause ?
• In the WHERE clause what is BETWEEN and IN?
• What is UNION, UNION ALL?
• What is a correlation name?
• What does the term "grant privileges" mean?
• Describe referential integrity?
• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• More...