Topic 5: Database Transaction Management

Based on the Figure A10, select the CORRECT properties of database transaction.

• Atomicity

• Durability

• Isolation

• Consistency

Based on Figure A11, select the CORRECT properties of database transaction.

• Atomicity

• Durability

• Isolation

• Consistency

The statement below is refer to _____________.

"All details of the transaction are recorded and changed at the time as it occurs."

• Batch Transaction

• Online Transaction

• Real - Time Transaction

• Offline Transaction

The statement below is refer to _____________.

"Information is collected and stored as a batch but not processed immediately."

• Batch Transaction

• Online Transaction

• Offline Transaction

• Real-Time Transaction

Choose the suitable answer to refer to the statement below:

"This property ensures that the data used during the execution of transaction cannot used by a second transaction until the first one is completed.

• Atomicity

• Isolation

• Durability

• Consistency

Choose the suitable answer to refer to the statement below:

"This property indicates the permanence of the database's consistent state."

• Consistency

• Atomicity

• Isolation

• Durability

Below are the problems of concurrency control EXCEPT

• Lost update

• Committed data

• Uncommitted data

• Inconsistent retrieval

Below are the list of database recovery management EXCEPT ....

• Database recovery

• Transaction recovery

• Database back-up

• Transaction back-up

Select a transaction SQL statement that enable to permanently recorded all the changes within the database.

• COMMIT

• SET TRANSACTION

• ROLLBACK

• SET

Select a transaction SQL statement that enable to declare the start of new transaction and its properties.

• COMMIT

• SET TRANSACTION

• ROLLBACK

• SET