Interested to Buy Any Domain ? << Click Here >> for more details...
What do you mean by NOT NULL? When will you use it?
- 3 Answers
- 6667 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 |
What's the maximum number of characters that a tablename can have?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is a buffer in memory?
What is subquery ?
What is referential integrity?
What does a deadlock mean in DB2?
What are the 2 sqlcodes that are returned?
WHAT IS MEANT BY COMMIT COMMAND?
Define buffer pool.
What is the FREE command?
Is db2 a programming language?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
COBOL 
