ISST303-M1

Which best explains why a bank prefers a DBMS over file-based storage?

• Files are simple to use

• DBMS supports multi-user transactions

• Files are cheaper

• DBMS is always cloud-based

In a school library, why is a DBMS more effective than spreadsheets?

• It avoids duplicate entries

• It runs faster than Excel

• It requires less training

• It cannot be hacked

Which problem is most likely in a file-based system?

• Data redundancy

• Data privacy

• Data mining

• Data encryption

A hospital shifts to a DBMS. Which benefit will they notice first?

• Lower power use

• Centralized storage

• No hardware failures

• Instant backups

Which situation shows a DBMS advantage?

• A cashier uses a calculator

• A store updates stock in real-time

• A farmer writes records in a notebook

• A teacher keeps scores on paper

Which function prevents errors when two users edit the same record?

• Utility

• Independence

• Migration

• Concurrency

If a payroll system crashes mid-update, which feature ensures recovery?

• Backup

• Security

• Rollback

• Replication

Why is data independence important?

• It makes storage faster

• It blocks hackers

• It saves disk space

• It separates programs from data

Which component interacts directly with users?

• DBA

• Application

• DBMS

• Storage

Who ensures company data is secure and reliable?

• DBA

• End-user

• Developer

• Manager