Identify three key properties of a transaction in Oracle Database 12c.

The correct answer is A. durability B. consistency D. isolation. All Oracle transactions obey the basic properties of a database transaction, known as ACID properties. ACID is an acronym for the following: - Atomicity-All tasks of a transaction are performed or none of them are. There are no partial - Consistency-The transaction takes the…

Oracle Database 12c Architecture

Question

Options

Adurability
Bconsistency
Cconcurrency
Disolation
Escalability
Fmanageability

How the community answered

(58 responses)

A
81% (47)
C
10% (6)
E
5% (3)
F
3% (2)

Explanation

All Oracle transactions obey the basic properties of a database transaction, known as ACID properties. ACID is an acronym for the following: - Atomicity-All tasks of a transaction are performed or none of them are. There are no partial - Consistency-The transaction takes the database from one consistent state to another consistent - Isolation - The effect of a transaction is not visible to other transactions until the transaction is - Durability-Changes made by committed transactions are permanent. After a transaction completes, the database ensures through its recovery mechanisms that changes from the transaction are not lost.

Topics

#ACID properties#transaction#durability#isolation

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice