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.
Play all 20 questions freeSample questions
What is a database?
- A collection of data organized for easy access
- A single file on a computer
- A web page
- 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.
What does 'RDBMS' stand for?
- Relational Database Management System
- Remote Database Management System
- Random Database Management Structure
- 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.
What is normalization in databases?
- A process to organize data to reduce redundancy
- A technique to enhance data privacy
- A method to increase data storage
- 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.
What is a foreign key in a database?
- A unique key used only in foreign databases
- A key used to link two tables together
- A key that is a primary key in foreign countries
- 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.
What is the purpose of an index in a database?
- To speed up search queries
- To format database text
- To encrypt data
- 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.