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.

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 quizzes

• Introduction to Databases
• SQL Basics

Browse all Database Management quizzes