What are defaults? Is there a column to which a default
can't be bound?
Answers were Sorted based on User's Feedback
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 |
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 |
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?
Explain the role of indexing in databases?
what is Normalization?
Explain about query and reporting.
Explain about the storage and physical database design?
How to generate OIDS
What is the maximum length of an extended property?
What are cursors? Explain different types of cursors?
What is data modeling with example?
What are triggers? How many triggers you can have on a table?
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?