NEW
Font size
WorksheetsDatabase Management System Quiz
Total questions: 30
Worksheet time: 3600secs
What is the main purpose of a Database Management System (DBMS)?
To create web pages using HTML
To store, manage, and retrieve data efficiently
To design user interfaces for software applications
To calculate statistical data only
Which of the following best describes a DBMS?
A software used only for network security
A system that allows users to define, create, maintain, and control access to databases
A program for editing images
A tool for writing programming code
Which of the following is NOT a component of a DBMS?
Data Dictionary
Query Processor
Image Renderer
Storage Manager
What is the function of the Query Processor in a DBMS?
To print reports
To backup files
To interpret and execute database queries
To design user interfaces
What distinguishes data from information in databases?
Information is less useful than data
Data is always numeric
Information is processed data with meaning
Data and information are always the same
Which of the following best defines a schema in a database?
A set of rules for data entry
The structure that defines the organization of data in a database
The security level of a database
A list of programming functions
What is a tuple in a database context?
A programming statement
A row in a database table
A column in a table
A data model
What is the purpose of a Primary Key in a relational database?
To store large text
To duplicate records
To uniquely identify each record in a table
To sort data randomly
What does normalization in databases aim to achieve?
To slow down queries
To add more data types
To reduce data redundancy and improve data integrity
To delete duplicate records only
Which of the following is an advantage of using a DBMS?
It is slower than file systems
It provides data consistency and security
It always uses manual input
It works without any software
Which type of database uses a tree-like structure to represent data?
Hierarchical Database
Relational Database
Network Database
Object-Oriented Database
Which of the following databases is best known for representing many-to-many relationships through graphs?
Hierarchical
Network
Relational
NoSQL
Which type of database stores data in tables using rows and columns?
Object-Oriented
Network
Relational
NoSQL
Which of the following best describes an Object-Oriented Database?
Stores data only in flat files
Only stores text documents
Uses objects similar to those in object-oriented programming languages
Organizes data in spreadsheets
What is a key feature of NoSQL databases?
They use only relational tables
They are optimized for unstructured or semi-structured data
They don’t allow data scaling
They use only SQL queries
How is a DBMS classified based on the number of users?
Single-user and multi-user systems
Offline and online systems
High-level and low-level systems
Small and large databases
A distributed DBMS is classified based on which of the following?
Data redundancy
Number of tables
Location of databases across multiple sites
File size
Which data model organizes data into tables with rows and columns?
Hierarchical model
Network model
Relational model
Object model
Which DBMS classification depends on the purpose it serves (e.g., banking, education)?
Use case scenarios
Access methods
Data volume
Programming tools
Indexed access and sequential access are examples of what?
Use case scenarios
Access methods
DBMS components
Schema types
Which of the following is a feature of a centralized database system?
Data is stored and managed in a single location
Data is divided among users
Every user maintains a local copy
Data cannot be queried
What is an advantage of a distributed database over a centralized one?
Central control is stronger
No data redundancy
Faster access and higher reliability in different locations
Single point of failure
Which of the following is more prone to network failure issues?
Relational database
Centralized database
Distributed database
Hierarchical database
A local hospital wants to digitize its patient records. Which type of DBMS is most appropriate for this need?
Hierarchical DBMS
Flat file system
Relational DBMS
NoSQL DBMS
Which of the following components is most important for managing stored patient data in the hospital system?
Syntax highlighter
Storage Manager
Image Scanner
Code Compiler
Which SQL statement correctly creates a table named Students with relevant fields?
ADD TABLE Students(StudentID, Name, Email)
MAKE Students(StudentID, Name, Course, Email)
CREATE TABLE Students(StudentID INT, FullName VARCHAR(100), Course VARCHAR(50), Year INT, Email VARCHAR(100));
INSERT TABLE Students VALUES (...)
Which query retrieves all students enrolled in "ICT Level 5"?
FIND FROM Students WHERE Course = ICT Level 5
FETCH * WHERE Course = ICT Level 5
SELECT * FROM Students WHERE Course = 'ICT Level 5';
GET Students FROM Course = "ICT Level 5"
Which of the following is a common use case for a NoSQL database?
Creating relational data models
Storing structured data with complex relationships
Performing complex transactions
Handling large volumes of unstructured data
What is the primary function of a Data Dictionary in a DBMS?
To store user credentials
To define the structure of the database
To manage database backups
To execute SQL queries
Which SQL command is used to remove a table from a database?
DELETE TABLE table_name;
DROP TABLE table_name;
REMOVE TABLE table_name;
ERASE TABLE table_name;
