If you run this, what does it return? select app

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

(Continued from previous question...)

If you run this, what does it return? select applock_mode('public', 'SalesApp', 'Transaction')

Answer
The type of lock being held by an application that requested it.
Explanation
This command returns the lock mode held by an application that was requested with the sp_getapplock procedure.

(Continued on next question...)

Other Job Interview Questions

• How many rows are returned by these two select statements?
• Which of the following is not available to you?
• You are using SQL Server 2005 and you wish to find a number of details about stored procedures created...
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• What is the timestamp datatype used for?
• Which framework would you use to manage this database programatically?
• What is the default type of XML data if you do not specify an arguement?
• Can you give me an overview of some of the database objects available for use in SQL Server 2000?
• If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?
• What is a performance consideration of having too many indexes on a production online transaction processing (OLTP) table?
• More...