（15 ) SQL Server 2000 使用【15】语言来定义和操作数据，它是对标准SQL-92 语言的功能扩充。

A.’October 15,2013’

B.’10/15/2013’

C.’2013-10-15’

D.’2013:10:15’

在SQL Server 2000中，有教师表(教师号，姓名，职称，工资)。现要根据教师的职称来添加教师的工资，增加规则为：“教授”增加400，“副教授”增加300，“讲师”增加200。下列语句中正确的是______。

A)UPDATE教师表SET工资=工资+CASE职称

WHEN‘教授’THEN 400

WHEN‘副教授’THEN 300

WHEN‘讲师’THEN 200

END

B)UPDATE教师表SET工资=工资+CASE职称

WHEN职称=‘教授’THEN 400

WHEN职称=‘副教授’THEN 300

WHEN职称=‘讲师’THEN 200

END

C)UPDATE教师表SET工资=CASE职称

WHEN‘教授’THEN工资=工资+400

WHEN‘副教授’THEN工资=工资+300

WHEN‘讲师’THEN工资=工资+200

END

D)UPDATE教师表SET工资=工资+CASE职称

WHEN职称=‘教授’THEN工资=工资+400

WHEN职称=‘副教授’THEN工资=工资+300

WHEN职称=‘讲师’THEN工资=工资+200

END

at stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur.

-- 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.

A.SQL Server Profiler

B.SQL Server Management Studio

C.SQL Server配置管理器

D.SQL Server外围应用配置器

A.数据库引擎服务

B.SQL Server Management Studio

C.SQL Server配置管理器

D.SQL Server 管理工具