Class 10 IT Chapter 8 Introduction to Database Management System Questions Answers

Class 10 IT Chapter 8 Introduction to Database Management System Questions Answers

Dear students, please go through the exercise solutions available in this page titled class 10 IT chapter 8 Introduction to Database Management System Questions Answers from Domestic Data Entry Operator book published by NCERT.

Check Your Progress

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

Ans: (b) Telephone directory

2. Which of the following is NOT a DBMS?
(a) MS Access
(b) Open Office Base
(c) MS Excel
(d) MySQL

Ans: (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

Ans: (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

Ans: (a) Relational Data Model

5. The details associated with an entity are called ___.
(a) Table
(b) Attributes
(c) Records
(d) Primary key

Ans: (b) Attributes

6. A _______ is represented as rows in a table.
(a) field
(b) attribute
(c) record
(d) candidate key

Ans: (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

Ans: (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

Ans: (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

Ans: (c) form

A _______ is a question asked from a database.
(a) query
(b) report
(c) form
(d) field

Ans: (a) query

B. State whether the following statements are True or False

1. A database cannot be organised. Ans: False

2. Data is the collection of raw facts. Ans: True

3. A table can be created without a primary key. Ans: False

4. Two tables can be related in a network data model. Ans: False

5. MS Access is an example of a database. Ans: False

Class 10 IT Chapter 8 Introduction to Database Management System Questions Answers

C. Fill in the blanks

1. The raw facts constitutes _______ .

Ans: Data

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

Ans: Entity

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

Ans: Report

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

Ans: Record

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

Ans: Candidate

D. answer the following questions :

1. Define the terms

(a) Database

(b) Data redundancy

(c) Report

Ans: (a) Database : A Database is a collection of logically related data items stored in an organized manner.  The information stored in a database can be modified, retrieved, displayed and deleted according to the requirement of the user.

Ans: (b) Data redundancy : Data redundancy is a term which means that the same data field appears in multiple tables in a database. It means data duplicacy.

Ans: (c) Report : Report is one of the objects of a relational Database Management System (RDBMS). The output of a query can be displayed in the form of report in a database.

2. Give one point of difference between

(a) Data and Information

(b) Form and Query

(c) Network and hierarchical data model

Ans: (a) Data and Information : Data means raw facts. It may or may not have any meaning Whereas Information is the processed or organized form of data.

Ans: (b) Form and Query : A Form is one of the objects of a database which is used to enter data in a table in an easy and user friendly manner whereas a Query is one of the objects of a database which is used to retrieve the required information from the database. 

Ans: (c) Network and hierarchical data model : In  Network data model multiple records are linked to same master file. It is considered as an inverted tree whereas in hierarchical data model the data is organized into a tree like structure. The data is stored in the form of records.

3. Give any four advantages of a DBMS.

Ans: Four advantages of DBMS are –

i. Security : A database provides security. It prevents unauthorized access by assigning passwords to the users.  

ii. Organized storage : The data in a database is stored in an organized manner.

iii. Data Analysis : A database helps in analysis of data based on certain criteria.

iv. Data Sharing : A database allows data sharing. If the same data is required for multiple applications, the database can be shared with those applications.

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

Table : Library

Book_ID	Book_Name	Author_Name	Price	Publisher
F001	Pride and Prejudice	Jane Austen	550	ABC
S004	Amazing Astronomy	E. Shane	1050	ABC
C005	IT and Mankind	MHA Diwaan	2500	HYM

(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.

Ans: (i) Book_ID, Book_Name, Author_Name, Price, Publisher

Ans: (ii) Book_ID should be made the primary key.

Ans: (iii) yes. Book_Name is an alternate key in the table.

Ans: (iv) A Primary is a field or an attribute which uniquely identifies each tuple or record in a table whereas a foreign key is a field or an attribute which refers to the value of an attribute acts as a primary key in another table.