What do you mean by NOT NULL? When will you use

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

(Continued from previous question...)

What do you mean by NOT NULL? When will you use it?

The column cannot have nulls. Use it for key fields.

(Continued on next question...)

Other Job Interview Questions

• How do you eliminate duplicate values in DB2 SELECT ?
• How do you eliminate duplicate values in DB2 SELECT ?
• What is a clustering index ?
• When do you use a LIKE statement?–
• What is 'LIKE' used for in WHERE clause? What are the wildcard characters? –
• How do you read vsam file?
• What is dynamic SQL? ––
• How many clustering indexes can be defined for a table?
• What is a NULL value? What are the pros and cons of using NULLS?
• When you COMMIT, is the cursor closed? - drona questions–
• More...