What is the meaning of the following T-SQL comma

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'

"EXEC sp_dboption 'OrderDB', 'single user', 'true'" will change database "OrderDB" into single user mode, so only a single user can access it.

(Continued on next question...)

Other Job Interview Questions

• What two categories you can divide T-SQL statements into?
• What does Default Object refers to in MS SQL Server?
• What is setup.iss file used for during MS SQL Server installation?
• What is the difference between a Default Instance and a Named Instance of MS SQL Server?
• What is the T-SQL command to create a new login in MS SQL Server?
• Is MS SQL Server compliant to ANSI SQL standards?
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• Is it secure to use Windows Authentication to establish a connection to MS SQL Server?
• What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
• What are distributed queries?
• More...