It is the process of organizing data into related table.
To normalize database, we divide database into tables and establish relationships between the tables.
It reduces redundancy. It is done to improve performance of query.
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What type of Index will get created after executing the above statement?
What is a transaction and what are ACID properties?
What is normalization? Explain different levels of normalization?
What is the system function to get the current user's user id?
Can we have a nested transaction?
What is the difference in Login Security Modes between v6.5 and 7.0?
What is lock escalation?
What is the maximum size of a row?
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
