What is a transaction and what are ACID properties?
Answer Posted / 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 |
Post New Answer View All Answers
What is mssql?
How you would rewrite the sql query to return the customerid sorted numerically?
How do you improve the performance of a SQL Azure Database?
what changed between the previous version of sql server and the current version? : Sql server database administration
explain the storage models of olap? : Sql server database administration
What is the difference between DataRow.Delete() and DataRow.Remove()?
What happens if we shrink log file in sql server?
How ssrs maintain security?
Can you explain about buffer cash and log cache in sql server?
What is RAID? What are the different types of RAID configurations?
How do we Backup SQL Azure Data?
Define candidate key, alternate key, and composite key.
How can we determine what objects a user-defined function depends upon?
What are subqueries in sql server? Explain its properties.
Explain what are the restrictions that views have to follow? : SQL Server Architecture