wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

DFC20283 CHAPTER 5

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

The situation where one transaction overwrites another transaction’s update is known as:

a)

Dirty Read

b)

Lost Update

c)

Deadlock

d)

Inconsistent Retrieval

2.

A lock that allows multiple transactions to read but not update is:

a)

Exclusive Lock

b)

Binary Lock

c)

Shared Lock

d)

Update Lock

3.

A system that collects data and processes it at a later time is referred to as:

a)

Batch processing system

b)

Real-time processing system

c)

Distributed system

d)

OLTP

4.

A situation where transactions wait indefinitely for each other is called:

a)

Starvation

b)

Deadlock

c)

Blocking

d)

Rollback

5.

The ACID property that ensures data remains after commit is:

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

6.

A transaction reads data that has not yet been committed by another transaction. This represents:

a)

Lost Update

b)

Dirty Read

c)

Deadlock

d)

Consistent Read

7.

A system that allows users to perform transactions interactively and updates the database continuously represents:

a)

Batch processing system

b)

OLTP

c)

Real-time processing system

d)

File processing system

8.

A transaction follows a protocol where it acquires all locks before releasing any. This refers to:

a)

Deadlock Prevention

b)

Two-Phase Locking

c)

Granularity Control

d)

Checkpoint

9.

A system uses transaction logs to reapply committed changes after a crash. This operation is known as:

a)

Undo

b)

Backup

c)

Locking

d)

Redo

10.

A transaction reads the same data twice and gets different values due to another transaction’s update. This represents:

a)

Dirty Read

b)

Lost Update

c)

Inconsistent Retrieval

d)

Deadlock

11.

Two transactions update the same record. The final value only reflects one update while the other is lost. This scenario illustrates:

a)

Inconsistent Retrieval

b)

Lost Update

c)

Deadlock

d)

Dirty Read

12.

A transaction is updating a record while another transaction is denied access until the first finishes. This situation uses:

a)

Exclusive Lock

b)

Shared Lock

c)

Binary Lock

d)

Checkpoint

13.

A stock trading platform requires immediate processing of transactions to ensure accurate and up-to-date data at every second. This system is best categorized as:

a)

Batch processing system

b)

Data warehouse system

c)

OLTP system

d)

Real-time processing system

14.

A database ensures that once a transaction is committed, its changes will not be lost even after failure. This demonstrates:

a)

Isolation

b)

Consistency

c)

Atomicity

d)

Durability

15.

Transaction T1 holds resource A and waits for B, while T2 holds B and waits for A. The system becomes stuck. This scenario represents:

a)

Starvation

b)

Lost Update

c)

Dirty Read

d)

Deadlock