問題文
An administrator is annotating a maintenance plan that mentions both an integrity check and a shrink step. Which of the four is right on both halves?
選択肢
- What is enough to deal with indexes that have become fragmented is rebuilding or reorganizing them where they are, what may be needed to put right some of the problems that an integrity check turns up is overwriting the database from an earlier backup, what happens to the space that such a shrink releases is it is taken up again as the database grows back, and what a shrink of the database or of its files typically brings about is a loss of performance and a great deal of fragmentation.
- What is enough to deal with indexes that have become fragmented is overwriting the database from an earlier backup, what may be needed to put right some of the problems that an integrity check turns up is rebuilding or reorganizing them where they are, what happens to the space that such a shrink releases is it is taken up again as the database grows back, and what a shrink of the database or of its files typically brings about is a loss of performance and a great deal of fragmentation.
- What is enough to deal with indexes that have become fragmented is overwriting the database from an earlier backup, what may be needed to put right some of the problems that an integrity check turns up is rebuilding or reorganizing them where they are, what happens to the space that such a shrink releases is a loss of performance and a great deal of fragmentation, and what a shrink of the database or of its files typically brings about is it is taken up again as the database grows back.
- What is enough to deal with indexes that have become fragmented is rebuilding or reorganizing them where they are, what may be needed to put right some of the problems that an integrity check turns up is overwriting the database from an earlier backup, what happens to the space that such a shrink releases is a loss of performance and a great deal of fragmentation, and what a shrink of the database or of its files typically brings about is it is taken up again as the database grows back.