DBMS Class 10 Sample Paper MCQ – We have made an effort to collect all the important MCQs given in the last 5 years in the sample paper. We have also removed the MCQs that are not necessary or outdated as per the current syllabus and are not going to come in the upcoming examination. The below-provided MCQs are taken from sample paper from the last five years. All the questions taken from CBSE sample papers are categorized topic-wise. These MCQs will be helpful to the students to score good marks in the examination.
DBMS Class 10 Sample Paper MCQ
1. Which of the following best defines “information”? (Sample Paper 2024-2025)
a. Unprocessed raw facts such as names, marks, and addresses.
b. Organized and processed data that provides meaningful insights.
c. Audio, video, and graphics stored without any processing.
d. A collection of unrelated raw facts.
2. What does referential integrity in a database ensure? (Sample Paper 2024-2025)
a. All primary keys are unique across the database.
b. All records in a table must have a value in every column.
c. Every foreign key value must match a primary key in the referenced table or be null.
d. Data can be freely deleted from any table without constraints.
3. Which of the following data models sets a relation between the two or more tables? (Sample Paper 2024-2025)
a. Relational Data Model
b. Network Data Model
c. Hierarchical Data Model
d. Connection Data Model
4. Which of the following statements are true about primary key in a database? (Sample Paper 2024-2025)
a. It is a field that can have duplicate values.
b. It uniquely identifies each record in a table.
c. It can have null values
d. It is an optional field in a database table.
5. Which of the following dialog boxes appears when the Query Design window is opened for the first time to design a query? (Sample Paper 2024-2025)
a. Add Table
b. Add Query
c. Add Query or Report
d. Add Table or Query
6. What feature in OpenOffice Base allows users to present retrieved data in a user-friendly and formatted manner? (Sample Paper 2024-2025)
a. Query
b. Form
c. Report
d. Data view
7. It enables users to view, enter, and change data directly in database objects. (Sample Paper 2023-2024)
a. Report
b. Query
c. Form
d. Database
8. There are _ types of Relationships in a table of a database. (Sample Paper 2023-2024)
a. One
b. 3
c. 4
d. Many
9. A Relational database uses _ commands which is a standard user application that provides an easy programming interface for database interaction. (Sample Paper 2023-2024)
a. Access
b. Python
c. SQL
d. Protocol
10. Suraj wants to create a database for his clients. For this purpose, she needs to store the Email IDs of his clients. Which datatype should he use to accomplish this purpose? (Sample Paper 2023-2024)
a. Numeric
b. Varchar
c. Binary
d. Boolean
11. Geet has written a SQL query in SQL view. But he doesn’t know how to execute the query using keyboard keys. Suggest him the shortcut key to complete the task. (Sample Paper 2023-2024)
a. Enter
b. Ctrl + E
c. Space bar
d. F5
12. A table can have only _ primary key in a database. (Sample Paper 2023-2024)
a. 1
b. 2
c. 3
d. Many
13. Multiple copies of the same file leads to _. (Sample Paper 2022-2023)
a. Data Inconsistency
c. Data Redundancy
b. Data Consistency
d. Foreign Key
14. Identify the property which help to set the number of characters in text/ varchar type field of a table in DBMS. (Sample Paper 2022-2023)
a. Entry Required
c. Size
b. Default Value
d. Length
15. The length of the field value of text data type is _ characters by default in DBMS. (Sample Paper 2022-2023)
a. 10
b. 25
c. 20
d. 50
16. Identify the mode, where we can modify in the structure of table? (Sample Paper 2022-2023)
a. Datasheet view
c. Design view
b. Structure view
d. All of the above
17. __ store data in a single table which is suitable to store less amount of Data. (Sample Paper 2022-2023)
a. Flat File
b. Relational
c. Mini File
d. Single File
18. Database servers are referred to as ___. (Sample Paper 2021-2022)
a. Front ends
b. Back-ends
c. Clients
d. Model
19. A table is a set of data elements that is organized using a model of vertical and horizontal __. (Sample Paper 2021-2022)
a. Rows, Tables
b. Columns, Rows
c. Rows, Columns
d. Forms, Reports
20. Akshat wants to store a huge amount information about his firm in a database. Which type of table organization would be most suitable for this purpose? (Sample Paper 2021-2022)
a. Relational
b. Flat File
c. Either Relational or Flat file
d. Hierarchical
21. __ database is a type of database that stores data in several tables. (Sample Paper 2020-2021)
a. Flat
b. Relational
c. both a. and b.
c. None of them
22. In database _ helps us to retrieve the filtered data based upon some conditions. (Sample Paper 2020-2021)
a. Forms
b. Reports
c. Queries
d. Table
23. Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this purpose. (Sample Paper 2020-2021)
a. Length
b. Default
c. Entry Required
d. Format
24. __ can be set for a field if the user doesn’t provide any value while entering the values in the table. (Sample Paper 2020-2021)
a. Required
b. Default
c. Primary Key
d. Format
25. Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task. (Sample Paper 2020-2021)
a. Table
b. Form
c. Relationships
d. Sorting
26. _ data type takes the values in the form of 0 and 1 in the database. (Sample Paper 2020-2021)
a. Integer
b. Text
c. Boolean
d. Memo
27. _ means that the query uses criteria you provide to hide some data and display only required data. (Sample Paper 2022-2023)
a. Filtering
c. Report
b. Sorting
d. Forms
Disclaimer: We have made an effort to provide you with the CBSE sample paper MCQs of “DBMS Class 10 Sample Paper MCQ“. If you feel that there is any error or mistake, please contact me at anuraganand2017@gmail.com. The above CBSE sample paper MCQs presented on our website are for educational purposes, not our copyrights. All the above MCQs and questions are taken from the Information Technology Class 10 sample paper, which is present on the CBSEACADEMIC website. These MCQs and questions are legally copyrighted by the Central Board of Secondary Education. We are only providing a medium and helping the students to improve the performances in the examination.
For more information, refer to the official CBSE textbooks available at cbseacademic.nic.in