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
What is the default Port No on which SQL Server listens?
Define full outer join in sql server joins?
Can sql server be linked with other servers like oracle?
What are the steps to follow to configure SQL*Net?
Which autogrowth database setting is good?
What is difference between clustered index and non clustered index?
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
What are recommended options to be used while using db mirroring? : sql server database administration
What is cursor in ms sql server?
What is truncate table?
Explain security with sql azure?
How to backup SQL Server Reporting Services ?
What is the difference between a function and a stored procedure?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
How to choose all records from the table?