Search Header Logo

Information Management Prefinal Exam

Authored by Cecilio Salonoy

Information Technology (IT)

Professional Development

Used 2+ times

Information Management Prefinal Exam
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is a transaction in a DBMS?

A set of SQL commands

A logical group of database operations

A database schema

A file stored in the database

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which ACID property ensures that a transaction's changes are permanent?

Atomicity

Consistency

Isolation

Durability

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What does the 'A' in ACID stand for?

Access

Atomicity

Association

Action

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

When does a transaction enter the committed state?

After a system failure

After changes are permanently saved to the database

During a read operation

When the system is idle

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which recovery technique uses a log to restore a database after a system failure?

Buffering and Caching

Shadow Paging

Log-based recovery

Concurrency Control

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

In a system using immediate update, what happens if a rollback is initiated during a transaction?

The database remains unchanged

The log is destroyed and changes are discarded

The old state of data is restored from the log

The system terminates all active transactions

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What does the isolation property of ACID ensure in a multi-transaction environment?

Data integrity is maintained by reverting incomplete transactions

No changes are visible until a transaction is committed

Transactions can access and modify the same data simultaneously

Transactions must be executed in the order they are submitted

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

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?