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.