August 29, 2003 at 7:24 am
Hello,
I took the question from 07/29
"ALTER DATABASE Northwind
SET SINGLE_USER
WITH ROLLBACK AFTER 30 SECONDS
"
and pasted it in the Query Analyzer and I got following message
"Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'SET'."
BUT YOU ANSWER WAS
"The Northwind database will be placed in single user mode and everyone will be disconnected after 30 seconds of executing the above query "
THIS IS WRONG........ PLEASE CHECK
August 29, 2003 at 7:35 am
The problem I have with this answer is that it says "everyone" will be disconnected. Tha is not true. The issuer of the command is still connected. Therefore "everyone" is not disconnected that is why I chose answer (1) DB will be placed in single user mode after 30 seconds. Users are still able to execute queries for the next 30 seconds.
Brian
August 29, 2003 at 8:17 am
viplove
Are you running SQL Server 7.0?
August 29, 2003 at 8:25 am
I also agree that the answers to this question are poorly worded. The issuer of the command is not disconnected, therefore "everyone" is not disconnected. Answer (2) is incorrect - the correct answer is (1). In the future, you may want to avoid this kind of "back-firing trick question".
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply