Ace Your Exams with Our Notes and Mock Tests!

EC-Council: Computer Hacking Forensic Investigator(CHFI-V10)
Module 11 : Database Forensics
Questions available : 15		You are not logged in. Please Login for track your learning progress

Q. No: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
		Go to Question No.

Question No 0

---

If you want to share the link of this question, please click here to "Copy Question Link" and share that generated link. Link from URL may change in future.

 

---

Bookmark this Question		QID: 475
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, 2)
B:    DBCC LOG(Transfers, 0)
C:    DBCC LOG(Transfers, 1)
D:    DBCC LOG(Transfers, 3)
Explanation: Syntax: DBCC LOG(<databasename >, <output >) The output parameter specifies the level of information that a forensic examiner wants to retrieve 0= minimal information of each operation such as the Current LSN, Operation, Transaction ID, etc. 1 = slightly more info than 0, such as Flag Bits, and Previous LSN 2 = detailed information, including (AllocUnitId, 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