What do you mean by NOT NULL? When will you use it?
Answer Posted / s
NOT NULL disallows nulls for the column. Primary Key must
be defined as NOT NULL or any key that you do not want to
have NULLS, becaue the default is that any column can
contain NULLs
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of rollback and commit?
What is node in db2?
Name the various locking levels available?
Is it possible using max on a char column?
What is explain plan in db2?
How to execute stored procedure in db2 command editor?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the maximum No of rows per page?
What is image copy in db2?
What is difference between isnull and coalesce?
How to create db2 table in mainframe?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Are view updateable?
Mention the various locks that are available in db2.
When do you specify the isolation level?