Class 10 IT 402 Database Management System MCQs with solution focus on important database concepts like tables, fields, records, primary keys, queries, and basic data handling. Since CBSE board exams include MCQ-based questions from DBMS chapters, practicing these multiple-choice questions helps students grasp technical concepts easily and quickly. These MCQs are structured in a simple and student-friendly way to improve understanding and retention.
This MCQ practice set is equally beneficial for teachers who want ready-made question banks for revision classes or assessments. Students preparing for the CBSE Class 10 IT 402 exam can enhance their performance by solving these DBMS MCQs regularly. Long tail keywords such as Class 10 IT 402 DBMS MCQs with solutions, CBSE Information Technology database MCQs, and Database Management System MCQs for Class 10 students ensure better search visibility and targeted learning.
Database Management System / OpenOffice Base - Class 10 Information Technology Code 402 MCQs with Solution
MCQ 1: Which of the following is not an example of DBMS? [CBSE 2023]
a) PostgreSQL
b) SQLite
c) FoxPro
d) Imperss
MCQ 2: A ____ is an interface in a user-specified layout that lets users to view, enter, and changes data directly in database objects such as tables. [CBSE 2023]
a) frame
b) form
c) relation
d) report
MCQ 3: Which of the following is expanded form of SQL? [CBSE 2023]
a) Systematic Query Language
b) Structured Query Language
c) Software Query Language
d) Structural Query Language
MCQ 4: ____ is usually suitable for less amount of data. [CBSE 2023]
a) Flat File
b) Relational
c) Both of them
d) None of these
MCQ 5: Binary data types in a database can be using for storing _____ [CBSE 2023]
a) photos, music files, etc.
b) integer values,
c) only images files
d) only video files
MCQ 6: ____ clause can be used with the SELECT statement in SQL to specify which rows to retrieve from the table. [CBSE 2023]
a) WHERE
b) GROUP
c) SAME
d) SIMILAR
MCQ 7: Which of the following software is appropriated to store data about school students.
a) MS Access
b) Writer
c) Calc
d) Impress
MCQ 8: Which of the following is not a database programs?
a) MySQL
b) Oracle
c) Writer
d) OObase
MCQ 9: ____ store data in Single table.
a) Flat File
b) Relational
c) Single File
d) One File
MCQ 10: ____ are dedicated computers that hold the actual databases and run only DBMS and related Software.
a) Main Server
b) Web Server
c) Database Server
d) Non Database Server
MCQ 11: GUI act as front end and database server act as ____.
a) Container
b) Back End
c) End
d) None of these
MCQ 12: Duplication of data is called ____.
a) Inconsistency
b) Consistency
c) Redundancy
d) Foreign Key
MCQ 13: Which of the following is not the advantage of database?
a) Sharing of Data
b) Reduce Data Redundancy
c) Increase Data Inconsistency
d) Data Security
MCQ 14: Which of the following will help to maintain unique record in the table?
a) Foreign Key
b) Primary Key
c) Composite Key
d) Alternate Key
MCQ 15: Which of the following field of table "Book" can act as Primary Key?
a) Book_number
b) Subject
c) price
d) Author_name
MCQ 16: When Primary Key is made up of two or more columns then it is called ____ Primary Key.
a) Mixed
b) Reference
c) Composite
d) Compost
MCQ 17: A key which is referring to the primary key of another table is called ____.
a) alternate Key
b) Primary Key
c) first Primary Key
d) Foreign Key
MCQ 18: A field which is ____ for each and every record is called Primary Key.
a) Common
b) Same
c) Unique
d) None of the above
MCQ 19: 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 these
MCQ 20: Identify the Foreign Key from table "Sales"
| ClientID (Primary Key) | Client Name | Client Phone |
|---|
Table: Sales
| SalesID (Primary Key) | ClientID | Profit |
|---|
a) SalesID
b) Profit
c) Clientphone
d) ClientID
MCQ 21: Which of the following is not valid field of table "Student"?
a) admno
b) name
c) fees
d) salary
MCQ 22: In RDBMS, data is organised in the form of ____.
a) Table
b) Record
c) Field
d) None of these
MCQ 23: All the values in ____ are of same type.
a) Records
b) Table
c) Database
d) Fields
MCQ 24: ____ represents a single data item in a table.
a) Tuples
b) Attributes
c) Relation
d) All of these
MCQ 25: Database servers are referred to as ____. [CBSE SQP 2021, Term-1]
a) front-ends
b) back-ends
c) clients
d) model
MCQ 26: A table is a set of data elements that is organised using a model of vertical ____ and horizontal ____. [CBSE SQP 2021, Term-1]
a) rows, tables
b) columns, rows
c) rows, columns
d) forms, reports
MCQ 27: Which one of the following is an example of RDBMS? [CBSE SQP 2021, Term-1]
a) MongoDB
b) Windows registry
c) Publisher
d) Oracle
MCQ 28: The ____ has evolved since the 1960s to ease increasing difficulties in designing, building and maintaining complex information systems.
a) Knowledge concept
b) Formula concept
c) Database concept
d) Forms concept
MCQ 29: ____ are the basic building blocks of a database.
a) Tables
b) Record
c) Fields
d) All of these
MCQ 30: We can create table:
a) in design view
b) use Wizard
c) Both a) and b)
d) none of these
MCQ 31: By default data type of fields is:
a) Text(Varchar)
b) Text(Char)
c) Int
d) Long
MCQ 32: By default the length of Varchar data type is ____.
a) 20
b) 30
c) 40
d) 50
MCQ 33: By default the name of the table is ____.
a) Tab 1
b) Table 1
c) First Table
d) Untitled 1
MCQ 34: ____ are used to identify which type of data we are going to store in the database.
a) Datatype
b) Record
c) Table
d) Attributes
MCQ 35: Which data type will be appropriate to store information such as Salary, Fees, Price, etc.?
a) Alphanumeric Data types
b) Numeric Data type
c) Binary Data types
d) Date Time
MCQ 36: Which of the following is not a numeric data type?
a) Tinyint
b) Smallint
c) Boolean
d) Date
MCQ 37: Which of the following data types cannot store decimal values?
a) Decimal
b) Real
c) Numeric
d) Boolean
MCQ 38: Which of the following will occupy more space in computer memory?
a) Bigint
b) Smallint
c) Integer
d) Boolean
MCQ 39: Char is a ____ length data type and Varchar is a _____ length data type.
a) fixed, variable
b) variable, fixed
c) variable, variable
d) fixed, fixed