Microsoft
70-450 · Question #119
You are the administrator of a SQL Server 2008 instance with a database named DB1. In the Services schema there is a table named Service.Table. The Services.Table has to be moved from the Sales…
The correct answer is B. ALTER SCHEMA Costs TRANSFER Service.Table. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. 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. Which Transact-SQL statement should you execute?
Options
- AALTER TABLE Service.Table SWITCH TO Costs.Table1;
- BALTER SCHEMA Costs TRANSFER Service.Table;
- CALTER USER Service WITH DEFAULT_SCHEMA = Costs;
- DALTER AUTHORIZATION ON Service.Table1 TO Costs;
How the community answered
(38 responses)- A13% (5)
- B79% (30)
- C3% (1)
- D5% (2)
Community Discussion
No community discussion yet for this question.