What are defaults? Is there a column to which a default
can't be bound?
Answer Posted / guest
Defaults are used to assign some defalut values to
columns . These values are used if user doen to specify a
column value.
Timestamp canot have default clause attached to it
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
Can an extended stored procedure be called from inside a user-defined function?
What are the three types of database design?
Explain the cube operator?
What are the types of database model?
What is the physical representation for a many-to-many relationship?
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?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Why does this query return 0?
What are the three basic rules which are to be followed for the relational model of the database?
What is the database development process?
What are the key features of dbms?
What are data modelling techniques?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What is DB Development software?
In which table collections errors are stored.