What is a transaction and what are ACID properties?
Answers were Sorted based on User's Feedback
Answer / srivas
A transaction is a logical unit of work in which, all the
steps must be performed or none. ACID stands for Atomicity,
Consistency, Isolation, Durability. These are the properties
of a transaction.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / mobin sathupally
A transaction is a logical unit of work in which, all the
steps must be performed or none.A transaction follows four
properties(rules).These four properties are known as ACID.
ACID stands for Automocity,Consistency,Isolation and
Durability.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rahul
transaction is only the reading or writing or both reading
and writing in a database. when we are reading from a
database that is transaction where the database is not
changing. in writing into database the database values can
be changed. we can do both reading and writing in a database.
to do these operations the database must have the acid
properties.
Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of MOVE keyword in restore command
What is difference between TRUNCATE and DELETE statement
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?
What is simple indexing method?
What is the security principal at the database level that represents your session?
What is a unique key constraint?
What is filter index?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Explain what is row_number function?
What is function of CUBE ?
What are the methods used to protect against sql injection attack?
What is standby servers? Explain types of standby servers.