-Normalization is set of rules that are to be applied while designing the database tables which are to be connected with each other by relationships. This set of rules is called Normalization.
-Benefits of normalizing the database are
1. No need to restructure existing tables for new data.
2. Reducing repetitive entries.
3. Reducing required storage space
4. Increased speed and flexibility of queries.
Do you know what are the differences between lost updates and uncommitted dependencies?
Explain what are the events recorded in a transaction log?
What are the different types of lock modes in SQL Server 2000?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Explain optimistic and pessimistic concurrency?
Explain the various types of concurrency problem?
Explain different types of lock modes in SQL Server 2000?
Do you know what guidelines should be followed to help minimize deadlocks?
What is a dead lock?
What is a live lock?
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
