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

I have a few records all are same structures data, I want to store data in multiple targets how

0 Answers   CTR, Infosys, Polaris,

Explain the rollup operator?

0 Answers  

Explain the role of indexing in databases?

0 Answers  

what is Normalization?

6 Answers   TCS,

Explain about query and reporting.

0 Answers  




Explain about the storage and physical database design?

0 Answers  

How to generate OIDS

0 Answers  

What is the maximum length of an extended property?

0 Answers  

What are cursors? Explain different types of cursors?

6 Answers  

What is data modeling with example?

0 Answers  

What are triggers? How many triggers you can have on a table?

2 Answers   Ramco,

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

For more DB Development Interview Questions Click Here
Categories