Search Header Logo

DFC20283 CHAPTER 5

Authored by NUR (PBU)

Information Technology (IT)

University

Used 5+ times

DFC20283 CHAPTER 5
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Dirty Read

Lost Update

Deadlock

Inconsistent Retrieval

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Exclusive Lock

Binary Lock

Shared Lock

Update Lock

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Batch processing system

Real-time processing system

Distributed system

OLTP

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Starvation

Deadlock

Blocking

Rollback

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The ACID property that ensures data remains after commit is:

Atomicity

Consistency

Isolation

Durability

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Lost Update

Dirty Read

Deadlock

Consistent Read

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Batch processing system

OLTP

Real-time processing system

File processing system

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

Already have an account?