Explanation:Minimal logging involves logging only the information that is required to recover the transaction without supporting point-in-time recovery. 7. Index page deallocation during a ________ operation is always fully logged.
A. DROP INDEX
B. CREATE INDEX
C. ALTER INDEX
D. None of the mentioned
Answer:A
Explanation:Minimal logging involves logging only the information that is required to recover the transaction without supporting point-in-time recovery. 7. Index page deallocation during a ________ operation is always fully logged.
A. DROP INDEX B. CREATE INDEX C. ALTER INDEX D. None of the mentioned
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 ?