Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 3 Answers
- 7748 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Distinguish between commit and rollback?
what is isolation level at dead lock?
Why do you need a sql server?
List the different types of joins?
What is updatable resultset?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Is it possible for a stored procedure to call itself or recursive stored procedure?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Explain what are magic tables in sql server?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Do you have any idea about the tcl commands?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Explain what is scheduled job and how to create it?
