All Oracle transactions obey the basic properties of a database transaction.…

Solution

Answer: Option 1

Concept:

ACID Properties:

A transaction in a database system must maintain Atomicity, Consistency, Isolation, and Durability − commonly known as ACID properties − in order to ensure accuracy, completeness, and data integrity.

Atomicity − This property states that a transaction must be treated as an atomic unit, that is, either all its operations are executed or none.There are no partial transactions

Consistency − The database must remain in a consistent state after any transaction. No transaction should have any adverse effect on the data residing in the database.

Isolation − In a database system where more than one transaction is being executed simultaneously and in parallel, the property of isolation states that all the transactions will be carried out and executed as if it is the only transaction in the system.

Durability − The database should be durable enough to hold all its latest updates even if the system fails or restarts.