多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the Services schema, There is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs. In the options below, which Transact-SQL statement should you execute?()

  • A、ALTER TABLE Service.Table SWITCH TO Costs.Table1; 
  • B、ALTER SCHEMA CostsTRANSFER Service.Table; 
  • C、ALTER USER Service WITH DEFAULT_SCHEMA = Costs; 
  • D、ALTER AUTHORIZATION ON Service.Table1 TO Costs;
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题