SQL Server Locks Question:

Download Job Interview Questions and Answers PDF

Explain what are the events recorded in a transaction log?

MS SQL Server Locks Interview Question
MS SQL Server Locks Interview Question

Answer:

Events recorded in a transaction log:

Broker event category includes events produced by Service Broker.
Cursors event category includes cursor operations events.
CLR event category includes events fired by .Net CLR objects.
Database event category includes events of data.log files shrinking or growing on their own.
Errors and Warning event category includes SQL Server warnings and errors.
Full text event category include events occurred when text searches are started, interrupted, or stopped.
Locks event category includes events caused when a lock is acquired, released, or cancelled.
Object event category includes events of database objects being created, updated or deleted.
OLEDB event category includes events caused by OLEDB calls.
Performance event category includes events caused by DML operators.
Progress report event category includes Online index operation events.
Scans event category includes events notifying table/index scanning.
Security audit event category includes audit server activities.
Server event category includes server events.
Sessions event category includes connecting and disconnecting events of clients to SQL Server.
Stored procedures event category includes events of execution of Stored procedures.
Transactions event category includes events related to transactions.
TSQL event category includes events generated while executing TSQL statements.
User configurable event category includes user defined events.

Download MS SQL Server Locks Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know what are the differences between lost updates and uncommitted dependencies?What are the different types of lock modes in SQL Server 2000?