What are defaults? Is there a column to which a default
can't be bound?

Answer Posted / leena

A default is a value that will be used by a column, if no
value is supplied to that column while inserting data.
IDENTITY columns and timestamp columns can't have defaults
bound to them

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

1813


Explain what a database is?

603


Who are end users in dbms?

542


How to generate OIDS

1660


Which four data types cannot be used as a return type from a user-defined function?

577






When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1780


Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1599


The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

572


Explain about relational database management systems?

563


Explain the process of the user request and data generating?

647


How would you design a database for an online site, which would average a million hits a day?

574


What are the constraints on severity level in raiseerror?

580


How is data stored in dbms?

518


Explain about query and reporting.

1682


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3426