Post reply

07/29/2003 Question AN Error

  • August 29, 2003 at 7:24 am

    #151917

    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

    #471983

    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

    #471993

    viplove

    Are you running SQL Server 7.0?

  • August 29, 2003 at 8:25 am

    #471994

    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