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 _____________.
Data
2. An _____________ is a real world object about which information is to be stored in a database.
Entity
3. The output of a query may be displayed in the form of ________.
Report
4. The data values for all the fields related to a person or object is called a _________.
Record
5. All the field values that are eligible to be the primary key are the ___________ keys for that table.
Candidate
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
Answer:
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
Answer:
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
Answer:
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.
Answer:
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
(a) Name the fields in the given table.
Answer:
– 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