What are defaults? Is there a column to which a

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

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. See CREATE DEFAULT in books online.

Other Job Interview Questions

• Database design - What is normalization? Explain different levels of normalization?
• CREATE INDEX myIndex ON myTable(myColumn)What type of Index will get created after executing the above statement?
• CREATE INDEX myIndex ON myTable(myColumn)What type of Index will get created after executing the above statement?
• What is a transaction and what are ACID properties?
• When you create a database how is it stored?
• What are constraints? Explain different types of constraints.
• How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
• If you encounter this kind of an error message, what you need to look into to solve this problem?
• Explain different isolation levels
• Define candidate key, alternate key, composite key.
• More...