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