WorksheetsQuiz 1 - C C 1 0 5
Total questions: 50
Worksheet time: 40mins
An organization collects large volumes of customer interaction logs but fails to analyze them. Which information management issue is MOST evident?
Data redundancy caused by normalization failure
Poor information quality due to lack of validation
Dark data increasing operational risk
Inefficient data storage caused by unstructured formats
A hospital updates a patient’s address in one system, but other departments still see the old address. This situation primarily violates:
Atomicity
Data consistency
Data security
Data redundancy
A university implements a centralized database so that enrollment, grading, and billing systems all reference the same student data. The main advantage achieved is:
Improved physical data independence
Reduced data redundancy
Increased transaction latency
Elimination of data normalization
Which scenario BEST demonstrates information as a strategic resource?
Storing archived files for compliance purposes
Using market data analytics to anticipate competitor pricing
Backing up operational data weekly
Encrypting employee records
An organization digitizes paper records but keeps inconsistent naming conventions across departments. Which challenge remains unresolved?
Information accessibility
Unified best practices
Information security
Information growth
A DBMS prevents a fund transfer from deducting money without crediting the recipient account during a system crash. This illustrates:
Data consistency
Referential integrity
Atomicity
Data independence
Compared to file-based systems, DBMS environments MOST significantly improve:
Manual data validation
Concurrent multi-user access
Physical file storage capacity
Standalone application execution
Which activity transforms raw data into actionable information?
Data encryption
Data replication
Data interpretation
Data transmission
An e-commerce company integrates customer data from CRM and inventory systems to personalize recommendations. This reflects which information management goal?
Data lifecycle control
Data integration and sharing
Information destruction
Media platform optimization
Which outcome MOST likely if information silos persist within an organization?
Improved operational efficiency
Enhanced strategic planning
Reduced collaboration and insight sharing
Increased data consistency
A DBMS enforces foreign key constraints to ensure enrollment records reference existing students. This primarily supports:
Data redundancy
Data integrity
Data security
Logical independence
Which practice BEST addresses rapid organizational data growth?
Increasing file duplication
Implementing data lifecycle management
Manual record archiving
Restricting data access
When data is accurate, timely, and accessible, information management MOST directly supports:
Hardware optimization
Decision-making quality
File compression efficiency
System portability
A DBMS allows structural changes without modifying application programs. This advantage is known as:
Physical data independence
Logical data independence
Transaction isolation
Metadata abstraction
Which misconception often leads organizations to underinvest in information management?
Information systems are people-dependent
Information management is only a technical concern
Data requires interpretation to gain value
Security controls require continuous review
True or False: Information management involves both technological tools and human responsibility.
True
False
True or False: Data automatically becomes information once it is stored digitally.
True
False
True or False: Databases reduce redundancy by allowing multiple independent copies of the same data.
True
False
True or False: Data consistency ensures that all users see logically uniform data after updates.
True
False
True or False: Atomicity allows partial completion of database transactions when failures occur.
True
False
True or False: Information silos hinder collaboration across departments.
True
False
True or False: File-based systems provide built-in transaction rollback mechanisms.
True
False
True or False: Data integrity includes entity, referential, and domain integrity.
True
False
True or False: Poor information quality can negatively affect organizational decision-making.
True
False
True or False: DBMS environments eliminate the need for security controls.
True
False
Identification / Fill-in-the-Blanks: The discipline concerned with collecting, organizing, storing, and controlling organizational information is called (a) .
Identification / Fill-in-the-Blanks: Raw, unprocessed facts such as numbers or symbols are referred to as (a) .
Identification / Fill-in-the-Blanks: The unnecessary duplication of data across multiple locations is known as (a) .
Identification / Fill-in-the-Blanks: The database property that ensures all transaction operations succeed or fail together is (a) .
Identification / Fill-in-the-Blanks: The software that manages databases and provides an interface between users and data is called a (a) .
Identification / Fill-in-the-Blanks: The process of organizing data into structured tables to reduce duplication is called (a) .
Identification / Fill-in-the-Blanks: Data that is numerical and measurable is classified as (a) data.
Descriptive, non-numerical data is known as (a) data.
The concept that ensures updates in one place are reflected everywhere is called data (a) .
The language used to retrieve data from a database is (a) .
Information collected but never analyzed or used is called (a) data.
The database rule that prevents invalid references between tables enforces (a) integrity.
The ability of databases to support multiple users simultaneously is called (a) access.
Data about data, including table definitions and constraints, is known as (a) .
The advantage that allows database structure changes without breaking applications is (a) data independence.
Which feature MOST differentiates a DBMS from a file-based system?
Manual data updates
Centralized data control
Standalone file storage
Limited user access
Which outcome BEST reflects effective information management?
Increased data volume
Faster hardware performance
Improved strategic decision-making
Reduced software licensing costs
A flat-file system becomes inefficient mainly because it:
Uses relational keys
Supports normalization
Encourages redundancy
Enforces atomicity
Which DBMS component stores information about tables, relationships, and constraints?
Hardware
Data dictionary
Application layer
User interface
Which database concept ensures that invalid data values cannot be entered?
Domain integrity
Atomicity
Data redundancy
Logical independence
When organizations analyze trends to anticipate risks, they are primarily using information for:
Data storage
Risk management
Record archiving
Transaction processing
Which situation BEST illustrates data sharing with security?
Public spreadsheets with edit access
Role-based access to a centralized database
Manual file duplication across departments
Isolated system storage
Why are databases preferred for large-scale systems like banking?
Minimal storage requirements
Support for ACID properties
Reduced need for backups
Elimination of security risks
Which DBMS advantage allows organizations to grow without redesigning systems?
Metadata management
Scalability
Data redundancy
Manual optimization
Which factor MOST contributes to failed information management implementations?
Excessive data usage
Lack of unified policies
Overuse of automation
Strong governance structures
