Avatar of Mike Eghtebas
Mike Eghtebas
Flag for United States of America asked on

Move the Employees table from the dbo schema to the HumanRwsources schema.

Task: Move the Employees table from the dbo schema to the HumanRwsources schema.
Solution I have: ALTER TABLE dbo.Employees ALTER SCHEMA HumanResources

The following 2 options are not correct:
1:
ALTER TABLE dbo.Employees TRANSFER HumanResources
Explanation why this option is not correct: " should not use ALTER TABLE. It only allows the structure of the table not the schema that contains the table."
Question A: Why we cannot use ALTER TABLE here but it is okay to use it in the first answer (correct on above)?

2:
ALTER SCHEMA HumanResources TRANSFER dbo.Employees
Question B: Why this answer is not correct? What the following code does anyway?
Microsoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Jim Horn

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jim Horn

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Mike Eghtebas

ASKER
No. it is for 2012. I think 2008 is no longer offered.

On the error message, I am not actually running the code. This is a sample exam question I am investigating.
Jim Horn

Kinda hard to verify that an answer is correct if you're not coding it, and I highly recommend practicing these in SSMS instead of just trying to memorize answers, so I'll stick to my guns and say 2 is correct.
Mike Eghtebas

ASKER
With SQL Servers prior to 2012, I guess we had separate certifications for developers and db administrators. But now, with SQL Server 2012 there is just MCSA (db administrators). MCSA for 2012 includes three certifications listed below:

70-461: Querying Microsoft SQL Server 2012
70-462: Administering Microsoft SQL Server 2012 Databases
70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

I am studying for 70-461 now. And, this question is sore of out of place I thing and it belongs to 70-462.  So, when I study later 70-462, I will focus on these type of questions.

BTW, how do you rate these 3 sections in scale of 1-10 as far as difficulty is concerned for a starter?

Thanks,

Mike
Your help has saved me hundreds of hours of internet surfing.
fblack61
Jim Horn

70-461 was pretty easy for me, as I've been doing T-SQL for sevenish years now, and the 2012 exam was the first one I've taken that wasn't heavily weighted towards what was new in that version.

70-462 I haven't looked at yet.

70-463 I studied a little and took a practice exam.  The SSIS and data warehousing parts were fine except when they asked about seldom-used components and script source/destination.  The MDM and DQS I bombed as I didn't have previous experience in them.
Jim Horn

Thanks for the grade.  Good luck with your project.  -Jim