Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is a NOLOCK?

Answer Posted / guest

Do not issue shared locks and do not honor exclusive locks.
When this option is in effect, it is possible to read an
uncommitted transaction or a set of pages that are rolled
back in the middle of a read. Dirty reads are possible. Only
applies to the SELECT statement.

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default Port No on which SQL Server listens?

1071


Define full outer join in sql server joins?

916


Can sql server be linked with other servers like oracle?

906


What are the steps to follow to configure SQL*Net?

995


Which autogrowth database setting is good?

1006


What is difference between clustered index and non clustered index?

1030


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1891


What are recommended options to be used while using db mirroring? : sql server database administration

1072


What is cursor in ms sql server?

1092


What is truncate table?

892


Explain security with sql azure?

186


How to backup SQL Server Reporting Services ?

137


What is the difference between a function and a stored procedure?

1007


What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

965


How to choose all records from the table?

1000