SqlMel (10/31/2013)
I find this one to be a very good question but one that can be easily answered by just analyzing the available options.First, you need to select 4 correct answers but there are three (The last ones) that are mutually exclusive. That means that the first three are true.
Given that, if you know for a fact that the user has permissions to the db_owner role, than you should know that he will have enough privileges to create a table in the database.
I'm surprised the percentage of correct answers are so low.
I just over-thought this one. Maybe others have too. Plus, there was the pressure of it being worth THREE points. 😉
BTW, I was surprised Steve didn't slip in a humorous Halloween question. I look forward to those holiday questions.
If you celebrate such things, Happy Halloween! Hope you get lots of >(///)<
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn