What do you mean by NOT NULL? When will you use it?
- 3 Answers
- 6746 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / andank
NOT NULL is the keyword used define columns, when create a
table. When you specify NOT NULL to a column, that column
can not hold NULL values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / s
CREATE UNIQUE WHERE NOT NULL INDEX index1
ON table(column);
WHERE NOT NULL ensures that non-null values are unique.
| Is This Answer Correct ? | 0 Yes | 0 No |
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
Which isolation level provides maximum concurrency?
What is a trigger in the db2 database?
List out the buffer pools in db2
What does DSNDB07 database do?
why we go for SPUFI for creating tables or for sql queries?
What is SPUFI?
What is db2 command?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
How to restart a DB2 program?
What is cursor stability in db2?
COBOL 
