What is a transaction and what are ACID properties?

Answer Posted / piyush

transaction is a set of operation or activities which are
executed in a logical unit of work which is know as transaction.

ACID
A-Atomicity
C-Consistency
I-Isolation
D-Durability

Is This Answer Correct ?    28 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the truncate command? : SQL Server Architecture

567


Do you know concepts and capabilities of sql server?

584


What is normalization and denormalization in sql server?

539


What is stretch database in sql server?

570


What is meant by indexing files?

583






List out some of the requirements to set up a sql server failover cluster?

547


How to return the second 5 rows in ms sql server?

634


How does using a separate hard drive for several database objects improves performance right away?

530


How to create new table with "create table" statements?

562


When would you use sql joins?

527


What is role playing dimension with two examples? : sql server analysis services, ssas

597


How to change a login name in ms sql server?

564


how many triggers you can have on a table? : Sql server database administration

499


What are advantages of ssrs or why we should use ssrs?

104


explain the storage models of olap? : Sql server database administration

524