Database Management System MCQs - Class 10 IT (402)

We have prepared this Database Management System MCQs Set with a wide variety of questions, strictly aligned with the latest CBSE syllabus and based on previous years’ board exam patterns and commonly asked question types.

DBMS MCQs are very important for your Class 10 IT (402) exam as this chapter carries good weightage. So, give it special attention and practise all the questions with full focus.

Keeping this in mind, we have created this question set with different types of MCQs to help you understand the question patterns, test your knowledge, and prepare better for your CBSE exam. 🎯

Q1. A school stores students’ names, roll numbers, marks and attendance in an organised collection. What does this collection represent?
a) Spreadsheet
b) Database
c) Presentation
d) Operating system

Q2. A teacher records individual marks obtained by students. Later, the school generates a consolidated report card. Which statement correctly identifies these two items?
a) Both are information
b) Both are raw data
c) Marks are data, while the report card is information
d) Marks are information, while the report card is data

Q3. Assertion (A): VARCHAR allocates memory according to the number of characters entered.
Reason (R): CHAR stores exactly the length specified by the user.
a) Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct explanation of Assertion (A)
b) Both Assertion (A) and Reason (R) are true, but Reason (R) is not the correct explanation of Assertion (A)
c) Assertion (A) is true, but Reason (R) is false
d) Assertion (A) is false, but Reason (R) is true

Q4. Assertion (A): A one-to-many relationship allows one record in one table to be associated with multiple records in another table.
Reason (R): In a one-to-one relationship, one specific record in one table is related to one specific record in another table.
a) Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct explanation of Assertion (A)
b) Both Assertion (A) and Reason (R) are true, but Reason (R) is not the correct explanation of Assertion (A)
c) Assertion (A) is true, but Reason (R) is false
d) Assertion (A) is false, but Reason (R) is true

Q5. Statement 1: Data consists of raw facts that may relate to a person, place, activity or thing.
Statement 2: Information is the unprocessed form of data.
a) Statement 1 is True and Statement 2 is False
b) Statement 1 is False and Statement 2 is True
c) Both Statement 1 and 2 are True
d) Both Statement 1 and 2 are False

Q6. Statement 1: The hierarchical data model organises data in a tree-like structure.
Statement 2: The network data model links multiple records to the same master file.
a) Statement 1 is True and Statement 2 is False
b) Statement 1 is False and Statement 2 is True
c) Both Statement 1 and 2 are True
d) Both Statement 1 and 2 are False

Q7. A collection of logically related data items stored in an organised manner is called a
a) Query
b) Form
c) Report
d) Database

Q8. The software used to create, update and retrieve data is known as
a) DBMS
b) Data model
c) Report
d) Entity

Q9. Which of the following is NOT an example of a DBMS?
a) MySQL
b) Oracle
c) LibreOffice Base
d) MS Excel

Q10. When the same data field is repeated in a number of tables, it is called
a) data sharing
b) data redundancy
c) data validity
d) data security

Q11. A student’s name is changed in one table but remains unchanged in another table. The database now suffers from
a) data inconsistency
b) data encryption
c) data sharing
d) data analysis

Q12. Translating data in such a manner that unauthorised users cannot read it is called
a) sorting
b) compilation
c) validation
d) encryption

Q13. A database administrator wants to identify the highest and lowest marks obtained by students. Which advantage of DBMS is particularly useful?
a) Data encryption
b) Data analysis
c) Data sharing
d) Data entry

Q14. An organisation uses the same employee information in its payroll and attendance applications without creating separate copies of the database. Which DBMS advantage is demonstrated?
a) Data sharing
b) Data deletion
c) Data formatting
d) Data encryption

Q15. A school restricts the fee amount entered into a database to values greater than ₹1,000. Which DBMS advantage is being used?
a) Data sharing
b) Data validity
c) Data redundancy
d) Data retrieval

Q16. A database administrator assigns passwords and encrypts stored information to prevent unauthorised access. Which DBMS advantage is demonstrated?
a) Efficiency
b) Accuracy
c) Security
d) Consistency

Q17. In which data model is data organised in a tree-like structure with records linked at various levels?
a) Network
b) Relational
c) Hierarchical
d) Connection

Q18. The most commonly used database model is the
a) Hierarchical
b) Network
c) Tree
d) Relational

Q19. The Relational Database Model was proposed in the year
a) 1960
b) 1970
c) 1980
d) 1990

Q20. Who proposed the Relational Database Model in 1970?
a) Charles Babbage
b) E. F. Codd
c) Bill Gates
d) Tim Berners-Lee

Q21. In the relational model, relations between tables are set on the basis of
a) table names
b) number of records
c) common fields
d) file size

Q22. A real-world object about which information is stored in a database is called a(n)
a) record
b) key
c) report
d) entity

Q23. Admission number, roll number and name are associated with the entity Student. These details are called
a) attributes
b) tables
c) objects
d) queries

Q24. The smallest entity in a database is a
a) table
b) record
c) field
d) database

Q25. In an Employee table with fields Name, Designation and Department, the values (‘Abhinav’, ‘Manager’, ‘Finance’) form one
a) field
b) record
c) table
d) key

Q26. Which of the following is NOT true about a primary key?
a) It uniquely identifies a row
b) No two rows can have the same value in it
c) It can be formed using more than one field
d) It can be left blank

Q27. A key formed by using more than one field to identify a record is called a
a) composite key
b) foreign key
c) alternate key
d) master key

Q28. In the Student Marks table, the field Enrolment Number is used to set a relation with the Student Registration table, where it is the primary key. In the Student Marks table it is called the
a) composite key
b) foreign key
c) alternate key
d) master key

Q29. Roll Number and Admission Number are both eligible to be the primary key, and Roll Number is chosen. Admission Number is then called the
a) foreign key
b) composite key
c) alternate key
d) record key

Q30. A table has the columns Item No., Name, Price, Quantity and Discount (in %), and three rows of data. It has
a) 3 fields and 5 records
b) 5 fields and 5 records
c) 3 fields and 3 records
d) 5 fields and 3 records

Q31. A school assigns a unique roll number to every student. Which database field should be selected as the primary key?
a) Student Name
b) Class
c) Roll Number
d) Father’s Name

Q32. Which object of an RDBMS is used to retrieve data such as the names of only those students who scored more than 50 marks?
a) Query
b) Form
c) Table
d) Report

Q33. LibreOffice Base is
a) a spreadsheet package
b) a licensed DBMS
c) a free and open source DBMS
d) a word processor

Q34. The type of data to be stored in a field is specified by its
a) record
b) key
c) label
d) data type

Q35. Which data type holds a combination of letters, numbers or special characters on which no arithmetic calculation can be performed?
a) Text
b) Currency
c) Numeric
d) Boolean

Q36. Descriptive data of more than 255 characters, up to 64,000 characters, is stored using the
a) Char data type
b) Memo data type
c) Varchar data type
d) Tinyint data type

Q37. An address field is defined as VARCHAR(50). A user enters an address of 20 characters. How many bytes are occupied in the database?
a) 20
b) 30
c) 50
d) 70

Q38. Which numeric data type is unsigned and has the range 0 to 255?
a) SMALLINT
b) INTEGER
c) BIGINT
d) TINYINT

Q39. Monetary values such as $100, £500 or Rs. 25.50 are stored using the ______ data type.
a) Numeric
b) Currency
c) Text
d) Binary

Q40. Which date data type stores date and time information at once?
a) Date
b) Time
c) Timestamp
d) Binary

Q41. The Boolean data type can hold
a) any number of values
b) only text
c) only images
d) only two values such as Yes/No

Q42. Photographs of employees or voice messages can be stored in a Base database using the ______ data type.
a) Binary
b) Boolean
c) Memo
d) Date

Q43. A school wants to record the exact time at which a student submits an assignment. Which data type is appropriate?
a) Date
b) Time
c) CHAR
d) Memo

Q44. A database created in LibreOffice Base is saved with the extension
a) .odt
b) .ods
c) .odp
d) .odb

Q45. Which of the following is NOT a menu item on the Base menu bar?
a) Format
b) Insert
c) Tools
d) Window

Q46. What is the default name assigned to a database if no name is provided during saving, as mentioned in the textbook?
a) NewDatabase.odb
b) NewDatabase.xlsx
c) Database1.docx
d) Untitled.pptx

Q47. The shortcut keys to open an existing database and to save a table are respectively
a) Ctrl+S and Ctrl+O
b) Ctrl+D and Ctrl+S
c) Ctrl+E and Ctrl+O
d) Ctrl+O and Ctrl+S

Q48. Which component of the Base interface displays the name of the database and the application?
a) Menu Bar
b) Status Bar
c) Title Bar
d) Standard Toolbar

Q49. Which interface component contains File, Edit, View, Insert, Tools, Window and Help?
a) Title Bar
b) Menu Bar
c) Status Bar
d) Database Pane

Q50. Which component is located below the Menu Bar and provides access to frequently used tools?
a) Standard Toolbar
b) Status Bar
c) Database Pane
d) Object Area

Q51. Which component displays information about the type of view of the selected database object?
a) Title Bar
b) Status Bar
c) Menu Bar
d) Task Pane

Q52. In the LibreOffice Base interface, where are Tables, Forms, Queries and Reports displayed as database objects?
a) Title Bar
b) Database Pane
c) Status Bar
d) Menu Bar

Q53. Which two methods can be used to create a table in LibreOffice Base?
a) Wizard and Design View
b) Form and Report
c) Query and Report
d) Datasheet and Form only

Q54. Properties such as Entry required, Length, Default value and Format example appear in the
a) Menu Bar
b) Status Bar
c) Field Properties pane
d) Navigation box

Q55. To create a composite key, the user keeps the ______ key pressed while clicking on the fields.
a) Ctrl
b) Alt
c) Shift
d) Tab

Q56. While entering data in the datasheet view, the user moves to the next field by pressing
a) Esc
b) Del
c) Tab
d) F5

Q57. The black pointing arrow just before the field name in the datasheet view is called the
a) cursor
b) navigation box
c) edit icon
d) record pointer

Q58. A user changes a value in a record by mistake and wants to restore the original contents. Which key should be pressed?
a) Esc
b) Del
c) Tab
d) Ctrl+S

Q59. Arranging records in ascending or descending order based on a particular field is called:
a) Filtering
b) Sorting
c) Grouping
d) Indexing

Q60. Which of the following can be done to a table after it has been created?
a) Add a field
b) Remove a field
c) Alter field properties
d) All of the above

Q61. The main purpose of setting relations between tables is to
a) increase the file size
b) control data redundancy and inconsistency
c) hide the tables
d) change data types

Q62. The most important prerequisite for setting a relationship between two tables is that they must have
a) the same table name
b) the same number of records
c) the same number of fields
d) a common field

Q63. A database relationship helps prevent missing data by keeping related records connected. Which concept supports this function?
a) Referential integrity
b) Data formatting
c) Sorting
d) Data entry

Q64. Which relationship allows one record in the first table to be associated with only one record in the second table?
a) One-to-One
b) One-to-Many
c) Many-to-Many
d) Many-to-One only

Q65. A single customer can place several orders, but each order belongs to one customer. Which relationship is represented?
a) One-to-One
b) One-to-Many
c) Many-to-Many
d) No relationship

Q66. Students can enrol in multiple courses, and each course can have multiple students. Which relationship is suitable?
a) One-to-One
b) One-to-Many
c) Many-to-Many
d) One-to-Zero

Q67. The data types of the common field in two tables are different. When the user tries to set the relationship, LibreOffice Base will
a) display an error message and not allow the relationship
b) convert the data type automatically
c) delete the field
d) set the field to NULL

Q68. In the tables Student_Details (primary key Admission No) and Student_Result (primary key Roll No, with the field Admission No), the master table is
a) Student_Result
b) both tables
c) Student_Details
d) neither table

Q69. An Admission No can be entered in Student_Result only if it is already present in
a) Student_Result
b) Student_Details
c) any other table
d) a form

Q70. The relationship between a citizen and his driving licence is
a) many-to-many
b) one-to-many
c) one-to-one
d) not possible

Q71. Which of the following is NOT an advantage of relating tables in a database?
a) It prevents data redundancy
b) It maintains referential integrity
c) It restricts entry of invalid data in referenced fields
d) It increases duplicate records

Q72. The Relationship Design screen is opened using
a) Tools > Relationships
b) File > Open
c) Edit > Relations
d) View > Relationship

Q73. Which option is used to add tables to the Relationship Design window?
a) Add Tables
b) Add Forms
c) Add Reports
d) Add Queries only

Q74. A database designer wants to update related records automatically when a value in the master table changes. Which referential action should be selected?
a) No action
b) Update cascade
c) Set NULL
d) Set default

Q75. Which referential action is the default option mentioned in the textbook?
a) Update cascade
b) Set NULL
c) No action
d) Set default

Q76. The principle that no unmatched foreign key values should exist in the database is called
a) data sharing
b) encryption
c) data analysis
d) referential integrity

Q77. The default option for maintaining referential integrity is
a) Set NULL
b) Set default
c) No action
d) Update cascade

Q78. Which option deletes or updates all related records in the transaction tables along with the master record?
a) No action
b) Update cascade
c) Set NULL
d) Set default

Q79. Which option assigns the NULL value to the related fields when the master record is deleted or updated?
a) No action
b) Update cascade
c) Set default
d) Set NULL

Q80. To open the Relations dialog box and choose a referential integrity option, the user
a) double-clicks the relation line joining the two tables
b) right-clicks the Tools menu
c) presses F5
d) closes the Add Tables dialog box

Q81. A teacher wants to retrieve only those records where students have scored more than 80 marks. Which database object should be used?
a) Form
b) Report
c) Query
d) Table design

Q82. Which of the following is the primary purpose of a query?
a) To create a database password
b) To retrieve specific information based on given criteria
c) To change the operating system
d) To design a presentation

Q83. In LibreOffice Base, how many methods are described for creating a query?
a) One
b) Two
c) Three
d) Four

Q84. Which of the following is NOT a method of creating a query described in the textbook?
a) Using a Wizard
b) Design View
c) SQL View
d) Report View

Q85. Which method provides greater flexibility while designing a query?
a) Wizard
b) Design View
c) Report View
d) Form View

Q86. Which shortcut key is used to run a query in LibreOffice Base?
a) F2
b) F4
c) F5
d) F7

Q87. What is the usual format in which query results are displayed?
a) Paragraph format
b) Tabular format
c) Slide format
d) Image format

Q88. Which button is used to move a selected field from Available Fields to Fields in the Query?
a) >
b) <
c) ∨
d) ∧

Q89. Which row in the Query Design grid is used to specify conditions for filtering records?
a) Field row
b) Table row
c) Criteria row
d) Alias row

Q90. A user wants to retrieve records where Points are greater than 50. Which relational operator should be used?
a) =
b) >
c) <
d) != only

Q91. When a query is created for the Events table using the wizard, its default name is
a) Query1
b) Query_Events
c) EventsQuery
d) NewQuery

Q92. Which row of the Design grid is used to arrange records in ascending or descending order?
a) Alias
b) Sort
c) Criterion
d) Function

Q93. To run a saved query again, the user
a) right-clicks and selects Delete
b) presses the Esc key
c) double-clicks the query name
d) selects File > Close

Q94. Which row is used to display an alternative heading instead of the original field name in query results?
a) Table
b) Sort
c) Alias
d) Criteria

Q95. What does an Alias represent in a query?
a) A duplicate record
b) An alternative name for a field
c) A foreign key
d) A database password

Q96. Which option is selected by default for the Visible checkbox in the Query Design window?
a) Unselected
b) Selected
c) Disabled
d) Hidden permanently

Q97. Which mathematical function is used to calculate the total of numerical values in a query?
a) Minimum
b) Maximum
c) Sum
d) Average only

Q98. To display only those records where the points scored are more than 10, the criterion typed is
a) <10
b) >10
c) =10
d) !=10

Q99. Which of the following is the relational operator for “not equal to” in the Criterion row?
a) !=
b) ==
c) =<
d) =>

Q100. A sports teacher wants to identify the highest points scored in an event using a query. Which function should be used?
a) Minimum
b) Maximum
c) Sum
d) Count only

Q101. Which function returns the smallest value from a numerical field?
a) Sum
b) Average
c) Minimum
d) Maximum

Q102. A school wants to calculate the average marks of students through a query. Which function is appropriate?
a) Average
b) Minimum
c) Maximum
d) Sum only

Q103. Which database object provides a user-friendly interface and is the front end for data entry?
a) Query
b) Report
c) Table
d) Form

Q104. Each field control on a form consists of
a) a label and a field value text box
b) a table and a query
c) a key and a record
d) a header and a footer

Q105. The piece of text that specifies what data should be entered in the field value text box is called a
a) field value
b) label
c) record
d) key

Q106. A form can be created in LibreOffice Base using
a) a wizard only
b) datasheet or SQL view
c) a wizard or the Design View
d) a query or a report

Q107. A form within a form is called a
a) layout
b) control
c) report
d) subform

Q108. By default, the name of a form created using the wizard is the same as the name of the
a) database
b) user
c) table
d) report

Q109. The Forms Control toolbar is on the left side of the Form Design window. The Records toolbar is located at the
a) top
b) right
c) left
d) bottom

Q110. To change the background colour of a form, the user selects Page Style and then the ______ tab.
a) Area
b) Font
c) Border
d) Layout

Q111. To select only the label or only the text box of a control on a form, the user clicks on it while pressing the
a) Alt key
b) Shift key
c) Ctrl key
d) Tab key

Q112. Which property in the Properties dialog box is used to add a tool-tip to a text box?
a) Label
b) Help Text
c) Tab Order
d) DropDown

Q113. To display a calendar for a date field in a form, the Date Format is set to Standard (long) and the DropDown property is set to
a) No
b) None
c) Short
d) Yes

Q114. A school wants to present the results retrieved through a query in an attractive, customised and formatted manner. Which feature should it use?
a) Form
b) Report
c) Table
d) Field Properties

Q115. A report can be created from
a) tables only
b) tables or queries or both
c) forms only
d) the Records toolbar

Q116. The default orientation selected in the layout step of the Report Wizard is
a) Portrait
b) Square
c) Vertical
d) Landscape

Q117. In a Dynamic report,
a) the report never changes
b) the report changes automatically as the field values in the table or query change
c) the report cannot be edited
d) the report is deleted after closing

Q118. To display the details of events category-wise in a report, the CategoryID field is shifted to the
a) Sort options
b) Labels box
c) Groupings list box
d) Layout box