Transaction Concept

1.

A transaction is delimited by statements (or function calls) of the form __________.

   A.) Begin transaction and end transaction
   B.) Start transaction and stop transaction
   C.) Get transaction and post transaction
   D.) Read transaction and write transaction

Answer: Option 'A'

Begin transaction and end transaction

2.

Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?

   A.) Only 1
   B.) Only 2
   C.) Both 1 and 2 individually
   D.) Either 1 or 2

Answer: Option 'C'

The term transaction refers to a collection of operations that form a single logical unit of work.

3.

The property of transaction that persists all the crashes is

   A.) Isolation
   B.) Durability
   C.) Atomicity
   D.) All of the mentioned

Answer: Option 'B'

After a transaction completes successfully, the changes it has made to the database persist, even if there are system failures.

4.

Transaction processing is associated with everything below except

   A.) Producing detail summary or exception reports
   B.) Recording a business activity
   C.) Confirming a action or triggering a response
   D.) Maintaining a data

Answer: Option 'C'

Collections of operations that form a single logical unit of work are called transactions.

5.

The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.

   A.) COMMIT
   B.) SET TRANSACTION
   C.) BEGIN
   D.) BEGIN TRANSACTION

Answer: Option 'B'

Commit is used to store all the transactions.

Transaction Concept Download Pdf