Explain different isolation levels ?

Answer:

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

Example:

CREATE INDEX myIndex ON myTable (myColumn)