|
Каков правильный ответ на вопрос теста 70-229
|
|||
---|---|---|---|
#18+
Каков правильный ответ на вопрос: You have developed a new database for your development group to use when testing their new application. When the database was first passed to them, neither you nor they were concerned with data recovery. As a result, the database initially carried a log file of only 5MB (with autogrow, but no autoshrink) and had its truncate log on checkpoint option set on. Midway through their tests, however, one of the developers turned the option off, and consequently the log automatically grew to its current size of 150MB. Concerned about the low amount of free space remaining on the disk drive holding the log, you turn the option on once again. What configuration would you expect after the next checkpoint has passed? A . SQL Server will never truncate this particular log B . The log would have been truncated, but the log allocation remains at 150MB. C . The log would have been truncated, and the log allocation returns to 5MB D . The log would have been truncated, and the log allocation would shrink somewhat, but not back to 5MB. Мой ответ D. ... |
|||
:
Нравится:
Не нравится:
|
|||
03.12.2003, 18:13 |
|
Каков правильный ответ на вопрос теста 70-229
|
|||
---|---|---|---|
#18+
B Файл лога сам по себе не уменьшится. Просто он будет почти пустым. ... |
|||
:
Нравится:
Не нравится:
|
|||
03.12.2003, 20:00 |
|
Каков правильный ответ на вопрос теста 70-229
|
|||
---|---|---|---|
#18+
OFFTOPIC: 70-229 - это же по SQL Server 2000. Тогда какая такая 'truncate log on checkpoint'? Удачи ... |
|||
:
Нравится:
Не нравится:
|
|||
03.12.2003, 20:34 |
|
Каков правильный ответ на вопрос теста 70-229
|
|||
---|---|---|---|
#18+
2 jimmers: Я тоже обратил внимание. Видимо, вопрос из не очень "свежего" тренировочного теста. Хотя от изменения 'truncate log on checkpoint' на 'Recovery Model: Simple' смысл-то не меняется :) ... |
|||
:
Нравится:
Не нравится:
|
|||
04.12.2003, 15:36 |
|
|
start [/forum/topic.php?fid=34&fpage=61&tid=1552030]: |
0ms |
get settings: |
10ms |
get forum list: |
15ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
29ms |
get topic data: |
11ms |
get forum data: |
3ms |
get page messages: |
41ms |
get tp. blocked users: |
1ms |
others: | 231ms |
total: | 349ms |
0 / 0 |