Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 77324 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / kumar
The ACID model is one of the oldest and most important
concepts of database theory. It sets forward four goals
that every database management system must strive to
achieve: atomicity, consistency, isolation and durability.
No database that fails to meet any of these four goals can
be considered reliable.
•Atomicity states that database modifications must follow
an “all or nothing” rule. Each transaction is said to
be “atomic.” If one part of the transaction fails, the
entire transaction fails. It is critical that the database
management system maintain the atomic nature of
transactions in spite of any DBMS, operating system or
hardware failure.
•Consistency states that only valid data will be written to
the database. If, for some reason, a transaction is
executed that violates the database’s consistency rules,
the entire transaction will be rolled back and the database
will be restored to a state consistent with those rules. On
the other hand, if a transaction successfully executes, it
will take the database from one state that is consistent
with the rules to another state that is also consistent
with the rules.
•Isolation requires that multiple transactions occurring at
the same time not impact each other’s execution.
.Durability ensures that any transaction committed to the
database will not be lost. Durability is ensured through
the use of database backups and transaction logs that
facilitate the restoration of committed transactions in
spite of any subsequent software or hardware failures
| Is This Answer Correct ? | 20 Yes | 7 No |
Post New Answer View All Answers
How to count groups returned with the group by clause in ms sql server?
How to provide column names in insert statements in ms sql server?
Explain what is analysis service repository?
What types of replication are supported in sql server?
What program is used to store the data source file?
Mention the differences between local and global temporary tables.
Tell me about the approaches which you used to counter the DI problems.
How to list all columns in a table using odbc_columns()?
What is table level trigger?
What guidelines should be followed to help minimize deadlocks?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What are the commands used in DCL?
What are the properties of the relational tables?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Explain tables in SQL Azure?
