DBMS Class 10 Board MCQ Questions – We have made an effort to collect all the important MCQs asked in the last 5 years in board examinations. We have also removed the MCQs that are not necessary in the upcoming examination. The below-provided MCQs are taken from board question papers from the last five years. All the questions taken from CBSE board question papers are categorized topic-wise. These MCQs will be helpful to the students to score good marks in the examination.
DBMS Class 10 Board MCQ Questions
1. In OpenOffice Base, the relationship applied on the tables can be removed with the help of _ option. (CBSE 2023-24)
a. Clear
c. Drop
b. Remove
d. Delete
2. In SQL, the keyword to display records in ascending order is: (CBSE 2023-24)
a. Asce
c. Asc
b. Incr
d. High
3. _ is a numeric data type which can store Yes/No type values in the form of 0 or 1 in OpenOffice Base table. (CBSE 2023-24)
a. Boolean
c. Binary
b. Char
d. OtherObject
4. Which of the following statement retrieves zero or more rows from one or more database tables or database views? (CBSE 2023-24)
a. UPDATE
c. SELECT
b. DELETE
d. DISPLAY
5. Roshni has created a table Customer in SQL and wants to store photograph image of every customer under Cust_photo field. Suggest a suitable data type from the options given below. (CBSE 2023-24)
a. IMAGE
b. PICTURE
c. LONGVARBINARY
d. GRAPHIC
6. By default, all the fields in OpenOffice Base will have _ datatype. (CBSE 2023-24)
a. int (tiny)
c. text (varchar)
b. Boolean
d. text (char)
7. In OpenOffice Base, the relationship applied on the tables can be removed with the help of _ option. (CBSE COMP 2023-24)
a. Clear
c. Drop
b. Remove
d. Delete
8. In SQL, the keyword to display records in ascending order is: (CBSE COMP 2023-24)
a. Asce
c. Asc
b. Incr
d. High
9. _ is a numeric data type which can store Yes/No type values in the form of 0 or 1 in OpenOffice Base table. (CBSE COMP 2023-24)
a. Boolean
c. Binary
b. Char
d. OtherObject
10. Which of the following statement retrieves zero or more rows from one or more database tables or database views? (CBSE COMP 2023-24)
a. UPDATE
c. SELECT
b. DELETE
d. DISPLAY
11. Roshni has created a table Customer in SQL and wants to store photograph image of every customer under Cust_photo field. Suggest a suitable data type from the options given below. (CBSE COMP 2023-24)
a. IMAGE
b. PICTURE
c. LONGVARBINARY
d. GRAPHIC
12. By default, all the fields in OpenOffice Base will have _ datatype. (CBSE COMP 2023-24)
a. int (tiny)
c. text (varchar)
b. Boolean
d. text (char)
13. Which one of the following is not an example of DBMS? (CBSE 2022-23)
a. PostgresSQL
b. SQLite
c. FoxPro
d. Impress
14. A is an interface in a user specified layout that lets users to view, enter, and change data directly in database objects such as tables. (CBSE 2022-23)
a. frame
b. form
c. relation
d. report
15. Which of the following is expanded form of SQL? (CBSE 2022-23)
a. Systematic Query Language
b. Structured Query Language
c. Software Query Language
d. Structural Query Language
16. __ is usually suitable for less amount of data. (Relational/Flat file) (CBSE 2022-23)
Show Answer ⟶17. Binary data types in a database can be using for storing. (CBSE 2022-23)
a. photos, music files, ete.
b. integer values
c. only image files
d. only video files
18. ______clause can be used with the SELECT statement in SQL to specify which rows to retrieve from the table. (CBSE 2022-23)
a. WHERE
b. GROUP
c. SAME
d. SIMILAR
19. A _ is a database object that provides a systematic way to accept data from the user and store it in a table of a database. (CBSE COMP 2022-23)
a. Query
b. Form
c. Report
d. Table
20. Primary Keys are also _ in the database, making it faster for the database to search for a record. (CBSE COMP 2022-23)
a. indexed
b. defined
c. duplicated
d. replicated
21. Record uniqueness in a table helps to avoid accidental _ of records caused by user or computer error. (CBSE COMP 2022-23)
a. duplication
b. key
c. deletion
d. removal
22. Data in RDBMS is organized in _. (CBSE COMP 2022-23)
a. files
b. tables
c. text related only
d. linked through network
23. Binary data types are used for storing data in _. (CBSE COMP 2022-23)
a. integer format
b. character format
c. text format
d. binary format
24. _ means that the query uses criteria you provide to hide some data and present only what you want to see. (CBSE COMP 2022-23)
a. Indexing
b. Sorting
c. Filtering
d. Relating
Disclaimer: We have made an effort to provide you with the CBSE Board MCQs of “DBMS Class 10 Board MCQ Questions”. If you feel that there is any error or mistake, please contact me at anuraganand2017@gmail.com. The above CBSE Board 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 Board Examination Question Paper conducted by CBSE, 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
1 thought on “DBMS Class 10 Board MCQ Questions”