nerdexam
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)
  • A
    9% (2)
  • B
    17% (4)
  • C
    4% (1)
  • D
    70% (16)

Community Discussion

No community discussion yet for this question.

Full 312-49V9 Practice