312-49 · Question #645
As a part of the investigation, Caroline, a forensic expert, was assigned the task to examine the transaction logs pertaining to a database named Transfers. She used SQL Server Management Studio to…
The correct answer is D. DBCC LOG(Transfers, 2). The DBCC LOG command in SQL Server accepts a second parameter that controls the verbosity of output. The options are: 0 = minimum information (operation, context, transaction ID); 1 = adds flags, tags, and row length; 2 = very detailed, including AllocUnitId, page ID, slot ID…
Question
As a part of the investigation, Caroline, a forensic expert, was assigned the task to examine the transaction logs pertaining to a database named Transfers. She used SQL Server Management Studio to collect the active transaction log files of the database. Caroline wants to extract detailed information on the logs, including AllocUnitId, page id, slot id, etc. Which of the following commands does she need to execute in order to extract the desired information?
Options
- ADBCC LOG(Transfers, 1)
- BDBCC LOG(Transfers, 3)
- CDBCC LOG(Transfers, 0)
- DDBCC LOG(Transfers, 2)
How the community answered
(51 responses)- A4% (2)
- B2% (1)
- C8% (4)
- D86% (44)
Explanation
The DBCC LOG command in SQL Server accepts a second parameter that controls the verbosity of output. The options are: 0 = minimum information (operation, context, transaction ID); 1 = adds flags, tags, and row length; 2 = very detailed, including AllocUnitId, page ID, slot ID, and object/index names; 3 = full information per operation; 4 = full information plus hex dump. Since Caroline needs detailed fields like AllocUnitId, page id, and slot id, she must use DBCC LOG(Transfers, 2), making option D correct.
Topics
Community Discussion
No community discussion yet for this question.