What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. CK_DB contains a table named CK_Prod
where the Sales Product resides. You have received instruction to move CK_Prod’ test to a new
schema named CK_Tester. You need to complete this task using the appropriate Transact-SQL statement.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. CK_DB contains a table named CK_Prod
where the Sales Product resides. You have received instruction to move CK_Prod’ test to a new
schema named CK_Tester. You need to complete this task using the appropriate Transact-SQL statement.

What should you do?

A.
You should consider adding the following:
ALTER TABLE Products. Test SWITCH TO CK_Tester.Table1;

B.
You should consider adding the following:
ALTER AUTHORIZATION ON Products. Test TO CK_Tester;

C.
You should consider adding the following:
ALTER USER Products WITH DEFAULT_SCHEMA = CK_Tester;

D.
You should consider adding the following:
ALTER SCHEMA CK_Tester TRANSFER Products. Test.



Leave a Reply 0

Your email address will not be published. Required fields are marked *