EC-Council
312-49V9 · 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). See the full explanation below for the reasoning.
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
(23 responses)- A9% (2)
- B17% (4)
- C4% (1)
- D70% (16)
Community Discussion
No community discussion yet for this question.