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: 523
Which of the following SQL Query can a forensic investigator use to retrieve the active Transaction Log files for a specific database?
A:    DBCC DBTABLE
B:    DBCC DBLOG
C:    DBCC DBINFO
D:    DBCC LOG
Explanation: The DBCC LOG command allows us to retrieve the active transaction log files for the specified database 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