CBSE Class 10 Information Technology Database Management System MCQs

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

Answer: C

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

Answer: C

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

Answer: D

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

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 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. 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. SQL stands for __________________
(a) Structural Query Language
(b) Structured Query Language
(c) Skeletal Query Language
(d) None of the options

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

Answer: B

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 options

Answer: B

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

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. In RDBMS, data is organized in the form of __________________
(a) Table
(b) Record
(c) Field
(d) None of the options

Answer: A

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

Answer: B

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 options

Answer: C

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

Answer: C

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

Answer: C

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

Answer: A

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

Answer: A

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

Answer: A