Database Management Systems Quiz - CBSE Class 10 ICT

Free practice quiz: Database Management Systems (CBSE Class 10 ICT). 20 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

This CBSE Class 10 ICT practice quiz has 20 multiple-choice questions on Database Management Systems, and 20 of them come with an explanation. Try the 5 sample questions below (tap an option to check yourself), then play the full quiz online. No sign-up needed.

Sample questions

1. What is a database management system (DBMS)?

   1. A software system that creates, manipulates, and manages databases
   2. A hardware device used for data processing
   3. A programming language for building databases
   4. An algorithm to search data in a hard drive
   Show answer

   Answer: A. A software system that creates, manipulates, and manages databases

   A DBMS (Database Management System) is software designed to store, retrieve, define, and manage data in a database.

2. Which of these is an advantage of using a DBMS?

   1. Complexity increase
   2. Data redundancy control
   3. High cost of setup
   4. Reduced security
   Show answer

   Answer: B. Data redundancy control

   DBMS helps in controlling data redundancy by efficiently organizing data, making systems more efficient.

3. Which of the following is a primary key characteristic?

   1. It must be non-unique
   2. It can contain NULL values
   3. It must be unique for each record
   4. It must relate to an external database
   Show answer

   Answer: C. It must be unique for each record

   A primary key is a unique identifier for each record in a database table and must be unique for each record without NULL values.

4. What is the purpose of the SQL command 'JOIN'?

   1. To combine rows from two or more tables
   2. To add new columns to an existing table
   3. To compress database records
   4. To encrypt database entries
   Show answer

   Answer: A. To combine rows from two or more tables

   SQL JOIN combines columns from two or more tables based on a related column between them to form a single dataset.

5. Which of these is a consequence of database denormalization?

   1. Reduced data redundancy
   2. Increased complexity in data retrieval
   3. Faster read times
   4. Reduced storage usage
   Show answer

   Answer: C. Faster read times

   Denormalization increases redundancy to improve read performance at the expense of write performance and storage efficiency.

More questions in this quiz

Answers and explanations are in the full quiz.

1. Which of the following is NOT a function of a DBMS?
2. Which component of DBMS is responsible for database management?
3. What does SQL stand for?
4. What does ACID stand for in the context of databases?
5. In a database, what is a 'foreign key'?
6. What is normalization in a database?
7. Which command in SQL is used to remove a table from a database?
8. What is a 'view' in the context of databases?
9. What is the function of a database index?
10. Which SQL clause is used to filter records while fetching data from a database?
11. What does the term 'referential integrity' mean in database systems?
12. Which of the following is an example of a NoSQL database?
13. What is an 'OLAP cube' used for?
14. What is a major drawback of using distributed databases?
15. What is the main purpose of an entity-relationship diagram (ERD)?

More quizzes

• Introduction to Databases▶ Play
• SQL Basics▶ Play

Browse all Database Management quizzes

More to play