Class 10 Information Technology Chapter 3 Database Management System MCQ Questions with Answer

Database Management System Class 10 MCQ is one of the best strategies to prepare for the CBSE Class 10 Board exam. If you want to complete a grasp concept or work on one’s score, there is no method except constant practice. Students can improve their speed and accuracy by doing more Database Management System class 10 MCQ which will help them all through their board test.

Database Management System Class 10 MCQ Questions with Answer

Class 10 Information Technology MCQ with answers are given here to Chapter 3 Database Management System. These MCQs are based on the latest CBSE board syllabus and relate to the latest Class 10 Information Technology syllabus. By Solving these Class 10 MCQs, you will be able to analyze all of the concepts quickly in the Chapter and get ready for the Class 10 Annual exam.

Learn Database Management System Class 10 MCQ with answers pdf free download according to the latest CBSE and NCERT syllabus. Students should prepare for the examination by solving CBSE Class 10 Database Management System MCQ with answers given below.

Question 1. By default the name of the table is ______
(a) Tab 1
(b) Table 1
(c) First Table
(d) Untitled 1

Question 2. Which of the following property help to set the number of characters in Varchar type.
(a) Auto value
(b) Required
(c) Default Value
(d) Length

Question 3. Which field is suitable for storing records of employees?
(a) EmpNo
(b) Empname
(c) Salary
(d) All of the above

Question 4. Auto Value is a property of __ data type .
(a) Numeric
(b) Character
(c) Binary
(d) Date

Question 5. Which of the following field of table “Book” can act as primary key?
(a) Book_number
(b) Subject
(c) price
(d) Author_name

Question 6. By default the length of the Integer data type is ______________
(a) 10
(b) 15
(c) 20
(d) 25

Question 7. Which property ensures that field can not be left blank?
(a) Entry required
(b) Format
(c) Required Entry
(d) Required

Question 8. A database can have only one table.
(a) True
(b) False

Question 9. Which of the following is not the date time data types?
(a) Date
(b) Time
(c) Datestamp
(d) Timestamp

Question 10. There can be multiple primary key in a table.
(a) True
(b) False

Question 11. Which of the following property to be turned “yes” so that value will be auto incremented?
(a) Default
(b) Format
(c) Auto value
(d) Length

Question 12. Which of the following is not the binary data types?
(a) Longvarbinary
(b) Varbinary
(c) Binary
(d) Charbinary

Question 13. Which data type is used to store value of fields like “Date of Birth”?
(a) Date Time
(b) Varchar
(c) Integer
(d) Other

Question 14. A record in table is also known as Attribute.
(a) True
(b) False

Question 15. Which of the following will occupy more space in computer memory?
(a) Bigint
(b) Integer
(c) Smallint
(d) Boolean

Question 16. _______ data types are used for storing photos, music files etc
(a) Binary
(b) Alphanumeric
(c) Numeric
(d) Special

Question 17. In RDBMS, data is organized in the form of __________________
(a) Table
(b) Record
(c) Field
(d) None of the above

Question 18. In Base data can be linked between two or more tables with the help of _________________
(a) primary key
(b) foreign key
(c) primary and foreign key
(d) None of the above

Question 19. Relationship can be created between
(a) two tables only
(b) one table only
(c) two or more tables
(d) none of the above

Question 20. In which mode we can change the structure of table?
(a) Datasheet view
(b) Design view
(c) Structure view
(d) All of the above

Whoever needs to take the CBSE Class 10 Board Exam should look at this MCQ. To the Students who will show up in CBSE Class 10 Information Technology Board Exams, It is suggested to practice more and more questions. Aside from the sample paper you more likely had solved. These Database Management System Class 10 MCQ are ready by the subject specialists themselves.

Question 21. Referential Integrity is used to maintain accuracy and consistency of data in a relationship.
(a) True
(b) False

Question 22. There are __________________ types of relationship which can be created between tables.
(a) three
(b) two
(c) four
(d) infinite

Question 23. After inserting records in table, we can not modify the structure of table.
(a) True
(b) False

Question 24. Relationship between tables can be created from _____________________ menu.
(a) View
(b) Insert
(c) Windows
(d) Tools

Question 25. GUI act as front end and database server act as _____
(a) Container
(b) Back End
(c) End
(d) None of the above

Question 26. Primary key increases data redundancy.
(a) True
(b) False

Question 27. We can create query (in Open Office Base) in _______________________
(a) In design view
(b) Using wizard
(c) Both of the above
(d) None of the above

Question 28. Sorting means to arrange data in _______________ order.
(a) increasing
(b) decreasing
(c) increasing or decreasing
(d) None of the above

Question 29. Which language help to extract/fetch data from table?
(a) MySQL
(b) Python
(c) OOBase
(d) HTML

Question 30. SQL stands for __________________
(a) Structural Query Language
(b) Structured Query Language
(c) Skeletal Query Language
(d) None of the above

Question 31. Which of the following is suitable to act as a primary key in table student?
(a) Rollno
(b) Name
(c) Class
(d) Section

Question 32. Queries are commands that are used to define the structure and modify the data in a table.
(a) True
(b) False

Question 33. ___________ statement is used to retrieve data from table.
(a) Delete
(b) Update
(c) Print
(d) Select

Question 34. When data is stored, maintained and retrieved from multiple tables then special database software are required called ______
(a) DBMS
(b) RDBMS
(c) Special DBMS
(d) All of the above

You can easily get good marks If you study with the help of Class 10 Database Management System MCQ. We trust that information provided is useful for you. NCERT MCQ Questions for Class 10 Database Management System PDF Free Download would without a doubt create positive results. 

We hope the information shared above in regards to MCQ on Database Management System Class 10 with Answers has been helpful to you. If you have any questions regarding CBSE Class 10 Information Technology Solutions MCQs Pdf, write a comment below and we will get back to you as soon as possible.