NEW
Font size
WorksheetsDC014 - 2.1 Introduction to Databases
Total questions: 30
Worksheet time: 15mins
Which of the following best defines data?
Processed facts that are meaningful
Raw, unprocessed facts and figures
A collection of related information
Software used to manage records
Which of the following is an example of information?
“1957”
“H₂SO₄”
“The year Malaysia gained independence”
“Audio recording”
A database can be defined as:
A random collection of files
A collection of related data organized for easy access
Any software that stores text files
A method of internet browsing
Which of the following illustrates the use of a database in education?
Teacher’s handwritten notes
Student record system
Whiteboard scheduling
Printed library catalogs
Why is a database preferred over file processing systems?
It increases redundancy
It centralizes data for easy access
It isolates information by department
It eliminates all costs
Which of the following is NOT a function of a DBMS?
Create
Delete
Update
The acronym CRUDS stands for:
Create, Read, Update, Delete, Store
Copy, Read, Update, Delete, Secure
Create, Repair, Upload, Delete, Share
Create, Run, Update, Drop, Secure
An example of a DBMS is:
Microsoft Word
MySQL
Photoshop
Google Docs
Which of the following describes a Database System?
Only hardware and software
Database + DBMS + application programs + users
Database + spreadsheets only
Users + internet connection
In an airline reservation system, why is a database crucial?
It prints passenger tickets
It updates seat availability instantly
It books only one seat per day
It removes data redundancy only
Which of the following is part of the hardware component?
SQL
Servers and storage drives
DBMS software
Database administrator
Which group does a Database Administrator (DBA) belong to?
Hardware
People
Software
Data
Metadata can best be described as:
Rules for backup and recovery
Data about data, such as types and constraints
A collection of random files
SQL commands
Which is an example of system utilities in a database?
Performance monitoring tool
Microsoft Word
SQL command
A data dictionary
Which of the following is used to communicate with databases?
HTML
SQL
XML
CSS
The Query Processor in a DBMS is responsible for:
Translating queries into low-level instructions
Backing up data automatically
Storing hardware configuration
Repairing damaged hard drives
The Data Dictionary stores:
User passwords
Information about data structure and relationships
SQL queries
Operating system files
In a file processing system, data redundancy means:
Data is stored once only
Same data is stored in multiple files
Data is not shared among departments
Data is stored in metadata
Which is a problem of file processing systems?
Shared data
Centralized storage
Isolated data in separate files
Faster access speed
In a database system, data consistency means:
Multiple versions exist
Only one valid version exists
Data is isolated
Files are separate by department
Which of the following best explains data sharing in a database system?
Every department creates its own file
Data is accessible organization-wide
Only DBAs can access the data
Data must be copied to multiple systems
Which of the following is an advantage of databases over file systems?
Slower performance
Easier multi-user access
Greater redundancy
Increased complexity
Which is an advantage of database systems?
High setup costs
Reduced data redundancy
Increased performance overhead
Centralized risk
Which feature protects data from loss?
Scalability
Backup and recovery
Metadata
Performance overhead
Which is a disadvantage of databases?
Backup and recovery
Security risks
Reduced data redundancy
Improved consistency
Which of the following explains scalability?
Ability to grow with organizational needs
Ability to reduce costs
Ability to centralize redundancy
Ability to isolate data
The phrase “one version of the truth” refers to:
Data redundancy
Data consistency
Data sharing
Data dictionary
In healthcare, a database can be used to manage:
Student records
Patient and medication records
Inventory in a supermarket
Airline reservations
In education, which of the following is an example of database use?
Flight reservation system
Library catalog system
Payroll system
Inventory in a supermarket
In business, databases are often used for:
Patient records
Employee payroll and customer management
Airline reservations
Library book catalog
