Exam 70-433 : SQL Server 2008 Part – 3

Question: Which of the following commands is used to retrieve information about the information contained in the current transaction log ?

  1. DBCC LOGGING statement
  2. DBC LOG statement
  3. DBCC LOG statement
  4. None of the above.

Correct Answer: 1

Question: Which of the following options can be used for viewing lock status within your computer running SQL Server?

  1. We can use SQL Profiler to capture lock and blocking information.
  2. We can use the System Monitor that is part of the performance console to capture statistics on lock wait times, locks per second, and so on.
  3. We can use the Activity Monitor in SSMS to see information on blocking processes.
  4. We can use the sys.dm_tran_locks dynamic management view to gather information on locks being held by transactions.
  5. All of the above.

Correct Answer: 5

Question: To see the number of open transactions in the current session, ______ global variable is used.

  1. @@trancount
  2. @trancount
  3. @@transactioncount
  4. None of the above

Correct Answer: 1

Question: Assuming the following query is executed on 31st Dec 2011. What is the result of the below query.

  1. 11/12/31
  2. 31/12/11
  3. 31/12/2011
  4. 2011/12/31

Correct Answer: 4

Question: What is the result of the below query: SELECT PATINDEX(‘DOT%’, ‘DOTNET’) AS ‘Index’

  1. 1
  2. 0
  3. -1
  4. 2

Correct Answer: 1

Tagged . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.