DBMA QUIZ 3 - UNIT 4 & 5

An operation is part of a transaction if it is ___ related.

• 1. Logically

• 1. Analytically

• 1. Reasonably

• 1. None

To access the contents of the database, ___ user performs transactions.

• 1. Single

• 1. Two

• Three

• Multiple

Which of the following is an operation of transactions?

• Read

• Write

• Commit

• all the above

X is read from a database and stored in a buffer in main memory with the ___ operation.

• Read

• Write

• Commit

• Rollback

Writing the data from the buffer back to the database is accomplished by using the _____ operation.

• Read

• Write

• Commit

• Rollback

___ is used to permanently save the work.

• Read

• Write

• Commit

• Rollback

In a database, prior to and after a transaction, properties are used to ensure ___.

• 1. Consistency

• 1. Redundancy

• 1. Latency

• 1. Anonymity

Which of the following is a property of transaction?

• 1. Atomicity

• 1. Consistency

• 1. Durability

• 1. All of the above

A management procedure called ___ control is required to control the process of concurrently performing operations on a database.

• 1. Database

• 1. Conspiracy

• 1. Concurrency

• 1. Relational

The concurrent execution of the database in a ____-user system refers to the fact that multiple users are able to access and use it at the same time.

• Single

• Two

• Three

• Multiple