-- A BULK INSERT job imports data at 10:00 P.M.
-- Indexes are rebuilt at 10:15 P.M.
-- Data integrity checks are performed at 10:30 P.M.
-- A differential backup is performed at 10:45 P.M.
-- A DBCC SHRINKDATABASE job runs at 11:00 P.M.
You notice that the final job often fails and returns the following error message: "Server Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."
You need to ensure that the final job runs without errors. What should you do?
A.Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to run at the same time as the DBCC SHRINKDATABASE job.
B.Modify the DBCC SHRINKDATABASE job so that it uses DBCC SHRINKFILE statement to shrink each file individually.
C.Increase the time between the data integrity checks and the differential backup.
D.Increase the time between the differential backup and the DBCC SHRINKDATABASE job.
第6题
病人钱某,主诉排便后有鲜血滴出,护士正确的评估是
A.下消化道出血
B.肠息肉
C.痔疮出血
D.直肠癌
E.痢疾
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!