Class X-Information

Technology(Code:402)
Unit 3- Database Management System
Objective Type Questions
1. Some raw facts, figures and textual contents known as ___________.

Data

2. The meaningful data is known as _______________

Information

3. Data help us to take decision. (True/False)

4. The ___________ refers to collection of data and information in organized

manner.

Database

5. Which of the following refers to reducing the duplicate values in a table?

a) Data Redundancy b) Data Integrity

c) Data Security d) Data Consistency

6. In DBMS, user cannot work on a single database at a time. (True/False)

7. The ______________ are dedicated computers which holds the actual database
and run the related database software.

Database Servers

8. The database server’s database can be accessed through command lines of

interface is known as ______________

Front End
9. The Database servers can be referred as Backend. (True/False)

10. The ____________ feature of database give access to only the authorized users.

Data Security

11. The Ultimate Database Solution is a company that provides database services to
users. In a particular database few users can access certain database files. This
feature is called ___________.

Privacy

12. When user do changes in a database is reflected to every user of the database.
This feature is known as __________

a) Data Privacy b) Data Redundancy

c) Data Consistency d) Data Security

13. A set of information made by various fields is known as _____________.

record

14. The data available in the form of text, numeric or date in the table is known as
__________

value

15. The database can have multiple tables. (True/False)

16. A ___________ is a field or column name that identifies records uniquely.

Primary Key

17. The columns which is referenced by another table column through a primary key
is known as ___________.

Foreign Key

18. A table in a database cannot have more than one primary key. (True/False)

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

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

20. Which of the following is NOT a DBMS?

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

21. DBMS stands for ______________________.

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

22. Which of the following data models sets a relation between two or more tables?
(a) Relational Data Model
(b) Network Data Model
(c) Hierarchical Data Model
(d) Connection Data Model

23. The details associated with an entity are called____________.

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

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

(a) field
(b) attribute
(c) record
(d) candidate key
25. In which of the following forms can a data value be represented?
(a) Numeric
(b) Character
(c) Alphanumeric
(d) All of the above

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

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

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

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

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

B. State whether the following statements are True or False

29. A database cannot be organised. –False
30. Data is the collection of raw facts.-True
31. A table can be created without a primary key.-False.
32. Two tables can be related in a network data model.-False
33. MS Access is an example of a database.-False

C. Fill in the blanks

34. The raw facts constitutes _____________.
Data

35. An _____________ is a real world object about which information is to be stored

in a database
Entity
36. The output of a query may be displayed in the form of ________.
Report

37. The data values for all the fields related to a person or object is called a
________.
Record

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

39. Which of the following is NOT a type of text data type?

(a) Memo
(b) Varchar
(c) Float
(d) Char

40. A currency data type can only store monetary data that is in dollars.
(a) True
(b) False
(c) Neither a nor b
(d) Both a and b

41. Which of the following data can a date data type store?
(a) Date
(b) Time
(c) Both date and time
(d) Neither date nor time

42. Which of the following is true about LibreOffice Base?

(a) It is a spreadsheet software
(b) It is free and open source software
(c) It can store only character data
(d) It is a licensed software

43. Which of the following methods can be used to create a table in Base?
(a) Using a table wizard
(b) Design View
(c) Both a and b
(d) Neither a nor b
44. The related objects of a database can be seen in ____________ pane of the
Base Database window.
(a) Database
(b) Task
(c) Title Bar
(d) Menu Bar

45. Which is the shortcut key to open an existing database?

(a) Ctrl+ D
(b) Ctrl+O
(c) Ctrl+E
(d) Ctrl+F

46. The Design view of the Table Creation window in LibreOffice Base is divided into
______ sections or panes.
(a) 2
(b) 3
(c) 4
(d) 5

47. While entering records in a table, we can move to the next field by pressing the
_________ key.
(a) Tab
(b) Ctrl
(c) Enter
(d) Shift

48. Which of the following is true about the primary key of a table?
(a) Every table must have a primary key
(b) The data values in the primary key field cannot be duplicated.
(c) A primary key field cannot be left blank
(d) All of the above

B. State whether the following statements are True or False

49. The text data can contain special characters.-True
50. Memo data type can be used to store descriptive data.-True
51. A Boolean data type can have two or more than two values.-False
52. We cannot store audio data in LibreOffice Base.-False
53. The properties of a field change according to the data type selected.-True
54. Field description may or may not be entered while designing a table.-True
55. A table once created in a database cannot be edited.-False
56. Sort dialog box can only help to sort data in ascending order.-TRue
 C. Fill in the blanks
57. A data type refers to the type of data that will be stored in that particular field.
Data Type

58. The _____________ data is a combination of letters, numbers or special

characters.
Text

59. ________ data type can be used to store Aadhar number.

Text

60. The __________ data type used to store digitized images.

Binary

61. The shortcut key to save a table is _______________.

Ctrl+S

62. ______________ on the Base Interface Window displays information about the
type of view of the object in the database.
Task Pane

63. A __________ icon appears before the field name indicating that it is a primary
key.
Key

64. The data can be entered in a table only in __________ view.

Data Sheet

65. The black pointing arrow just before the field name in a table is called
____________.
Record Pointer

66. The process of arranging the records in particular order on any filed is called
_______________.
Sorting

67. Which of the following actions can be performed once the tables are created in a
database?
(a) Add a field in a table
(b) Rename a table
 (c) Delete a table
(d) All of the above

68. Which of the following is checked by a DBMS?

(a) Redundancy
(b) Inconsistency
(c) Both (a) and (b)
(d) Neither (a) nor (b)

69. Which of the following is required to set a relationship between the two tables?
(a) Both the tables must be in different databases
(b) Both the tables must have a common field
(c) Both the tables must have the same name
(d) Both tables must be stored in documents folder only.

70. If a record is added in a master table, which of the following is NOT true for
transaction table
(a) The record in the master table is called the master record
(b) The corresponding record in transaction table can only be entered
once.
(c) The record in the transaction table is called the transaction record.
(d) It is possible to add a record in the master table

71. Which type of relationship exists between a student and the subjects studied by
him/her?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) All of the above

72. Which of the following menus contains the Relationship option?

(a) Edit
(b) File
(c) Tools
(d) View
73. The list of tables to be added is displayed in the __________ dialog box in the
Relationship Screen.
(a) Add Tables
(b) Add Databases
(c) Both (a) and (b)
(a) Neither (a) nor (b)

74. In the relationship design screen, the relationship between the two tables is done
using __________ operation.
(a) Click
(b) Double Click
(c) Drag and Drop
(d) Right click

75. Which of the following is NOT an option that can be used to maintain referential
integrity in a database?
(a) No Action
(b) Set NULL
(c) Set Default
(d) Set Value

B. State whether the following statements are True or False

76. Redundancy is preferred in a database.-False
77. In a table, a record for a particular entity should not be repeated.-True
78. A single field should always have only one data value.-False
79. If a table is edited, the records already entered in it are deleted.-False
80. The record in master table should be entered before the corresponding record is
entered in the transaction table -TRue
81. In one-to-many relationship, one specific record of the master table has more
than one corresponding records in the related transaction table.-True
82. The Relationship option is present in the Widows menu.-False
83. In a database, the referential integrity is maintained by the user.-False
84. A relationship is always set between the tables based on a common field.-True
85. If the master record is deleted, the transaction records will always be delete-
False

C. Fill in the blanks

86. A table to be edited is displayed in ___________ view.
Design

87. The most important prerequisite for setting a relationship between the two tables
is that there must be a ________________between them.
Common Field

88. In ________________relationship, one specific record of a master table has one

and only one corresponding record in the transaction table.
One to one

89. ___________________is one of the most common types of relationship between

the tables in a database.
One to one.

90. A record being entered in a _________ table must always exist in a ________
table.
Transaction, Master

91. The principle of _______________helps prevent missing data by keeping

deleted data from getting out of synch.
92. Creating ____________ between tables restricts the user from entering invalid
data in the referenced fields.
Relationship

93. Data integrity is maintained by ______________.

DBMS

94. A relationship between customers and products is an example of

__________________ relationship.
Many to many

95. The __________________ window is used to set relationships between the

tables.
10

96. Which of the following is refer to asking questions from the database?
(a) Report
(b) Table
(c) Query
(d) Database

97. Which of the following are the ways to design a query?

(a) Wizard
(b) Design View
(c) SQL
(d) All of the above

98. Which is a flexible way to create a query?

(a) Wizard
(b) Design View
(c) Both (a) and (b)
(d) Neither (a) nor (b)

99. Into how many parts is the query design window divided?
(a) One
(b) Two
(c) Three
(d) Four
100. Which of the following is NOT true about queries?
(a) It can be created using multiple tables
(b) Multiple queries can be created in a database
(c) A query can run multiple times
(d) A query once created cannot be edited

101. Which of the following is the shortcut key to run the query?
(a) F3
(b) F4
(c) F5
(d) F6

102. Which of the following functions can be performed on numerical data while
designing a query?
(a) Sum
(b) Minimum
(c) Maximum
(d) All of the above

103. In a Query Design wizard, which of the following buttons is clicked to

move a field from ‘Available fields’ list box to ‘Fields in the query‘ list box?
(a) >
(b) < 9
(c) ∨
(d) ∧
104. Which of the following relational operators can be applied to set the
criterion while designing a query in LibreOffice Base?
(a) >
(b) =
(c) !=
(d) Add Form

105. Which of the following dialog box is present when the Query Design
window is opened for the first time to design a query?
(a) Add Table
(b) Add Query
(c) Add Table or Query
(d) None of the above
106. Which of the following step is not performed if there is no numerical data
to be worked upon in a query?
(a) Selection of fields
(b) Giving Aliases
(c) Summarizing
(d) Selection of tables

State whether the following statements are True or False

107. You can run a query only once –False

108. A query cannot be created from multiple tables-False
109. The shortcut key to run a query is F5.-True
110. LibreOffice Base provides us with two ways to create a query.-False
111. A query with numerical data cannot be saved.-False
112. By default the query result is not sorted.-True
113. A query can be used to display the average value of a numerical field.
True
114. While designing a query, the criterion can be set on only one field.-True
115. Alias is an alternative name for a field in a query.-False
116. In query Design window, the visible check box is selected by default.-True
117. A query once created using a wizard can only be edited in the Design
view.-TRue

C. Fill in the blanks

118. A ____________ is a sort of question asked from a database.
Query

119. The result of the query is displayed in ____________ form with field
names in columns
Report

120. A query can be created in ________ways.

3

121. The Query Design window is divided into __________ sections.

2
122. The shortcut key to run the query is ______________.
F5

123. The conditions to filter the records are set in the _________ row.
Criterion

124. When a table is selected in a Query wizard, the corresponding

fields are displayed in the__________________list box.
Available fields

125. The result of the query can be displayed in __________ or

_____________ order of any particular field of the table.
Ascending, descending

126. At the most __________ search conditions can be given in the query
wizard.
3

127. The last step of the Query wizard displays the entire
____________ of the query.
Overview

128. The _____________ view is a more flexible method to create a query.

Design

129. To edit any query, right click on the ________ icon of the query that has
to be edited.
Query

130. In the _____________ row of the Query Design grid, we can type the
column heading that will be displayed instead of field name when we run the
query
Alias
131. Which of the following toolbars contains the Label tool?
(a) Standard Toolbar
(b) Forms Controls Toolbar
 (c) Records toolbar
(d) Formatting toolbar

132. The Record toolbar has the buttons to move to the

(a) first record
(b) second record
(c) last record
(d) all records

133. Which of the following is NOT true about forms?

(a) It is the front end for data entry
(b) It can contain only text fields
(c) Graphics can be inserted on the form
(d) It can contain only fixed number of records

134. Which of the following keys is pressed to select only the textbox on the
form?
(a) Alt
(b) Shift
(c) Ctrl
(d) Tab

135. Which of the following properties in the Properties: Label Field text box is
used to insert a tool-tip on the form?
(a) Tool Text
(b) Help Text
(c) Tool Tip
(d) Help Tip

136. Which of the following objects of LibreOffice Base is used to display data
retrieved from one or more tables in a presentable manner?
(a) Query
(b) Form
(c) Report
(d) Panel

137. Which of the following values of Date Format property is selected to view
a calendar on the form?
(a) Standard (short)
(b) Standard (long)
(c) Default
(d) Standard (Medium)
138. Which of the following commands on the Forms Control toolbar is used to
toggle between Design View and Form view?
(a) Design Mode
(b) Toggle Mode
(c) View Mode
(d) Print mode

139. Using which of the following objects in a database, can a report be

generated?
(a) Tables
(b) Queries
(c) Both a and b
(d) Neither a nor b

140. Which of the following components open along with the Report Wizard?
(a) Report Builder
(b) Add Fields dialog box
(c) Both (a) and (b)
(d) Neither (a) nor (b)

B. State whether the following statements are True or False

141. Report is an object of a database but form is not.-False

142. We can choose the layout of the form.-True
143. We have to add all fields of the table on the form.-False
144. There are two ways n which a form can be created.-True
145. A report is generated in a separate window.-True
146. Once a control is added on to the form, it cannot be repositioned.-False
147. The Record toolbar has the button to add a new record.-True
148. We can create a report only using a table.-False
149. By default, the records in a report are sorted in descending
order.-False
150. . We can group data based on a particular field in a report.- True
151. A report can have data only in row and column format.False
152. We can insert both date and time of generation of report.-True
153. A report once created cannot be edited.-Fale

C. Fill in the blanks

 154. A form can be used for ____________ and _____________.
Enter, View data
155. Each field control consists of a ____________and
________________
Label, Field Value
156. A ________________ is a piece of text that specifies the data
that should be entered in the field value text box.
Label
157. By default the border of the field text value is displayed in
_________.
3D
158. A ____________ is a small piece of text that is displayed when the
mouse pointer is placed on a particular control on the form.
Tool tip
159. The default orientation option for a report is _______________.
Landscape
160. A ____________ is the manner in which the labels, field
values, titles etc. will be displayed in the report.
Layout
161. The option to insert date and time in the report is present in ______menu.
Insert
162. A Report Wizard contains _____________ steps.
6
163. A _______ type of report changes automatically as the field
values in the base table or query change.
Dynamic

Short Answer Questions (2 Marks)

1. Identify data and information from the following:

1. A student data like 111, “Saumya”, 80%

2. Roll No – 112, Student Name-Saumya, Score – 80%
3. Mr. Subodh, Ahmedabad, 35000
4. Mr. Subodh is living in Ahmedabad and his monthly income is 35000.

Ans.:
1. Data
2. Information
 3. Data
4. Information

2. Elaborate database with an example.

Ans.: Suppose a school is having data of studetns. These data should be maintained properly
so as and whenever information required for a particular student(s), it should be available easily.
All records like fees, marks and other details shoudl be available as and when required.
Database can store these all information into a single database.

3. Elaborate DBMS with suitable examples.

Ans. : Suppose you are working in school. Now you want to maintain staff salary and
attendence data. So you need staff details and salary details and attendance data. So you need
multiple tables for the same.

4. What are the features of a primary key?

Ans.: The features of primary key are as follows:

1. It identifies rows uniquely.
2. It should not have duplicate value.
3. It sould not have null value.
4. There is only one primary key on table.
5. Write a few examples of DBMS packages. (At least 4 names required in 2 Marks)
Ans.:
1. Oracle
2. MySQL
3. SQL Server
4. OpenOffice Base

Long answer questions (4 Marks Questions)

6. What are the features of the database? Explain in short with examples.

Ans.: The features of database are as follows:

1. Multiple Tables: A database can have multiple tables. As an organization can have
different tables such as customers, suppliers, orders etc.
2. Contains information of one item: Each table in datanase contains information
about one type of item. So a database is a container that holds tables and other
objects and manages how they can be used.
3. Record uniqueness: A database can have multiple tables. These tables needs
some unique records to identify the entity. It is important to be able to distinguish
between different items having duplicate values.
7.What are the advantages of DBMS?

a) A Database Management System (DBMS) is software that helps users create,

manage, and manipulate databases. It allows for efficient data storage, retrieval,

and organization.

b) Advantages of using DBMS:

● Data Integrity: Ensures accuracy and consistency of data.

● Data Security: Provides access controls to protect sensitive information.

● Reduced Data Redundancy: Minimizes duplication of data across the

database.

● Data Management: Simplifies data handling through structured query

language (SQL).

8.a) What is the use of form in DBMS?

b) What are the different ways to create forms in DBMS?

c) Where can we find various tools to add or edit controls on the form?

d) What is the use of the Records Toolbar in a form?

a) A form is an object of the database that has a user-friendly interface where

data can be entered and seen in an attractive and easy-to-read format. For any

database, it is the front end for data entry and data modification

b) There are two ways to create a form: • Using a wizard • Using the Design View

c) Forms Control Toolbar

d) The Records toolbar contains the navigation control buttons in the extreme

left. With the help of these buttons, we can traverse and view the records in the

file
9.Your cousin runs a small bookstore and wants to maintain an inventory of

books. He needs to record information such as book titles, authors, ISBNs,

publication dates, prices, and stock levels. However, he is not familiar with

database management systems. Explain the following concepts to help him

understand DBMS:a) What is DBMS?

b) What are the advantages of using DBMS?

c) Name any two database programs that can be used to create a table

and store the data according to his requirements.

d) Which field can be set as a Primary Key?

a) A Database Management System (DBMS) is software that helps users create,

manage, and manipulate databases. It allows for efficient data storage, retrieval,

and organization.

b) Advantages of using DBMS:

● Data Integrity: Ensures accuracy and consistency of data.

● Data Security: Provides access controls to protect sensitive information.

● Reduced Data Redundancy: Minimizes duplication of data across the

database.

● Data Management: Simplifies data handling through structured query

language (SQL).

c)Two database programs:

● MySQL

● Open Office Base

d) The ISBN (International Standard Book Number) can be set as a primary key,