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
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]
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
(b) Data redundancy
(c) Report
2. Give one point of difference between
(a) Data and Information,
(b) Form and Query,
(c) Network and hierarchical data model
3. Give any four advantages of a DBMS.
4. Consider the table given below and answer the questions that follow
Table: Library
(a) Name the fields in the given table.
(b) Which field should be made the primary key?
(c) Is there any alternate key in the table?
(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