Class 10 IT (Code 402) - Introduction to Database: 55 Questions with Answers
✅ 1-Mark Questions with Answers:
1. What is a database?
A database is an organized collection of data that can be easily accessed, managed, and
updated.
2. Define DBMS.
DBMS stands for Database Management System. It is software used to manage databases.
3. What is the full form of DBMS?
Database Management System
4. What is a table in a database?
A table is a collection of related data organized in rows and columns.
5. What is a field?
A field is a column in a table that stores specific information about a record.
6. What is a record?
A record is a row in a table representing a single data item.
7. Name any two DBMS software.
MySQL, Oracle
8. What is a primary key?
A primary key is a field that uniquely identifies each record in a table.
9. What is data redundancy?
Data redundancy is the unnecessary repetition of data.
10. What is data inconsistency?
Data inconsistency occurs when different versions of the same data appear in different places.
11. Write the full form of RDBMS.
Relational Database Management System
12. What is the difference between data and information?
Data is raw facts; information is processed data.
13. What is a column also called in a database?
A field or attribute
14. What does each row in a table represent?
A record
1
✅ 2-Mark Questions with Answers:
1. Write any two advantages of a database.
◦ Reduces data redundancy
◦ Increases data consistency
2. What is the difference between a flat file and a relational database?
◦ Flat file stores data in a single table.
◦ Relational database stores data in multiple related tables.
3. Explain the term “data integrity”.
Data integrity ensures data is accurate and consistent over its lifecycle.
4. Differentiate between primary key and unique key.
◦ Primary key: No duplicates & no NULLs.
◦ Unique key: No duplicates but can have NULLs.
5. Explain any two functions of DBMS.
◦ Data storage and retrieval
◦ Data security and access control
6. Mention two differences between DBMS and RDBMS.
◦ DBMS doesn’t support relationships; RDBMS does.
◦ RDBMS uses tables with primary keys.
✅ 3-Mark Questions with Answers:
1. What are the major components of a database?
◦ Tables
◦ Queries
◦ Forms
◦ Reports
2. Describe the role of a primary key in a table with an example.
A primary key uniquely identifies each row. E.g., Student_ID in a student table.
3. Explain the concept of “Relational Database” with an example.
A database with related tables. E.g., Students and Marks tables linked by Student_ID.
4. List any three advantages of using DBMS over file system.
◦ Data security
◦ Data integrity
◦ Easy backup and recovery
2
5. Explain the importance of database in daily life with examples.
Databases are used in banking, schools, hospitals, etc., to store and manage records efficiently.
✅ More 1-Mark / Objective Questions:
1. Which key is used to uniquely identify each record in a table?
Primary key
2. Name one open-source DBMS.
MySQL
3. What is the extension of a LibreOffice Base file?
.odb
4. In database terminology, what does CRUD stand for?
Create, Read, Update, Delete
5. Which language is used to interact with the database?
SQL (Structured Query Language)
6. What is normalization?
Organizing data to reduce redundancy.
7. What is the default primary key type in most databases?
Integer/Auto-increment
8. Which command is used to insert data into a table?
INSERT
9. Write any one feature of a relational database.
Supports relationships between tables.
10. Is Excel a DBMS? (Yes/No)
No, because it does not manage relational databases.
✅ More 2-Mark Questions:
1. What is meant by data duplication? How does DBMS prevent it?
Repeating data unnecessarily. DBMS uses primary keys and normalization to prevent it.
2. Differentiate between manual and electronic databases.
Manual: Paper-based, slow.
Electronic: Computer-based, fast.
3. What are the roles of a database administrator (DBA)?
Manages, maintains, and secures the database.
3
4. Write any two features of LibreOffice Base.
◦ Open-source
◦ GUI for creating forms, reports, queries
5. Give two examples where databases are used in real life.
◦ Online banking
◦ School management systems
6. What is a data type? Name two data types in DBMS.
Type of data stored. Examples: Integer, Text
7. What are constraints in a database?
Rules to ensure data integrity, like NOT NULL, UNIQUE.
8. Differentiate between “Save” and “Save As” in Base.
◦ Save: Saves changes to the current file.
◦ Save As: Saves a copy with a new name/location.
9. What is meant by data validation in databases?
Ensuring entered data meets specific criteria.
10. What are relationships in a relational database?
Links between tables using keys (like foreign key).
✅ More 3-Mark Questions:
1. Explain any three components of DBMS.
◦ Data
◦ DBMS Engine
◦ Query Processor
2. Difference between physical and logical view of data?
◦ Physical: How data is stored.
◦ Logical: How users view data.
3. Structure of a table with example:
Table: STUDENTS
Fields: ID (Integer), Name (Text), Class (Text), Marks (Integer)
4. Write a short note on "Data Security" in DBMS.
Prevents unauthorized access using passwords, roles, and encryption.
5. How does DBMS help in decision making?
Provides accurate and timely data for analysis.
4
6. Create a table STUDENTS with fields:
◦ ID: Integer (Primary Key)
◦ Name: Text
◦ Class: Text
◦ Marks: Integer
7. Explain the need for relationships between tables.
To connect related data from different tables and avoid duplication.
8. Difference between database and spreadsheet:
◦ Spreadsheet: Limited to single table
◦ Database: Supports multiple linked tables
9. Three features of ideal DBMS:
◦ Scalability
◦ Security
◦ Data integrity
10. Steps to create table in Base:
Open Base > Create Table in Design View > Add Fields > Set Primary Key > Save
