ICT Revision MCQ Series (AL Grade 13) . 8 Database

69 / 100 Powered by Rank Math SEO SEO Score ICT Revision MCQ Series – Master Your Knowledge [...]

🔴 Table of Article Content[Show]

ICT Revision MCQ Series – Master Your Knowledge with Interactive Questions

Introduction In today’s fast-paced learning environment, multiple-choice questions (MCQs) have become a powerful tool for quick revision and self-assessment. Our Revision MCQ Series is designed to help students reinforce their understanding of key concepts through well-structured MCQs.

/30

ICT Revision MCQ Series AL lesson 8 . Database
This quiz assesses your knowledge of Grade 13 ICT lessons and serves as a revision test for your A/L examination preparation. It helps reinforce key concepts and improve your understanding of important ICT topics.
Perfect for:
Sri Lankan AL ICT students revising core concepts.
Building a strong foundation for exams and practical applications.
Good luck! 🖥️📊

1 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
What is the primary method to enforce referential integrity in a relational database?
NOT NULL constraint
Primary key constraint
Foreign key constraint
Check constraint
Unique constraint

Foreign keys ensure that values in one table match the primary key values in another maintaining referential integrity (Competency 8.2).
2 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which cannot be achieved using a flat file database system?
Storing simple data like a contact list
Managing complex relationships between data
Reading data using basic software
Storing data in a single file
Accessing data without a DBMS

Flat file databases like CSV files store simple data but cannot efficiently handle complex relationships unlike relational databases (Competency 8.1).
3 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
What is the primary purpose of a check constraint in a relational database?
To ensure unique values in a column
To link tables using foreign keys
To enforce a condition on column values
To allow null values in a column
To define the primary key

A check constraint enforces rules like ensuring a column’s values meet a condition (e.g. Age > 0) maintaining data validity (Competency 8.2).
4 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which facility cannot be provided by a relational database system?
Storing structured data in tables
Defining relationships between tables
Running complex machine learning algorithms
Enforcing data constraints like primary keys
Querying data using SQL

Relational databases are designed for storing managing and querying structured data not for running machine learning algorithms which require specialized tools (Competency 8.2).
5 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
What are the key components of an ER diagram in database design?
(a) (b) and (c)
(a) (b) and (d)
(b) (c) and (d)
(a) (d) and (e)
All of the above

ER diagrams include entities attributes and relationships to model the conceptual schema while tables and queries are part of logical and operational phases (Competency 8.4).
6 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
What is the role of a primary key in a relational database?
To store duplicate records
To link tables using foreign keys
To uniquely identify each row in a table
To allow null values in a column
To define the database schema

A primary key ensures each row is uniquely identifiable preventing duplicates and enabling relationships with other tables (Competency 8.2).
7 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
What is a candidate key in a logical schema?
A key that links two tables
A set of attributes that uniquely identifies tuples
A key that is not used in the schema
A key that allows null values
A key that defines the database domain

A candidate key is any attribute or combination that can uniquely identify rows with one chosen as the primary key (Competency 8.5).
8 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which is a feature of an EER diagram?
It supports only one-to-one relationships
It includes inheritance and specialization
It excludes entity identifiers
It cannot represent cardinality
It is used for physical schema design

EER diagrams extend ER diagrams with advanced features like inheritance and specialization for complex modeling (Competency 8.4).
9 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which cannot be directly achieved using an ER diagram?
Modeling relationships between entities
Defining entity attributes
Executing SQL queries
Representing cardinality
Identifying entity identifiers

ER diagrams are for conceptual design modeling entities attributes relationships and cardinality but do not execute queries which is a DBMS function (Competency 8.4).
10 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
For a hospital database tracking patient appointments what represents the input process and output?
Input: Patient ID Process: Checking appointment schedule Output: Confirm or reschedule appointment
Input: Doctor’s name Process: Verifying doctor Output: Schedule appointment
Input: Appointment time Process: Checking time slots Output: Cancel appointment
Input: Patient’s age Process: Verifying age Output: Confirm appointment
Input: Hospital room Process: Checking room availability Output: Assign room

The system uses Patient ID to check the schedule (process) and outputs whether the appointment is confirmed or needs rescheduling (Competency 8.3).
11 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which database model organizes data in a tree-like structure with parent-child relationships?
Flat file model
Hierarchical model
Network model
Relational model
Object-relational model

The hierarchical model uses a tree structure where each child has one parent suitable for simple structured data like organizational charts (Competency 8.1).
12 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
What is the primary function of a database in a school management system?
To execute programs automatically
To store and manage data efficiently
To design user interfaces
To compile software code
To connect to the internet

A database organizes and stores data like student records allowing efficient retrieval and management essential for systems like school management (Competency 8.1).
13 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
How is a many-to-many relationship transformed in a logical schema?
By adding a foreign key to one table
By creating a new table with foreign keys from both entities
By merging the two entities into one table
By deleting the relationship
By adding attributes to the relationship

A many-to-many relationship like Students-Courses requires a new table (e.g. Enrollments) with foreign keys from both entities to store the relationship (Competency 8.6).
14 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
For a retail store database tracking orders what represents the input process and output?
Input: Order ID Process: Verifying stock Output: Approve or reject order
Input: Customer name Process: Checking customer Output: Create order
Input: Product color Process: Identifying product Output: Ship order
Input: Order date Process: Checking date Output: Cancel order
Input: Store location Process: Verifying location Output: Process order

The system uses Order ID to verify stock availability (process) and outputs whether the order is approved or rejected (Competency 8.3).
15 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which SQL command is used to remove an entire database?
DELETE DATABASE
DROP DATABASE
REMOVE DATABASE
ALTER DATABASE
TRUNCATE DATABASE

The DROP DATABASE command deletes a database and all its contents a DDL operation (Competency 8.3).
16 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which statement correctly describes a database system?
(a) only
(a) and (b)
(b) and (c)
(c) and (d)
(a) and (e)

A DBMS handles database operations while SQL includes DDL for structure (e.g. CREATE) and DML for data manipulation (e.g. INSERT). Databases store structured data (Competency 8.3).
17 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which statements about normalization are true?
(a) and (c) only
(a) (b) and (c)
(b) and (d)
(c) and (e)
All of the above

Normalization reduces redundancy and 3NF removes transitive dependencies. 1NF ensures atomicity 2NF removes partial dependencies and 0NF allows non-atomic data (Competency 8.7).
18 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which statements correctly describe a logical schema?
(b) and (c) only
(a) and (b)
(b) and (d)
(c) and (e)
All of the above

A logical schema defines the database structure (tables columns relationships) independently of physical storage or specific DBMS (Competency 8.5).
19 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Match the normalization levels 1NF 2NF 3NF and 0NF with their objectives.
(a-3 b-2 c-1 d-4)
(a-1 b-3 c-4 d-2)
(a-2 b-4 c-1 d-3)
(a-4 b-1 c-2 d-3)
(a-3 b-1 c-2 d-4)

1NF ensures atomicity 2NF removes partial dependencies 3NF eliminates transitive dependencies and 0NF allows non-atomic data (Competency 8.7).
20 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
What is the primary method used to define the structure of a database table?
DML commands
DDL commands
Query optimization
Data encryption
File handling

DDL (Data Definition Language) commands like CREATE and ALTER define and modify the structure of database tables (Competency 8.3).
21 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
In education ICT enables schema design in business transaction processing in healthcare diagnostics and in government public services. What are the appropriate terms?
ER modeling databases records portals
algorithms software tests websites
queries systems files coordination
flowcharts tools data activities
tables applications reports connections

ER modeling designs schemas in education databases process transactions in business records aid diagnostics in healthcare and portals provide government services (Competency 8.4).
22 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Match the database components attribute tuple relation and constraint with their descriptions.
(a-2 b-1 c-3 d-4)
(a-1 b-2 c-4 d-3)
(a-3 b-4 c-1 d-2)
(a-4 b-3 c-2 d-1)
(a-2 b-3 c-1 d-4)

Attributes are columns tuples are rows relations are tables and constraints enforce rules like NOT NULL or primary key (Competency 8.2).
23 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
For a library system tracking book loans what represents the input process and output?
Input: Book ID Process: Checking loan status Output: Approve or deny loan
Input: Librarian’s ID Process: Verifying librarian Output: Open loan system
Input: Book color Process: Identifying book Output: Loan approval
Input: Loan date Process: Checking due date Output: Deny loan
Input: Library card Process: Scanning card Output: Book details

The system uses the book ID as input processes it by checking if the book is available and outputs whether the loan is approved or denied (Competency 8.3).
24 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
In an ER diagram what does cardinality represent?
The number of attributes in an entity
The number of relationships between entities
The number of instances one entity can relate to another
The number of primary keys in a table
The number of tables in a database

Cardinality defines relationship constraints such as one-to-many indicating how many instances of one entity relate to another (Competency 8.4).
25 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
In database design ICT supports schema design in education data management in business patient records in healthcare and citizen engagement in government. What are the appropriate terms?
ER diagrams databases records engagement
flowcharts software data coordination
algorithms systems files response
queries applications tests activities
tables tools reports connections

ER modeling designs schemas in education databases process business data records aid diagnostics in healthcare and portals provide government services (Competency 8.4).
26 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which cannot be directly achieved using normalization?
Reducing data redundancy
Eliminating insert anomalies
Optimizing query performance
Removing transitive dependencies
Ensuring data integrity

Normalization reduces redundancy anomalies and dependencies and supports integrity but query performance optimization depends on indexing and other techniques (Competency 8.7).
27 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
What best distinguishes between data and information?
Data is processed to become information which is raw and unorganized
Data is meaningful while information is raw facts
Data are raw facts while information is processed data with meaning
Data and information are the same used interchangeably
Data is qualitative while information is quantitative

Data are unprocessed facts like numbers or names. Information is data organized or processed to provide context making it useful for decision-making (Competency 8.1).
28 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
What is the primary method to transform an entity from an ER diagram to a logical schema?
Creating a query for the entity
Defining a table with attributes as columns
Adding a foreign key to the entity
Deleting the entity’s relationships
Merging entities into one table

An entity becomes a table with its attributes as columns and the identifier as the primary key forming the logical schema (Competency 8.6).
29 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Which SQL command is used to add a new column to an existing table?
INSERT
UPDATE
ALTER
DELETE
SELECT

The ALTER command modifies a table’s structure such as adding a new column and is part of DDL (Competency 8.3).
30 / 30
Category: Revision MCQ AL Grade 13 Lesion 8
Select Your Preferred Language 😊
Match the SQL commands CREATE ALTER DELETE and SELECT with their functions.
(a-3 b-1 c-2 d-4)
(a-1 b-2 c-4 d-3)
(a-2 b-4 c-1 d-3)
(a-4 b-3 c-2 d-1)
(a-3 b-2 c-1 d-4)

CREATE makes tables ALTER modifies them DELETE removes data and SELECT retrieves data (Competency 8.3).
Your score is
0%

Why Use MCQs for Learning? MCQs are a great way to evaluate your understanding of a subject in a structured manner. Here’s why they are effective:

Quick and Efficient – MCQs allow for rapid assessment of knowledge.
Engaging and Interactive – They keep learning interesting and encourage active participation.
Memory Retention – Answering questions enhances recall and reinforces concepts.
Instant Feedback – You can immediately check your answers and improve your understanding.

Tips MCQ-Based Exams

To score well in MCQ exams, follow these strategies:

Understand the Concepts – Don’t just memorize answers; understand the logic behind them.
Eliminate Wrong Options – Narrow down choices by eliminating incorrect answers.
Time Management – Avoid spending too much time on one question.
Practice Regularly – Consistent practice improves accuracy and speed.
Read Carefully – Pay attention to tricky words like not, always, and except.

Conclusion

The Revision MCQ Series is your go-to resource for mastering concepts efficiently. Keep practicing with Lesson 1 questions and stay tuned for upcoming lessons. Your success starts with consistent revision and smart study techniques!