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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default page size of buffer pools?

889


Mention the different locking levels that are available in db2.

888


What is null value in db2?

781


What happens in bind step in a db2 program?

750


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1517


Mention the definition of cobol in varchar field.

921


What is the reason behind not using select * in embedded sql programs?

871


Explain the contention situations caused by locks?

818


What is the difference between nvl and coalesce?

840


What is package in cobol db2?

896


How do I delete a table in database?

805


How to find the number of rows in db2 tables?

833


What is schema in db2?

794


What is the maximum number of columns in a db2 table?

1015


What are packages in db2?

811