What do you mean by NOT NULL WITH DEFAULT? When

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 WITH DEFAULT? When will you use it?

This column cannot have nulls and while insertion, if no value is supplied then it wil have zeroes, spaces or date/time depending on whether it is numeric, character or date/time.
Use it when you do not want to have nulls but at the same time cannot give values all the time you insert this row.

(Continued on next question...)

Other Job Interview Questions

• How do you retrieve the data from a nullable column? –
• What is RUNSTATS?
• When would you prefer to use VARCHAR?
• What is index cardinality? –
• What is the use of VALUE function?
• In the WHERE clause what is BETWEEN and IN? –
• What is a precompiler?
• Name some fields from SQLCA.
• What else is there in the PLAN apart from the access path? –
• What is auditing?
• More...