Exam 312-49v10 topic 1 question 476 discussion

B. DBCC LOG(Transfers, 3) Here’s why: DBCC LOG is a command used in SQL Server to read and display the transaction log for a specified database. The command’s second parameter specifies the level of detail to be displayed. The options provided represent different levels of detail: 0: Minimal detail 1: Basic detail (log record type and details) 2: Intermediate detail (includes more columns) 3: Maximum detail (includes the most comprehensive data, including AllocUnitId, page id, slot id, and more) So, to extract detailed information including AllocUnitId, page id, slot id, etc., you should use the command with parameter 3 to get the most detailed view.

D > type - is the type of output, and includes these options: 0 - minimum information (operation, context, transaction id) 1 - more information (plus flags, tags, row length, description) 2 - very detailed information (plus object name, index name, page id, slot id) 3 - full information about each operation 4 - full information about each operation plus hexadecimal dump of the current transaction log's row.