MCQ Questions For Class 10 Information Technology Chapter 3 Database Management System

MCQs Class 10

Students can refer to the following Database Management System MCQ Questions for Class 10 with Answers provided below based on the latest curriculum and examination pattern issued by CBSE and NCERT. Our teachers have provided here a collection of multiple choice questions for Database Management System Class 10 covering all topics in your textbook so that students can assess themselves on all important topics and thoroughly prepare for their exams

Database Management System MCQ Questions for Class 10 Information Technology with Answers

We have provided below Database Management System MCQ Questions for Class 10 with answers which will help the students to go through the entire syllabus and practice multiple choice questions provided here with solutions. As Database Management System MCQs for Class 10 Information Technology pdf download can be really scoring for students, you should go through all problems provided below so that you are able to get more marks in your exams.

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

Answer

D

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

Answer

A

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

Answer

B

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

Answer

D

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

Answer

A

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

Answer

B

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

Answer

A

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

Answer

A

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

Answer

C

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

Answer

D

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

Answer

C

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

Answer

B

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

Answer

A

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

Answer

A

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

Answer

A

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

Answer

D

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

Answer

B

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

Answer

B

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

Answer

A

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

Answer

C

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

Answer

C

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

Answer

D

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

Answer

B

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

Answer

A

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

Answer

B

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

Answer

C

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

Answer

A

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

Answer

B

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

Answer

C

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

Answer

A

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

Answer

B

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

Answer

A

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

Answer

A

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

Answer

D

MCQ Questions For Class 10 Information Technology Chapter 3 Database Management System