NEW
Font size
WorksheetsMidterm Examination on Information Management
Total questions: 50
Worksheet time: 25mins
Which of the following best explains the difference between data and information?
Data is always numerical; information is always textual
Data is raw and unprocessed, while information is data that has been interpreted for meaning.
Data is more valuable than information.
Data cannot be stored, but information can.
A school registrar keeps a list of student names and grades. When these grades are summarized into a class average, what has occurred?
Storage
Information processing
Data Collection
Encoding
In an information system, which component ensures that stored data is transformed into meaningful reports for decision-making?
Database
People
Process
Hardware
Which of the following is an example of information?
"2025-09-19"
"Juan Dela Cruz"
"Juan Dela Cruz enrolled on 2025-09-19"
"Student ID: 2456"
A bank ATM system that checks your balance after inserting a card is an example of:
Transaction Processing System
Decision Support System
Executive Information System
Expert System
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?
Distributed redundancy
Centralized database management
Physical schema separation
Unstructured data entry
The database design team must first understand how students, courses, and grades interact before writing SQL code. This is an example of:
Logical modeling without planning
Direct coding without planning
Backup and recovery planning
File system organization
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?
Data abstraction
concurrency
Security and authorization
backup control
An engineering firm decides to use a relational database rather than spreadsheets. What main advantage does this shift provide?
Unlimited storage capacity
Centralized control and reduced redundancy
elimination of human error
faster internet speed
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?
Data integrity
concurrency control
security restriction
physical storage
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?
Data modeling
information generation
Physical storage
file processing
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?
Data independence
Data redundancy
Backup and recovery
query optimization
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:
logical schema
Data abstraction
Backup recovery
physical schema
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?
Database management system (DBMS)
Network administrator
user manual
backup storage
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?
Centralized Administration
Integration of tools and skills
Data recovery
encryption
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?
Data independence
Redundancy elimination
Security enforcement
Data migration
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?
Conceptual design
Physical design
Implementation
Maintenance
A company wants to prevent multiple employees from editing the same payroll record at once. Which feature of a DBMS is most relevant?
Data abstraction
Concurrency management
backup and recovery
data independence
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?
Concurrency control
Data inconsistency
Database security
Data backup
A library keeps student borrowing slips in filing cabinets. The librarian spends hours locating overdue accounts. Which fundamental database principle could solve this inefficiency?
Reducing data redundancy
Using hierarchical data organization
Storing only physical records
Increasing file cabinets
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:
Metadata
Data
Information
Knowledge
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:
Data
Metadata
Information
Raw facts
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:
Data
Information
Metadata
Process
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:
Information
Metadata
Data
Knowledge
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?
Metadata
Data
Process
Information
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:
Data
Metadata
Information
Redundancy
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?
Metadata
Raw Data
Information
Schema-less storange
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?
Metadata creation
Converting data to information
Data independence
Query optimization
A weather app collects temperature, humidity, and rainfall from different cities. When it generates a forecast chart, the forecast is an example of:
Data
Information
Metadata
Storage
A museum database has an entry: "Artifact ID: 302, Name: Pottery Jar, Origin: 12th century." The labels "Artifact ID, Name, Origin" represent:
Information
Metadata
Raw data
Knowledge
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?
Data redundancy is reduced
Faster internet connection
Increased file cabinets
Unlimited storage capacity
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?
Security control
Concurrency control
Data redundancy
Backup and recovery
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?
DBMS automatically ensures information quality
A DBMS does not guarantee good decision-making
DBMS eliminates the need for training
DBMS prevents redundancy automatically
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?
Improved data sharing
Increased redundancy
Faster computation
Reduced internet bandwidth
A clinic installs a DBMS but fails to hire an administrator. Later, the system suffers from inconsistent records and security issues. This shows:
DBMS guarantees automatic security
Database environment requires proper management
Metadata prevents inconsistency alone
Centralized storage eliminates all risks
A group of PRMSU students develops a mobile app that helps classmates track assignments and deadlines. Which part of the vision is best reflected?
Learner-centered initiative
Global recognition
Proactive research funding
Traditional classroom learning
During online classes, a professor provides interactive activities, personalized feedback, and mentoring. This practice supports which aspect of the vision?
Proactive engagement in learning
Global society integration
Digital isolation
Academic competition
practice supports which aspect of the vision?
Proactive engagement in learning
Global society integration
Digital isolation
Academic competition
The University highlights its mission and vision at every student orientation, encouraging learners to apply them in projects and community work. This reflects:
Institutional commitment to vision-driven learning
Passive promotion of slogans only
Avoidance of proactive strategies
Disconnection from global society
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?
Ongoing maintenance cost
Hardware and software acquisition cost
Risk of data loss
Hidden training cost
A small company adopts a DBMS, but most employees are unfamiliar with it, requiring months of workshops. This is an example of:
Increased training cost
Hardware failure risk
Enhanced system security
Reduced development time
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:
Traditional File System
Database System
Paper-based System
Backup-only System
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?
Data Redundancy Control
Improved Paper Records
Faster Typing Speed
Manual File Storage
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?
Data Integrity and Consistency
Data Duplication
Manual Record Checking
Non-digital Scheduling
A bank ensures that only authorized employees can view customer balances or approve large transactions in its database system. This illustrates:
Data Security and Authorization
Data Redundancy
Manual Privacy Control
Public Data Access
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?
Data Sharing and Multi-user Access
Manual File Distribution
Offline Record Keeping
Data Hiding
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?
Data redundancy and inconsistency
Strong integrity enforcement
Built-in recovery support
Centralized control of data
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?
Backup and recovery management
Data duplication
File-level editing
Manual synchronization
In a file system, data is usually stored as:
Tables with relationships
Plain Files (like text or spreadsheets)
Cloud databases
Artificial intelligence systems
When it comes to security, which system provides better features like authentication and role-based access?
File system
DBMS
Notebooks and ledgers
None of the above.
