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

Answer Posted / shankar

when we specified NOT NULL WITH DEFAULT in the query ,the
database will set the default values to that key eg. system
date ,time.

Is This Answer Correct ?    9 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is role in db2?

620


What is a db2 schema?

762


What does sqlcabc has?

631


Define data page.

633


What is lock escalation in db2?

574






What are db2 tables?

647


Explain various types of locks in db2?

689


List out the buffer pools in db2

628


What is db2? Explain.

606


What is db2 instance?

590


How to rename a table in DB2 ?

637


How to connect to db2 database from windows command line?

562


Which components manage deadlocks in db2?

610


Which component is responsible for db2 startup and shutdown?

629


What is the maximum No of rows per page?

626