Database Management System MCQ questions with answers PDF | 10 BEST DBMS objective questions

CBSE Class 10 Information Technology code 402 unit – 3 Database Management System MCQ with answers are discussed here. Since the CBSE Class 10 term 1 exam is completely MCQ-based it is important for you to practice these CBSE Class 10 IT RDBMS objective questions to score well in your exam.

In this post, we have shared 10 Database Management System MCQ with answers. Practice these RDBMS objective-type questions here for free. IT 402 SYLLABUS 2021-22

Database Management System MCQ questions with answers

Q1. Which of the following will help to maintain the unique record in the table?
a. Foreign Key

b. Primary Key

c. Composite Key

d. Alternate Key

Q2. Which of the following field of table “Book” can act as the primary key?
a. Book_number

b. Subject

c. price

d. Author_name

Q3. When the primary key is made up of two or more columns then it is called __ primary key.
a. Mixed

b. Reference

c. Composite

d. Compost


Q4. Duplicate values can be entered in the primary key. (T/F)
a. True

b. False


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


Q6. A field that is __ for each and every record is called the Primary key.
a. Common

b. Same

c. Unique

d. None of the above


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


Q8. Identify the Foreign Key from table “Sales”
Table Client:
ClientID (primary Key)
client name
client phone

Table: Sales
sales (Primary Key)
ClientID
Profit

a. SalesID

b. Profit

c. Client phone

d. ClientID


Q9. Which of the following is not a valid field of table “Student”
a. admno

b.name

c. fees

d. salary


Q10. There can be multiple primary keys in a table. (T/F)
a. True

b. False

So these were the CBSE Class 10 IT 402 Unit 3 Database Management System MCQ questions with answers. Practice these Database Management System MCQ questions with answers. Also, share this Database Management System MCQ questions with answers with your friends. I hope this Database Management System MCQ questions with answers were helpful.

Leave a Comment