1.

What Are Defaults? Is There A Column To Which A Default Can't Be Bound?

Answer»

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.

Explain different isolation levels:

An isolation level determines the degree of isolation of data between CONCURRENT transactions. The default SQL SERVER isolation level is Read COMMITTED. Here are the other isolation levels (in the ascending order of isolation):

  • Read Uncommitted,
  • Read Committed,
  • Repeatable Read,
  • Serializable

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.

Explain different isolation levels:

An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committed. Here are the other isolation levels (in the ascending order of isolation):


Discussion

No Comment Found

Related InterviewSolutions