Explanation:Log truncation frees space in the log file for reuse by the transaction log. 3. Which of the log_reuse_wait_desc value has log_reuse_wait value 0 ?
A. CHECKPOINT
B. ACTIVE_TRANSACTION
C. NOTHING
D. All of the mentioned
Answer:A
Explanation:Log truncation frees space in the log file for reuse by the transaction log. 3. Which of the log_reuse_wait_desc value has log_reuse_wait value 0 ?
A. CHECKPOINT B. ACTIVE_TRANSACTION C. NOTHING D. All of the mentioned
Explanation:log_reuse_wait value 0 indicates currently there are one or more reusable virtual log files. 4. ACTIVE_TRANSACTION has log_reuse_wait value :