Database Management System Question Answer Class 10

A. Multiple choice questions

1. Which of the following can be considered as an example of a database?

(a) Dictionary
(b) Telephone directory
(c) Marks Register
(d) Newspaper

Answer:(b) Telephone directory


2. Which of the following is NOT a DBMS?

(a) MS Access
(b) Open Office Base
(c) MS Excel
(d) MySQL

Answer:(c) MS Excel


3. DBMS stands for ______________________.

(a) Data and Books Management System
(b) Database Management System
(c) Duplicate Books Management System
(d) Data Management Multi System

Answer:(b) Database Management System


4. Which of the following data models sets a relation between the two or more tables?

(a) Relational Data Model
(b) Network Data Model
(c) Hierarchical Data Model
(d) Connection Data Model

Answer:(a) Relational Data Model


5. The details associated with an entity are called ____________.

(a) Table
(b) Attributes
(c) Records
(d) Primary key

Answer:(b) Attributes

Database Management System Question Answer Class 10 IT

6. A __________ is represented as rows in a table.

(a) field
(b) attribute
(c) record
(d) candidate key

Answer:(c) record


7. In which of the following forms can a data value be represented?

(a) Numeric
(b) Character
(c) Alphanumeric
(d) All of the above

Answer:(d) All of the above


8. Which of the following uniquely identifies a row in a table?

(a) Primary key
(b) Alternate key
(c) Foreign key
(d) Candidate key

Answer:(a) Primary key


9. A ___________is a feature of a database using which we can enter data in a table in an easy and user friendly manner.

(a) query
(b) report
(c) form
(d) field

Answer:(c) form


10. A _____________ is a question asked from a database.

(a) query
(b) report
(c) form
(d) field

Answer:(a) query

Database Management System Question Answer Class 10

B. State whether the following statements are True or False

1. A database cannot be organised. [False]

2. Data is the collection of raw facts. [True]

3. A table can be created without a primary key.[False]

4. Two tables can be related in a network data model.[False]

5. MS Access is an example of a database.[False]

Database Management System Question Answer Class 10 IT

C. Fill in the blanks

1. The raw facts constitutes _____________.



2. An _____________ is a real world object about which information is to be stored in a database.



3. The output of a query may be displayed in the form of ________.



4. The data values for all the fields related to a person or object is called a _________.



5. All the field values that are eligible to be the primary key are the ___________ keys for that table.


Database Management System Question Answer Class 10

D. Answer the following questions

1. Define the terms

(a) Database

Answer:  A database is an organized collection of structured data stored electronically in a computer system. It allows for efficient retrieval, insertion, and management of data.


(b) Data redundancy

Answer: Data redundancy refers to the unnecessary repetition of data within a database or data storage system. This can lead to inconsistencies and increased storage costs.

(c) Report

Answer: A report is a formatted and organized presentation of data extracted from a database, typically used for analysis, decision-making, and communication of information.

Database Management System Question Answer Class 10 IT

2. Give one point of difference between

(a) Data and Information


Data: Raw, unprocessed facts and figures without context (e.g., numbers, dates).

Information: Processed data that is meaningful and useful for decision-making (e.g., a sales report derived from raw sales data).


(b) Form and Query


Form: A user interface in a database that allows users to enter and modify data easily.

Query: A request to retrieve specific data from a database, often using a structured query language (SQL).


(c) Network and hierarchical data model


Network Data Model: Data is organized in a graph, allowing many-to-many relationships. It is more flexible in representing complex relationships.

Hierarchical Data Model: Data is organized in a tree-like structure, where each child record has only one parent, representing a one-to-many relationship.

Database Management System Question Answer Class 10 IT

3. Give any four advantages of a DBMS.


i) Data Integrity and Accuracy: Ensures data is accurate, consistent, and reliable by enforcing rules and constraints.

ii) Data Security: Provides robust security features to control access and protect data from unauthorized access.

iii) Data Redundancy Elimination: Minimizes data redundancy by ensuring data is stored only once, reducing storage costs and inconsistencies.

iv) Efficient Data Management: Facilitates efficient data retrieval, updates, and management through optimized query processing and indexing techniques.


4. Consider the table given below and answer the questions that follow

Table: Library

Database Management System Question Answer Class 10
(a) Name the fields in the given table.


– Book_Id
– Book Name
– Author Name
– Price
– Publisher

(b) Which field should be made the primary key?

Answer: The Book_Id field should be made the primary key because it uniquely identifies each record in the table.


(c) Is there any alternate key in the table?

Answer:  An alternate key is a field (or combination of fields) that can be used to uniquely identify records but is not chosen as the primary key. In this case, Book Name could serve as an alternate key if every book has a unique name.

(d) How is primary key different from foreign key? Explain with example.


You May also Check:

Class 10 IT 402 Chapter wise Important Questions

Unit 1: Digital Documentation (Advanced) using LibreOffice Writer

Chapter 1: Introduction to Styles

Chapter 2: Working with Images

Chapter 3: Advanced Features of Writer


Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc

Chapter 4: Analyse Data using Scenarios and Goal Seek

Chapter 5: Using Macros in Spreadsheet

Chapter 6: Linking Spreadsheet Data

Chapter 7: Share and Review a Spreadsheet


Unit 3: Database Management System using LibreOffice Base

Chapter 9: Starting with LibreOffice Base

Chapter 10: Working with Multiple Tables

Chapter 11: Queries in Base

Chapter 12: Forms and Reports


Unit 4: Maintain Healthy, Safe and Secure Working Environment

Chapter 13: Health, Safety and Security at Workplace

Chapter 14: Workplace Quality Measures

Chapter 15: Prevent Accidents and Emergencies

Copywrite © 2020-2024, CBSE Python,
All Rights Reserved
error: Content is protected !!