ICT Revision MCQ Series 9. Database

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.

/24

ICT Revision MCQ Series 9. Database

This quiz assesses your knowledge of Grade 10 ICT lessons and serves as a revision test for your O/L examination preparation. It helps reinforce key concepts and improve your understanding of important ICT topics.

Perfect for:

• Sri Lankan OL ICT students revising core concepts.
• Building a strong foundation for exams and practical applications.

Good luck! 🖥️📊

1 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a type of computer classification?

Mainframe

Mini

Analog

Hybridization

Computers are classified as mainframe, mini, digital, analog, or hybrid, but "hybridization" is not a valid classification.

2 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a feature of modern ICT systems?

High-speed processing

Manual operation

Large storage capacity

Network connectivity

Modern ICT systems are automated and do not rely on manual operation.

3 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which column in the Students table acts as a foreign key?

Name

Grade

ClassTeacherID

DateOfBirth

The ClassTeacherID column in the Students table links to the TeacherID column in the Teachers table, establishing a relationship between the two tables.

4 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Match the following database operations with their purposes:

(a-1, b-2, c-3, d-4)

(a-2, b-1, c-4, d-3)

(a-3, b-4, c-1, d-2)

(a-4, b-3, c-2, d-1)

Queries extract data, forms provide interfaces, reports present data, and relationships link tables.

5 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a component of a computer system?

Input devices

Output devices

Entertainment devices

Storage devices

Entertainment devices are not a core component of a computer system.

6 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following statements about relational databases are true?

(a) First-generation computers were large and consumed significant power.
(b) Transistors replaced vacuum tubes in the second generation.
(c) Integrated circuits were introduced in the fourth generation.
(d) Microprocessors improved speed and efficiency in the fourth generation.

1. (a), (b), and (d)
2. (b), (c), and (d)
3. (a), (c), and (d)
4. All of the above

(a), (b), and (d)

(b), (c), and (d)

(a), (c), and (d)

All of the above

Foreign keys are essential for establishing relationships between tables, so (c) is false. The other statements are correct.

7 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

What is the correct sequence of steps to design a simple database?

 

Identify purpose, select fields, define relationships, create tables

Select fields, identify purpose, create tables, define relationships

Create tables, select fields, identify purpose, define relationships

Define relationships, create tables, select fields, identify purpose

The logical sequence is to first identify the purpose, then select fields, define relationships, and finally create tables.

8 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a characteristic of data?

Raw facts

Processed information

Unorganized

Input material

Data refers to raw, unprocessed facts, while processed information is the output.

9 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a type of database key?

Primary key

Secondary key

Foreign key

Composite key

Common database keys include primary, foreign, and composite keys, but "secondary key" is not a standard term.

10 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

What would happen if the TeacherID value "T001" is deleted from the Teachers table?

The Students table will remain unaffected

All students linked to "T001" will lose their teacher reference

The Students table will automatically update the Grade column

The database will create a new teacher record

Deleting "T001" from the Teachers table will break the relationship, and students with ClassTeacherID = T001 will no longer have a valid teacher reference.

11 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a feature of a relational database?

Absence of redundancy

Manual data entry

Data security

Consistency

Relational databases aim to reduce redundancy, ensure data security, and maintain consistency, but they do not rely on manual data entry.

12 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following statements about the evolution of computers is FALSE?
(a) First-generation computers were large and consumed significant power.
(b) Transistors replaced vacuum tubes in the second generation.
(c) Integrated circuits were introduced in the fourth generation.
(d) Microprocessors improved speed and efficiency in the fourth generation.

 

(a) and (b)

(b) and (c)

(c) and (d)

(a) and (d)

Integrated circuits were introduced in the third generation, not the fourth.

13 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a benefit of ICT in national development?

Improved communication

Increased unemployment

Enhanced education

Better healthcare

ICT generally reduces unemployment by creating new job opportunities and improving efficiency.

14 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

ICT is used in various sectors. In education, it enables ___________ learning. In business, it facilitates communication through ___________. In healthcare, it manages patient records with ___________. For government services, it improves citizen access via ___________.

physical, meetings, paper, queues

remote, email, databases, websites

traditional, memos, filing cabinets, offices

classroom, phones, folders, counters

ICT enables remote learning, email communication, database management, and online government services.

15 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Match the following database components with their descriptions:

Benefit	Description
(a) Query	(1) Extracts specific data based on criteria
(b) Form	(2) Provides an interface for data entry
(c) Report	(3) Presents data in a printable format
(d) Relationship	(4) Links tables together

(a-1, b-2, c-3, d-4)

(a-2, b-1, c-4, d-3)

(a-3, b-4, c-1, d-2)

(a-4, b-3, c-2, d-1)

A table stores data, a field is a single piece of information, a record is a complete set of fields, and a key uniquely identifies a record.

16 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Match the following ICT benefits with their descriptions:

Benefit	Description
(a) Efficiency	(1) Faster processing
(b) Accuracy	(2) Error-free results
(c) Speed	(3) Reduced resource usage
(d) Scalability	(4) Ability to grow

(a-3, b-2, c-1, d-4)

(a-1, b-3, c-4, d-2)

(a-2, b-4, c-3, d-1)

(a-4, b-1, c-2, d-3)

Efficiency reduces resource usage, accuracy ensures error-free results, speed enables faster processing, and scalability allows growth.

17 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a benefit of using a database?

Data organization

Manual record-keeping

Data security

Efficient data retrieval

Databases automate data management, reducing the need for manual record-keeping.

18 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following best describes the role of ICT in e-government?

Reducing transparency

Enhancing citizen access to services

Increasing paperwork

Limiting communication

E-government uses ICT to provide citizens with easier access to government services.

19 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a function of a computer system?

Input

Processing

Entertainment

Output

Entertainment is not a core function of a computer system.

20 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

A company wants to create a database to store employee details. Which component should they use to ensure each employee has a unique identifier?

Primary key

Foreign key

Field name

Table name

A primary key ensures that each record in a table is uniquely identifiable.

21 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

A system that converts raw data into meaningful information is called a(n):

Information system

Data processor

Communication network

Storage device

An information system processes raw data into meaningful information using input, processing, and output components.

22 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a feature of a database?

Absence of redundancy

Complexity

Security

Consistency

Databases are designed to reduce complexity by organizing data efficiently, ensuring security, consistency, and avoiding redundancy.

23 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Match the following database terms with their descriptions:

(a-1, b-2, c-3, d-4)

(a-2, b-1, c-4, d-3)

(a-3, b-4, c-1, d-2)

(a-4, b-3, c-2, d-1)

A primary key uniquely identifies records, a foreign key links tables, a record is a complete set of fields, and a field is a single piece of information.

24 / 24

Category: Revision MCQ OL Grade 10 Lesion 9

Select Your Preferred Language 😊 

Which of the following is NOT a characteristic of a good information system?

Accuracy

Complexity

Timeliness

Relevance

A good information system should be simple and user-friendly, not overly complex.

Your score is

0%

Restart quiz

9. Develops Simple Databases to Elicit Information

• 9.1 Explores the Concept of Database.
  • Introduction to databases
  • Definition of a database
  • Advantages of databases
  • Features of databases: Absence of redundancy, Efficiency, Accuracy, Consistency, Security, Validity, Simplicity, Integrity
  • Manual and electronic databases: Comparison and contrast
  • Introduction to Relational Databases: Tables, records, fields, key fields
• 9.2 Creates a simple database with a single table, manually.
  • Field name, unique field, data types, field size
• 9.3 Converts a manual database into electronic media.
• 9.4 Designs a simple relational database.
  • Tables, fields, and key fields: Primary key, foreign key, relationships
• 9.5 Uses DBMS software to create relational databases.
  • Creation of a database
  • Identification of primary and foreign key
  • Creation of relationship between tables
• 9.6 Uses forms to view and update data.
  • Form design, Manipulation of properties of a form, Insertion of controls: Delete button
• 9.7 Creates Queries to extract information.
  • Design of queries using query tool without using SQL structure
  • Use of criteria, Sorting of records
• 9.8 Creates reports to present information.
  • Use of Report Wizard, Printing of reports

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:

1. Understand the Concepts – Don’t just memorize answers; understand the logic behind them.
2. Eliminate Wrong Options – Narrow down choices by eliminating incorrect answers.
3. Time Management – Avoid spending too much time on one question.
4. Practice Regularly – Consistent practice improves accuracy and speed.
5. 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!

FAQs

1. How can MCQs help in learning? MCQs improve retention, provide quick assessment, and make learning engaging.

2. Can I find more lessons in this series? Yes! We regularly update the Revision MCQ Series with new lessons. Stay tuned!

3. How should I prepare for MCQ-based exams? Understand concepts, practice regularly, manage time well, and eliminate wrong answers.

4. Where can I access more MCQs? You can find additional MCQs on our website or in upcoming blog posts.

5. Is this MCQ series suitable for all students? Yes! Whether you’re a beg