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
Explain about xml databases?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Explain what a database is?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Who are end users in dbms?
What is dbms and its application?
How to use timestamp datatypes
State the acid rules?
What is DB Development software?
How would you design a database for an online site, which would average a million hits a day?
How to customize error conditions.
Explain about the relational database?
What are the three types of database design?
How you can make a parameterized view?
How to use online Backups?