Here is a collection of Previous Year Questions (PYQs) for CBSE Class 10 Information Technology (Subject Code: 402) – Unit 3: Database Management System (DBMS).
1-Mark Questions (Objective / Very Short Answer)
1. In OpenOffice Base, the relationship applied on the tables can be removed with the help of ______ option.(CBSE 2024)
Answer: Delete
2. Identify the numeric data type which can store Yes/No type values in the form of 0 or 1 in an OpenOffice Base table.(CBSE 2024)
Answer: Boolean
3. In SQL, which keyword is used to display records in ascending order?(CBSE 2023)
Answer: ASC
4. Identify the property which helps to set the maximum number of characters in a text/varchar type field of a table in DBMS.(CBSE Sample Paper 2023)
Answer: Length
5. What is the default data type assigned to fields in OpenOffice Base?(CBSE 2022)
Answer: Text [Varchar]
2-Mark Questions (Short Answer Type I)
1. Define Database and DBMS.(CBSE 2018, 2020, 2022)
Answer:
Database: An organized collection of related data stored systematically so it can be easily accessed and managed.
DBMS: A software package used to create, store, update, and manage databases efficiently (e.g., MS Access, MySQL).
2. Differentiate between a Flat File Database and a Relational Database.(CBSE 2023)
Answer:Feature Flat File DatabaseRelational Database (RDBMS)Storage StructureData is stored in a single table.Data is stored across multiple linked tables.Data CapacityBest suited for small amounts of data.Highly efficient for handling large, complex data.
3. What is a Primary Key? State its significance.(CBSE 2021, 2023)
Answer: A Primary Key is a unique field or combination of fields that uniquely identifies each row or record in a database table. Its significance is that it ensures data cannot have duplicate rows and prevents null values within that identifying field.
3-Mark Questions (Short Answer Type II)
1. Explain any three advantages of using a Database Management System.(CBSE 2020, 2024)
Answer:
Reduces Data Redundancy: It minimizes data duplication by storing information in a centralized location.
Improves Data Integrity: Centralized tracking ensures that data remains accurate, valid, and consistent across multiple files.
Enhanced Data Security: Allows database administrators to restrict unauthorized access by enforcing user authentication and specific viewing privileges.
2. Define the following table terms with respect to RDBMS:
(i) Tuple (ii) Attribute (iii) Relation(CBSE 2022)
Answer:
(i) Tuple (Row): Represents a single, unique data record or item within a database table.
(ii) Attribute (Column): A vertical field that holds a specific type of data value for each row in the table.
(iii) Relation (Table): A collection of organized data structured into vertical columns and horizontal rows.
4-Mark Questions (Long Answer Type)
1. What is SQL? Differentiate between DDL and DML commands with examples.(CBSE 2022, 2024)
Answer:SQL (Structured Query Language) is the standard language used to communicate with, manage, and manipulate relational databases.
DDL (Data Definition Language): Used to define, modify, or destroy the physical structure of database objects like tables.
Examples: CREATE, ALTER, DROP.
DML (Data Manipulation Language): Used to manage, retrieve, and manipulate the actual data stored within those database structures.
Examples: SELECT, INSERT, UPDATE, DELETE.
2. What are relationships in a database? Explain the three types of relationships that can be created in a Relational Database.(CBSE 2023)
Answer: A relationship links data from multiple tables by matching fields (usually primary and foreign keys) to establish data connections. The three main types are:
One-to-One (1:1): A record in Table A is linked to exactly one record in Table B, and vice versa. (e.g., A Department and its single Department Head).
One-to-Many (1:M): A single record in Table A can relate to multiple records in Table B, but a record in Table B points back to only one in Table A. (e.g., One Customer making multiple Orders).
Many-to-Many (M:N): Multiple records in Table A can relate to multiple records in Table B. This requires an intermediary junction table. (e.g., Multiple Students registering for multiple Courses).