MCQs For NCERT Class 10 Information Technology Chapter 3 Database Management System

Please refer to the MCQ Questions for Class 10 Information Technology Chapter 1 Database Management System with Answers. The following Database Management System Class 10 Information Technology MCQ Questions have been designed based on the current academic year syllabus and examination guidelines for Class 10. Our faculty has designed MCQ Questions for Class 10 Information Technology with Answers for all chapters as per your NCERT Class 10 Information Technology book.

Database Management System Class 10 MCQ Questions with Answers

Please see below Database Management System Class 10 Information Technology MCQ Questions, solve the questions and compare your answers with the solutions provided below.

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

Question. DML stands for ____________
(a) Data Manipulation Language
(b) Database Manipulation Language
(c) Data Modify Language
(d) None of the above

Question. Which of the following is not a database programs?
(a) MySQL
(b) Oracle
(c) Writer
(d) OObase

Question. Which of the following clause return specific rows?
(a) Order By
(b) Where
(c) Having
(d) Specific

Question. select * from Stud order by “Rollno” ASC;
(a) display all the records of table.
(b) display records in increasing order of roll number.
(c) both of the above
(d) none of the above

Question. Only numeric fields can act as a primary key in a table.
(a) True
(b) False

Question. Command to display all the data in the table “emp” is.
(a) Select * from emp
(b) Select * from emp;
(c) Select all from emp
(d) Select all from emp;

Question. ____________ is the most common DML comman(d)
(a) Delete
(b) Update
(c) Select
(d) All of the above

Question. Which command is used to create table?
(a) Select
(b) Create
(c) Open
(d) New

Question. Duplication of data is called _________.
(a) Inconsistency
(b) Consistency
(c) Redundancy
(d) Foreign Key

Question. Shortcut to execute query in Create Query in SQL View is __
(a) F7 Key
(b) F5 Key
(c) F8 Key
(d) F6 Key

Question. Select “empname”, “salary” * 3 from emp;
(a) will increase the salary three times of all employees in table
(b) display name and three times salary
(c) give error
(d) None of the above

Question. Which of the following software is appropriate to store data about school students?
(a) MS-Access
(b) Writer
(c) Calc
(d) Impress

Question. To get details about the list of students whose favorite color is blue. Query for this is :
(a) select all from Stud where fav_Color=’Blue’;
(b) select name from Stud where fav_Color=’Blue’;
(c) select * from Stud where fav_Color=’Blue’;
(d) select all from Stud where fav_Color is ’Blue’;

Question. Which command is used to delete data from table?
(a) select
(b) delete
(c) insert
(d) remove

Question. Update statement is used to modify data in a table.
(a) True
(b) False

Question. Which command is used to modify data in table?
(a) delete
(b) select
(c) modify
(d) update

Question. Which of the following clause return records in ascending order?
(a) Order By
(b) Where
(c) Order Asc
(d) Order Inc

Question. By default data is arranged in _____ order using order by clause.
(a) Ascending
(b) Descending
(c) Primary Key
(d) None of the above

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

Question. Which of the following field is invalid for storing information of “Library” Table?
(a) Cost
(b) Booknumber
(c) Authorname
(d) Dateofbirth

Question. Data Integrity means that data is accurate and consistent in the database.
(a) True
(b) False

Question. Which of the following act as an interface to view, enter and change data in database?
(a) Report
(b) Table
(c) Query
(d) Form

Question. A _____________ helps to display the data in a summarized dat(a)
(a) Report
(b) Form
(c) Query
(d) None of the above

Question. A _______ helps to collect specific information from the pool of dat(a)
(a) Query
(b) Report
(c) Form
(d) None of the above

Question. Which of the following is to be created first?
(a) Report
(b) Query
(c) Form
(d) Table

Question. A foreign key is a reference of the ________ key in another table.
(a) Alternate
(b) Primary
(c) Candidate
(d) None of the above

Question. A table is a collection of logically related dat(a)
(a) True
(b) False

Question. _______ tables can be created in a database.
(a) 1
(b) 2
(c) 3
(d) More than 3

Question. In primary key we can enter NULL values.
(a) True
(b) False

Question. A database is an organized collection of _______________.
(a) data
(b) Attributes
(c) Record
(d) None of the above

Question. Duplicate values can be entered in Foreign key.
(a) True
(b) False

Question. Command to increase the salary of all employees by 15000.(table name emp and column name sal)
(a) update emp set sal = sal + 15000;
(b) update emp set sal = 15000;
(c) update set sal = sal + 15000;
(d) None of the above