Three types of locks
READ ONLY: This prevents any updates on the table.
SCROLL LOCK: This allows you to make changes to the table.
OPTIMISTIC: This checks if any change in the table record since the row fetched before updating.
If there is no change, the cursor can update
What is the difference between DELETE TABLE and TRUNCATE TABLE commands?
What is a major difference between SQL Server 6.5 and 7.0 platform wise?
What is new philosophy for database devises for SQL Server 7.0?
What is a traditional Network Library for SQL Servers?
If you encounter this kind of an error message, what you need to look into to solve this problem?
What's the difference between a primary key and a unique key?
What are cursors? Explain different types of cursors? What are the disadvantages of cursors? How to avoid cursors?
What is the system function to get current user's user id?
What is a join and explain different types of joins?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
