What is a transaction and what are ACID properties?
Answer Posted / kumar
a transaction is a set of operations perfomed on a database.
After a transaction is done it is commited.
Is This Answer Correct ? | 10 Yes | 8 No |
Post New Answer View All Answers
How to define output parameters in stored procedures?
How are the unique and primary key constraints different?
What is set nocount on and what is set nocount off?
Suggest a method of joining two tables.
Explain concepts of analysis services?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How to create a trigger for insert only?
Explain triggers?
mention different types of relationships in the dbms?
If no size is defined while creating the database, what size will the database have?
Tell me when is the update_statistics command used?
What are the differences between web role and worker role?
What happens when unicode strings concatenate with non-unicode strings?
How you can move data or databases between servers and databases in sql server?
Differentiate sql server reporting services vs. Crystal reports?