Explanation:The DBCC DBREINDEX statement is deprecated so you should avoid using it in new applications. 8. Which of the following checkpoint has ‘recovery interval’ less tha zero ?
A. Automatic
B. Direct
C. Indirect
D. All of the mentioned
Answer:A
Explanation:The DBCC DBREINDEX statement is deprecated so you should avoid using it in new applications. 8. Which of the following checkpoint has ‘recovery interval’ less tha zero ?
A. Automatic B. Direct C. Indirect D. All of the mentioned
Explanation:Automatic checkpoints whose target recovery interval is specified by the user defined setting of the sp_configure recovery interval option. 9. Internal checkpoint are generated in response to the following event :