Answer Posted / s.vanitha
Pessimistic concurrency control
Optimistic concurrency control
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Name three of the features managed by the surface area configuration tool? : sql server security
What is compression - row-level and page-level compression?
can an order by clause be used in a creation of a view?
Explain partitioned view?
What is replace and stuff function in sql server?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
How to generate create view script on an existing view?
Explain the categories of stored procedure?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
How important do you consider cursors or while loops for a transactional database?
How to provide default values to function parameters?
How to encrypt Strored Procedure in SQL SERVER?
What do you understand by a view? What does the with check option clause for a view do?
List out the differences between the clustered index and non-clustered index in sql server?
What is truncate table?
