Subscribe to Subscribers
Posted Date: 23 May 2012      Posted By:: Prachi Kulkarni    Member Level: Gold    Points: 2
Category: SQL Server

Which lock in SQL server allows transactions to read data with SELECT statements?



Select Answer:

Intent Lock
Update Lock
Exclusive Lock
Shared Lock
Schema Lock

             Your Test Score: 0 / 0

Next Question: Which type of SQL Server recovery model are all database changes logged except those that cause large log entries
Previous Question: Which syntax is correct to create view?
Related Questions:
  • Which Statement will create a nonclustered composite index on the CourseName and StudentId Columns?


  • Which of the following can you run to check that the automatic statistics update is set?


  • Which of the following Attribute is not used to build up a SQL Connection?


  • Which of the following indicates the wildcard character in SQL?


  • Which of the following Transaction properties comprises the ACID Test?





  • Categories

    .NET Framework ASP.NET C# 
    Java Other SQL Server 
    VB.NET 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    Active Members
    TodayLast 7 Daysmore...

    Awards & Gifts
    Talk to Webmaster Tony John
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India
    2005 - 2013 All Rights Reserved.
    .NET and other trademarks mentioned in this site belong to Microsoft and other respective trademark owners.
    Articles, tutorials and all other content offered here is for educational purpose only.
    We are not associated with Microsoft or its partners.