1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

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

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

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

More DB Development Interview Questions

How is data stored in dbms?

1 Answers  

Can an extended stored procedure be called from inside a user-defined function?

1 Answers  

Explain about relational database management systems?

1 Answers  

Explain about the storage and physical database design?

1 Answers  

What are data modelling techniques?

1 Answers  

Where is dbms used?

1 Answers  

Explain about xml databases?

1 Answers  

What is data modeling with example?

1 Answers  

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?

1 Answers  

Can you instantiate a COM object by using T-SQL?

1 Answers  

Write the fastest query to find out how many rows exist in a table?

1 Answers  

Explain about network model?

1 Answers  

For more DB Development Interview Questions Click Here
Categories