NEW
Font size
WorksheetsDBC- CH01 (1125)
Total questions: 20
Worksheet time: 10mins
What is data?
Processed facts
Raw facts
Meaningful information
Graphical output
Which term refers to data that has been processed to reveal meaning?
Database
Metadata
Information
DBMS
A database can be described as:
Manual filing system
Electronic filing cabinet
Networking device
Operating system
What does DBMS stand for?
Database Managed Storage
Data Basic Management System
Database Management System
Digital Business Management System
Which of the following is stored in a database?
Only user interfaces
Data and metadata
Only processed reports
Only graphics
Which type of database supports only one user at a time?
Distributed database
Centralized database
Multiuser database
Single-user database
A common example of database software for small business use is:
Oracle
Microsoft Access
Hadoop
Excel
Which of the following is a major limitation of traditional file systems?
Easy administration
Simple system security
Extensive programming required
Quick modification
In a DBMS, the component that contains the definition of data is called:
Data warehouse
Data dictionary
Metadata vault
Index file
Which DBMS function ensures only authorized users can access data?
Backup and recovery
Integrity management
Security management
Presentation control
A Malaysian SME moving from Excel files to MySQL is mainly trying to overcome which problem of file systems?
Data being too secure
Difficulty in performing ad-hoc queries
Too much centralized control
Overloaded network storage
Which type of database is commonly used for real-time operational transactions?
Graph database
Operational/Transactional database
Data warehouse
Multimedia database
A multiuser database means:
Only one person has write access
Multiple users can access the system at once
The database is located in multiple buildings
Only administrators can use it
Which of the following pairs represent NoSQL databases?
MongoDB and Redis
Oracle and SQL Server
MySQL and PostgreSQL
SQL Server and Microsoft Access
A government agency in Malaysia faces difficulty changing its legacy file-based processing structure. What database concept directly solves this problem?
Distributed networks
DBMS independence from application programs
Increased operational costs
Data fragmentation
A Malaysian bank requires transaction rollback, multiuser control, and high data security. Which DBMS capability is most critical?
Data dictionary management
Presentation transformation
Backup and recovery with access control
Metadata analytics
A database in which data is stored in multiple branches across Malaysia (Penang, KL, Johor) is best classified as:
Centralized
Distributed
Single-user
Hierarchical
A Malaysian analytics startup must handle millions of unstructured social media posts daily. Which approach is most suitable?
Flat file system
Relational-only SQL database
NoSQL Big Data solutions
Desktop Access database
A poorly designed database at a college results in repeated student records and inaccurate reports. Which fundamental DBMS objective is being violated?
Data integrity
Data encryption
Presentation formatting
Operating system compatibility
Telekom Malaysia streams sensor data from network devices in real time, requiring analysis of rapid incoming data. Which ‘V’ of Big Data is most critical?
Veracity
Velocity
Variety
Volume
