Exam 312-49 topic 1 question 476 discussion

Actual exam question from ECCouncil's 312-49

Question #: 476
Topic #: 1

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?

A. DBCC LOG(Transfers, 1)
B. DBCC LOG(Transfers, 3)
C. DBCC LOG(Transfers, 0)
D. DBCC LOG(Transfers, 2)

Show Suggested Answer

Suggested Answer: D 🗳️

by Chiuhua at March 11, 2021, 1:25 p.m.

Comments

Submit Cancel

Spudmac

8 months, 1 week ago

I'm looking at the book right now: 0= minimal information such as the Current LSN, Operation, Transaction ID, etc, 1= slightly more info than 0 such as Flag Bits, and Previous LSN, 2= detailed info, including (AllocUnitld, page id, slot id, etc), 3=full information about each operation, 4= full information on each operation along with the hex dump of the current transaction row

upvoted 1 times

...

Chiuhua

1 year, 3 months ago

Examine active transaction log ,I think it's dbcc log(db_name,3)

upvoted 2 times

...