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 are different types of join?
What are window functions in sql server?
What is the use of “join” in sql server?
What is merge?
How do you identify a foreign key?
What is the new security features added in sql server 2014? : sql server security
What is mssql?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is normalization process?
What is the default value of an integer data type in sql server 2005?
Difference between report and query parameter.
What do you understand by a view?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Does hive support indexing?
What is master database? : SQL Server Architecture