MCQ Questions Chapter 3 Database Management System Class 10 Information Technology

Please refer to MCQ Questions Chapter 3 Database Management System Class 10 Information Technology with answers provided below. These multiple-choice questions have been developed based on the latest NCERT book for class 10 Information Technology issued for the current academic year. We have provided MCQ Questions for Class 10 Information Technology for all chapters on our website. Students should learn the objective based questions for Chapter 3 Database Management System in Class 10 Information Technology provided below to get more marks in exams.

Chapter 3 Database Management System MCQ Questions

Please refer to the following Chapter 3 Database Management System MCQ Questions Class 10 Information Technology with solutions for all important topics in the chapter.

MCQ Questions Answers for Chapter 3 Database Management System Class 10 Information Technology

Question. Which of the following is an attribute whose value is derived from the primary key of some other table?
(a) Primary key
(b) Foreign key
(c) Alternate key
(d)None of these

Question. Which of the following best describes a form?
(a) Form enables people to enter or view data in a database easily.
(b) Form summarises and prints data.
(c) A form filters data from a database based on a criteria
(d) All of the above

Question. Which of the following is not a component of a database?
(a) tables
(b) queries
(c) forms
(d) formula bar

Question. A relational database is a collection of
(a) attributes
(b) tables
(c) records
(d) fields

Question. Which of the following is not the main building block of a database?
(a) Lists
(b) Queries
(c) Reports
(d) Forms 

Question. The design of the database is known as
(a) attribute
(b) database scheme
(c) abstraction
(d) database oriented

Question. Operations performed on a databases are controlled by
(a) user
(b) hardware
(c) DBMS
(d) RDBMS

Question. Duplication of data is known as
(a) data security
(b) data incomplete
(c) data redundancy
(d) None of the above

Question. RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to
(a) Record Database Management System
(b) Relational Database Management System
(c) Reference Database Management System
(d) None of the above

Question. Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required?
(a) Age in years
(b) Data of birth
(c) Age in days
(d) Age in months 

Question. Computer based record keeping system is known as
(a) Data Manipulation System
(b) Computerised Data System
(c) Computerised Record Keeping System
(d) DBMS

Question. …………… refers to the attribute that can uniquely identify tuples within the relation.
(a) Foreign key
(b) Consolidate key
(c) Alternate key
(d) Primary key

Question. A database that contains tables linked by common fields is called a
(a) Centralised database
(b) Flat file database
(c) Relational database
(d) None of the above

Question. Database is a combination of
(a) hardware and software
(b) hardware and operating system
(c) software and operating system
(d) utility programs

Question. DBMS is a program that controls the creation, maintenance and use of database. Here, DBMS referred to
(a) Digital Base Management System
(b) Data Build Management System
(c) Database Management System
(d) Database Management Service

Question. Which of the following fields will not make a suitable primary key?
(a) A customer’s account number
(b) A data field
(c) An auto number field
(d) A student’s admission number

Question. Databases have the ability to
(a) store a large amount of data in a structured format, easy update, sort query, production of reports
(b) spell check, perform calculations, library of mathematical functions, replication
(c) rotate images, copy and paste, fill scale
(d) None of the above

Question. All the information about a thing or a person is known as a
(a) database
(b) file
(c) field
(d) record

Question. Key field is a unique identifier for each record. It is defined in the form of
(a) rows
(b) columns
(c) tree
(d) query

Question. Which of the following is not an example of database?
(a) Cross knot game
(b) Employee payroll management
(c) Numeric calculator
(d) Customer management system

Question. A tuple in RDBMS is referred to ……… of a table.
(a) record
(b) field
(c) table
(d) key 

Question. When you define a field for a table, which of the following parameters do access always consider optional?
(a) Field Name
(b)Data Type
(c) Field Size
(d)Description 

Case Based MCQs :

Mr. Amar Agarwal is the owner of his parental firm Agarwal & Sons which deals in the wholesale business of spices.
He wants to maintain records of spices available in their shop and generate bills when omeone purchases any spices from the shop. They want to create a database to keep track of all the spices in the shop and the spices purchased by customers.

Question. To view the table structure of the above created table the command is
(a) SELECT spice
(b) DESC spice
(c) DESCRIBE spice
(d) Both (b) and (c)

Question. Which is the correct SQL statement to create the table?
(a) CREATE TABLE spice(scode integer, sname
char(25), price decimal, stock integer)
(b) CREATE spice(scode integer, sname char(25),
price decimal, stock integer)
(c) CREATE spice(scode , sname , price, stock)
(d) SELECT TABLE spice(scode integer, sname
char(25), price decimal, stock integer)

Question. To add a new column exp_date in the existing table the statement is
(a) ALTER TABLE spice ADD (exp_date date);
(b) UPDATE TABLE spice ADD (exp_date date);
(c) MODIFY spice ADD (exp_date date);
(d) ALTER TABLE spice MODIFY (exp_date date);

Question. To create an index on name of spices in the existing table, the command is
(a) ALTER TABLE spice ADD INDEX spice_idx (sname)
(b) CREATE INDEX spice_idx ON spice (sname)
(c) CREATE TABLE spice (INDEX spice_idx (sname))
(d) Both (a) and (b)

Question. To add records in the table which of the following SQL statement is used?
(a) ADD
(b) SELECT
(c) INSERT
(d) INSERT INTO

Consider the table STUDENT with following details.

Question. Command to delete all records that belongs to ‘Science’ stream .
(a) DELETE FROM STUDENT WHERE Stream= ‘Science’;
(b) DROP FROM STUDENT WHERE Stream= ‘Science’;
(c) DROP TABLE STUDENT WHERE Stream= ‘Science’;
(d) None of the above

Question. Command to select all Commerce students from the table STUDENT.
(a) SELECT * FROM STUDENT;
(b) SELECT Stream FROM STUDENT WHERE Stream= ‘Commerce’;
(c) SELECT * FROM STUDENT WHERE Stream = ‘Commerce’;
(d) SELECT Name FROM STUDENT WHERE Stream = ‘Commerce’;

Question. Modify the marks of Kanika as 85.5.
(a) ALTER TABLE STUDENT SET Marks = 85.5 WHERE Name = ‘Kanika’;
(b) UPDATE STUDENT SET Marks=85.5 WHERE Name = Kanika’;
(c) UPDATE TABLE STUDENT SET Marks =85.5 WHERE Name= ‘Kanika’;
(d) ALTER STUDENT SET Marks=85.5 WHERE Name = ‘Kanika’;

Question. Add a record of new student ‘Rashmi’ of ‘Humanities’ stream in class ‘12B’ and her marks is ‘70.9’.
(a) INSERT INTO STUDENT VALUES (‘Rashmi’, ‘Humanities’, ‘12B’, 70.9);
(b) INSERT INTO STUDENT VALUES (7,‘Rashmi’, ‘Humanities’, ‘12B’, 70.9);
(c) INSERT INTO STUDENT VALUES (‘Rashmi’, ‘Humanities’, 70.9, ‘12B’);
(d) INSERT INTO STUDENT VALUES (7,‘Rashmi’, ‘Humanities’, 70.9, ‘12B’);

Question. View all records other than ‘12A’ class.
(a) SELECT DISTINCT Class FROM STUDENT;
(b) SELECT Class FROM STUDENT WHERE (Class NOT = ‘Science’);
(c) SELECT * FROM STUDENT WHERE Class NOT IN (‘Science’);
(d) None of the above