wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Midterm Examination on Information Management

Total questions: 50

Worksheet time: 25mins

Name
Class
Date
1.

Which of the following best explains the difference between data and information?

a)

Data is always numerical; information is always textual

b)

Data is raw and unprocessed, while information is data that has been interpreted for meaning.

c)

Data is more valuable than information.

d)

Data cannot be stored, but information can.

2.

A school registrar keeps a list of student names and grades. When these grades are summarized into a class average, what has occurred?

a)

Storage

b)

Information processing

c)

Data Collection

d)

Encoding

3.

In an information system, which component ensures that stored data is transformed into meaningful reports for decision-making?

a)

Database

b)

People

c)

Process

d)

Hardware

4.

Which of the following is an example of information?

a)

"2025-09-19"

b)

"Juan Dela Cruz"

c)

"Juan Dela Cruz enrolled on 2025-09-19"

d)

"Student ID: 2456"

5.

A bank ATM system that checks your balance after inserting a card is an example of:

a)

Transaction Processing System

b)

Decision Support System

c)

Executive Information System

d)

Expert System

6.

A government agency maintains thousands of records across multiple branches. They decide to centralize data storage into one system accessible to all. What database environment concept is being applied?

a)

Distributed redundancy

b)

Centralized database management

c)

Physical schema separation

d)

Unstructured data entry

7.

The database design team must first understand how students, courses, and grades interact before writing SQL code. This is an example of:

a)

Logical modeling without planning

b)

Direct coding without planning

c)

Backup and recovery planning

d)

File system organization

8.

A student management system allows only authorized staff to view scholarship details, while others can see only general student data. Which function of the database environment is applied?

a)

Data abstraction

b)

concurrency

c)

Security and authorization

d)

backup control

9.

An engineering firm decides to use a relational database rather than spreadsheets. What main advantage does this shift provide?

a)

Unlimited storage capacity

b)

Centralized control and reduced redundancy

c)

elimination of human error

d)

faster internet speed

10.

Two instructors simultaneously update the same student's attendance record. The DBMS ensures only one update is saved at a time. What concept prevents errors?

a)

Data integrity

b)

concurrency control

c)

security restriction

d)

physical storage

11.

A store manager requests monthly sales trends with graphs. The system automatically generates a chart based on raw sales transactions. Which aspect of the database environment is demonstrated?

a)

Data modeling

b)

information generation

c)

Physical storage

d)

file processing

12.

A school's database crashed, and the registrar cannot access student grades. Fortunately, the IT team restores data from the previous day. Which DBMS feature allowed this recovery?

a)

Data independence

b)

Data redundancy

c)

Backup and recovery

d)

query optimization

13.

The barangay captain wants a computerized census system. The developer shows him a simple screen where he enters household names and addresses, while the system handles the underlying SQL commands. This illustrates:

a)

logical schema

b)

Data abstraction

c)

Backup recovery

d)

physical schema

14.

A hospital stores thousands of patient records. A nurse queries "patients with blood type O+," and the system immediately retrieves the list. Which component of the database environment makes this possible?

a)

Database management system (DBMS)

b)

Network administrator

c)

user manual

d)

backup storage

15.

An IT intern notices that different programmers must learn SQL, ER modeling, and database tools to work on the school's enrollment system. Which characteristic of the database environment is reflected here?

a)

Centralized Administration

b)

Integration of tools and skills

c)

Data recovery

d)

encryption

16.

A university system is designed so that changes in the internal file structure do not affect how users query data. Which key principle does this demonstrate?

a)

Data independence

b)

Redundancy elimination

c)

Security enforcement

d)

Data migration

17.

A professor designs a grading system. He first sketches entities like Student and Course, and their relationships. Which phase of the database development environment is he working on?

a)

Conceptual design

b)

Physical design

c)

Implementation

d)

Maintenance

18.

A company wants to prevent multiple employees from editing the same payroll record at once. Which feature of a DBMS is most relevant?

a)

Data abstraction

b)

Concurrency management

c)

backup and recovery

d)

data independence

19.

During enrollment, two departments maintain separate student lists. One has "Juan Dela Cruz," while the other has "John Dela Cruz" for the same student. Which database environment issue does this illustrate?

a)

Concurrency control

b)

Data inconsistency

c)

Database security

d)

Data backup

20.

A library keeps student borrowing slips in filing cabinets. The librarian spends hours locating overdue accounts. Which fundamental database principle could solve this inefficiency?

a)

Reducing data redundancy

b)

Using hierarchical data organization

c)

Storing only physical records

d)

Increasing file cabinets

21.

A hospital records "98.6, 99.1, 100.2" for a patient's temperature over three days. The doctor concludes the patient is developing a fever. In this scenario, the list of numbers is:

a)

Metadata

b)

Data

c)

Information

d)

Knowledge

22.

A registrar's office stores each student's name, ID, and address. Later, the system creates a report showing how many students come from each city. The report is an example of:

a)

Data

b)

Metadata

c)

Information

d)

Raw facts

23.

A researcher has hundreds of survey responses stored in a spreadsheet. However, without organizing and summarizing, the researcher cannot see patterns. At this stage, the spreadsheet mainly contains:

a)

Data

b)

Information

c)

Metadata

d)

Process

24.

In a library database, the "author, title, and publication year" fields describe the contents of a book record. These field descriptions are best classified as:

a)

Information

b)

Metadata

c)

Data

d)

Knowledge

25.

An online shopping site records every product clicked by a customer. Later, the system recommends related items using these logs. What are the raw click records considered?

a)

Metadata

b)

Data

c)

Process

d)

Information

26.

A barangay health worker notes "Maria Santos, 45 years old, 120/80 blood pressure." When this record is used to determine average blood pressure by age group, the average becomes:

a)

Data

b)

Metadata

c)

Information

d)

Redundancy

27.

The IT staff of a university is designing a student database. Before storing actual student grades, they first define the "CourseCode, Grade, and Semester" fields. What are these definitions called?

a)

Metadata

b)

Raw Data

c)

Information

d)

Schema-less storange

28.

A small clinic tracks patient visits using slips of paper. When asked "How many patients visited last month?" the staff manually counts slips, often making mistakes. Which database principle would help?

a)

Metadata creation

b)

Converting data to information

c)

Data independence

d)

Query optimization

29.

A weather app collects temperature, humidity, and rainfall from different cities. When it generates a forecast chart, the forecast is an example of:

a)

Data

b)

Information

c)

Metadata

d)

Storage

30.

A museum database has an entry: "Artifact ID: 302, Name: Pottery Jar, Origin: 12th century." The labels "Artifact ID, Name, Origin" represent:

a)

Information

b)

Metadata

c)

Raw data

d)

Knowledge

31.

A university previously stored grades separately in each department office. After switching to a centralized system, grades are stored in one database accessible by all. Which advantage of the database approach is illustrated?

a)

Data redundancy is reduced

b)

Faster internet connection

c)

Increased file cabinets

d)

Unlimited storage capacity

32.

A barangay database system allows multiple staff members to access family records at the same time without conflicting updates. Which DBMS feature is at work?

a)

Security control

b)

Concurrency control

c)

Data redundancy

d)

Backup and recovery

33.

A business owner believes that simply installing a DBMS will automatically improve decision-making. However, reports remain unclear because staff don't understand how to analyze the data. This reflects which caution about database benefits?

a)

DBMS automatically ensures information quality

b)

A DBMS does not guarantee good decision-making

c)

DBMS eliminates the need for training

d)

DBMS prevents redundancy automatically

34.

A school stores student data in a central database. When a student updates their address, the change is reflected in all official documents. Which advantage of the database approach does this show?

a)

Improved data sharing

b)

Increased redundancy

c)

Faster computation

d)

Reduced internet bandwidth

35.

A clinic installs a DBMS but fails to hire an administrator. Later, the system suffers from inconsistent records and security issues. This shows:

a)

DBMS guarantees automatic security

b)

Database environment requires proper management

c)

Metadata prevents inconsistency alone

d)

Centralized storage eliminates all risks

36.

A group of PRMSU students develops a mobile app that helps classmates track assignments and deadlines. Which part of the vision is best reflected?

a)

Learner-centered initiative

b)

Global recognition

c)

Proactive research funding

d)

Traditional classroom learning

37.

During online classes, a professor provides interactive activities, personalized feedback, and mentoring. This practice supports which aspect of the vision?

a)

Proactive engagement in learning

b)

Global society integration

c)

Digital isolation

d)

Academic competition

38.

practice supports which aspect of the vision?

a)

Proactive engagement in learning

b)

Global society integration

c)

Digital isolation

d)

Academic competition

39.

The University highlights its mission and vision at every student orientation, encouraging learners to apply them in projects and community work. This reflects:

a)

Institutional commitment to vision-driven learning

b)

Passive promotion of slogans only

c)

Avoidance of proactive strategies

d)

Disconnection from global society

40.

A university invests in a centralized database system but realizes it needs to purchase new servers and licenses to support it. Which cost is illustrated?

a)

Ongoing maintenance cost

b)

Hardware and software acquisition cost

c)

Risk of data loss

d)

Hidden training cost

41.

A small company adopts a DBMS, but most employees are unfamiliar with it, requiring months of workshops. This is an example of:

a)

Increased training cost

b)

Hardware failure risk

c)

Enhanced system security

d)

Reduced development time

42.

A hospital uses a system where patient information, doctor schedules, and billing records are all stored in one place and can be accessed securely by authorized staff. This best describes:

a)

Traditional File System

b)

Database System

c)

Paper-based System

d)

Backup-only System

43.

A small store keeps separate Excel files for sales, inventory, and customer records. When an item is sold, they must update all three files manually. Which advantage of a database system would prevent this problem?

a)

Data Redundancy Control

b)

Improved Paper Records

c)

Faster Typing Speed

d)

Manual File Storage

44.

A university allows students to enroll online. When a student chooses a subject, the system automatically checks for schedule conflicts and available slots. Which database system feature is at work?

a)

Data Integrity and Consistency

b)

Data Duplication

c)

Manual Record Checking

d)

Non-digital Scheduling

45.

A bank ensures that only authorized employees can view customer balances or approve large transactions in its database system. This illustrates:

a)

Data Security and Authorization

b)

Data Redundancy

c)

Manual Privacy Control

d)

Public Data Access

46.

A logistics company uses a centralized database to share updated delivery status across all branches in real time. This demonstrates which strength of a database system?

a)

Data Sharing and Multi-user Access

b)

Manual File Distribution

c)

Offline Record Keeping

d)

Data Hiding

47.

A small shop records sales in separate Excel sheets for each month. When a customer's name is misspelled in one sheet but corrected in another, inconsistencies arise. Which weakness of the file system is shown?

a)

Data redundancy and inconsistency

b)

Strong integrity enforcement

c)

Built-in recovery support

d)

Centralized control of data

48.

During a power failure, a hospital loses some patient records because staff relied on manual file copies for backup. Which advantage of a DBMS could have prevented this?

a)

Backup and recovery management

b)

Data duplication

c)

File-level editing

d)

Manual synchronization

49.

In a file system, data is usually stored as:

a)

Tables with relationships

b)

Plain Files (like text or spreadsheets)

c)

Cloud databases

d)

Artificial intelligence systems

50.

When it comes to security, which system provides better features like authentication and role-based access?

a)

File system

b)

DBMS

c)

Notebooks and ledgers

d)

None of the above.