A transaction is a sequence of operation which works as an atomic unit. A transaction only completes if all the operations completed successfully. A transaction has the Atomicity, Consistency, Isolation and Durability properties (ACID).
[A]tomic: Everything succeeds or fails as a single unit.
[C]onsistent: When the operation is complete, every thing is left in a safe state.
[I]solated: No other operation can impact me operation.
[D]urable: When the operation is completed, changes are safe
- What is DBMS?
- What is RDBMS?
- Difference between DBMS and RDBMS
- What are various DDL commands in SQL?
- What are various DML commands in SQL?
- What are various DCL commands in SQL?
- Can you sort a column using a column alias?
- Is a null value same as zero or a blank space if not then what is the difference?
- How can you eliminate duplicate rows from a query result?
- Difference between TRUNCATE, DELETE and DROP commands?
- What is the difference between CHAR and VARCHAR2 datatype in SQL?
- What are the differences between sql and pl/sql?
- What are the transaction properties in sql?
- What is the sql case statement used for?
- How many types of aggregate functions are there in sql?
- What are scalar functions in sql?
- What is the difference between sql and mysql?
- What is the use of nvl function in sql?
- What do you mean by subquery?
- What are Indexes in SQL?
- How to create index in oracle sql?
- How to view index in oracle sql?
- How to get list of tables in oracle sql
- Difference between clustered and nonclustered indexes in oracle sql?
- How to update with select subquery in sql server
- Explain different types of index in sql server