Infobeans-(SQL)

1.what are Transaction level in sql.

2.How to Delete 5lk record fast from table.

3.how magic table work in case of update operation.

4.what is Read uncommited property.

5.what is use of scopeidentity() mssql.

6.when we can use With no-lock sql.

7.difference between Temp table vs Table variable.

8.explain merge query in mssql.