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 command would you use to create an index?
What's new in sql management studio for sql server? : sql server management studio
How to delete multiple rows with one delete statement in ms sql server?
What is similarity and difference between truncate and delete in sql?
Tell me about pre-defined functions of sql?
What is buffer cash and log cache in sql server?
Is it ok to shrink transaction log?
Can you force a query to use a specific index?
What is a raid and what are different types of raid configurations?
How to change the data type of an existing column with "alter table" statements in ms sql server?
How to maintain a fill factor in existing indexes?
What is de-normalization and what are some of the examples of it?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture