Introduction to Databases Quiz - CBSE Class 9 ICT

Free practice quiz: Introduction to Databases (CBSE Class 9 ICT). 20 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

This CBSE Class 9 ICT practice quiz has 20 multiple-choice questions on Introduction to Databases, 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?

   1. A collection of data organized for easy access
   2. A single file on a computer
   3. A web page
   4. A type of operating system
   Show answer

   Answer: A. A collection of data organized for easy access

   A database is a systematic collection of data organized to allow easy access, management, and updating.

2. What does 'RDBMS' stand for?

   1. Relational Database Management System
   2. Remote Database Management System
   3. Random Database Management Structure
   4. Rapid Data Management Syntax
   Show answer

   Answer: A. Relational Database Management System

   RDBMS stands for Relational Database Management System, which is a type of database management system that stores data in a structured format using rows and columns.

3. What is normalization in databases?

   1. A process to organize data to reduce redundancy
   2. A technique to enhance data privacy
   3. A method to increase data storage
   4. A way to compress data
   Show answer

   Answer: A. A process to organize data to reduce redundancy

   Normalization is a database process used to reduce data redundancy and dependencies by organizing fields and table of a database.

4. What is a foreign key in a database?

   1. A unique key used only in foreign databases
   2. A key used to link two tables together
   3. A key that is a primary key in foreign countries
   4. A key that allows only foreign data
   Show answer

   Answer: B. A key used to link two tables together

   A foreign key is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table, establishing a link between the tables.

5. What is the purpose of an index in a database?

   1. To speed up search queries
   2. To format database text
   3. To encrypt data
   4. To provide user access control
   Show answer

   Answer: A. To speed up search queries

   An index in a database improves the speed of data retrieval operations by providing quick access to rows in a data table.

More questions in this quiz

Answers and explanations are in the full quiz.

1. Which of the following can be considered a database?
2. Which software is used to manage a database?
3. What is the function of SQL?
4. Which is not a type of database model?
5. Which of the following is a primary key?
6. Which kind of data can be stored in a database?
7. What does 'SQL Join' refer to in databases?
8. Which of the following is a commercial RDBMS?
9. Which SQL statement is used to add a new row to a table?
10. In databases, what is a 'view'?
11. What does the ACID acronym stand for in databases?
12. Which SQL clause is used to filter the records returned by a query?
13. What is a 'primary key constraint'?
14. How can redundancy be reduced in database design?
15. What is denormalization?

Browse all Working with Data quizzes

More to play