which one will take 1st priority in case of insert statement
and select statement???
Answer Posted / sandeep
I think that depends on locking system we choose. if we
implement high data availability then select statement will
wait for the completeion of insert or update statement. I
dont remember those locking systems rite now.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain what are the basic functions for master, msdb, model, tempdb databases?
What does dml stand for?
What does the update command do?
What are the differences between local and global temporary tables?
What is a scheduled job or what is a scheduled task?
What is Sqlpaging in SqlServer 2005 ?
Why does sql studio use a single registered database repository? : sql server management studio
Explain the creation and execution of a user-defined function in the sql server?
What are commonly used odbc functions in php?
What is mean by candidate key?
explain different types of joins? : Sql server database administration
What are examples of triggers?
What is the index requirement in SQL Azure?
What are the drawbacks of reporting in ssrs?
List out some of the requirements to set up a sql server failover cluster?