Answer Posted / hari
Isolaton is the reduce the concurrency
Default 1)Read Commit
2)Read Uncommit
3)Repatable read
4) Serizable--
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is change tracking in sql server?
Explain what is row_number function?
What is the difference between commit and rollback?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is mssql?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Tell me what is log shipping?
Differentiate sql server reporting services vs. Crystal reports?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What's the information that can be stored inside a bit column?
How to store and query spatial data?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How to add additional conditions in SQL?
Define union, union all, minus, intersect?