Chapter Exam

Chapter-2 Database Management Systems (MS Access) — Online MCQ Test

Q: Which of the following is an example of a DBMS?

Answer: A. MS Access — MS Access is a relational database management system, while Word, PowerPoint, and Photoshop are not DBMS tools.

Q: Which data type would you use to store a date like 15/03/2024?

Answer: C. Date/Time — The Date/Time data type is specifically designed for storing dates and times in various formats.

INFORMATION TECHNOLOGY · Grade 8 · CBSE(NCERT)

Practice Chapter-2 Database Management Systems (MS Access) with a free chapter-wise online MCQ test for CBSE(NCERT) Grade 8 INFORMATION TECHNOLOGY. This chapter covers: DBMS - relational database - table - record - field - primary key - data types - design view - datasheet view - queries - forms - data redundancy. AI-generated questions from basic to board-exam level, with instant results and explanations.

Questions

20m

Time Limit

Attempts Left

10 random questions from this chapter (mixed difficulty)
Questions you've seen before won't repeat until the pool resets
You have 20 minutes — exam auto-submits when time is up
Maximum 3 attempts per chapter
Results and explanations shown immediately after submission

New here? Register free — includes 3 free chapter exams.

Chapter-2 Database Management Systems (MS Access) — Important Questions & Answers (FAQ)

Frequently asked questions from CBSE(NCERT) Grade 8 INFORMATION TECHNOLOGY — Chapter-2 Database Management Systems (MS Access), with answers and explanations. These are sample questions; the exam has its own separate question set.

What is a Database Management System (DBMS)?

A. A software application used to create, store, and manage data in an organized way ✓
B. A tool used only for creating spreadsheets
C. A program that designs websites
D. An application for sending emails

Answer: A. A software application used to create, store, and manage data in an organized way
A DBMS is software designed to create, store, retrieve, and manage data efficiently in databases.

Which of the following is an example of a DBMS?

A. MS Access ✓
B. MS Word
C. MS PowerPoint
D. Adobe Photoshop

Answer: A. MS Access
MS Access is a relational database management system, while Word, PowerPoint, and Photoshop are not DBMS tools.

Which data type would you use to store a date like 15/03/2024?

A. Text
B. Number
C. Date/Time ✓
D. Currency

Answer: C. Date/Time
The Date/Time data type is specifically designed for storing dates and times in various formats.

Consider a library database with Book, Author, and Member tables. Why should Author information be stored in a separate table?

A. To make the database larger
B. To reduce data redundancy and improve data integrity ✓
C. To slow down query performance
D. To increase the number of records

Answer: B. To reduce data redundancy and improve data integrity
Separating Author into a distinct table with a relationship prevents duplication of author information and maintains data consistency.

Consider a scenario where a student's email is stored in three different tables: Student, Feedback, and Scholarship. When the student updates their email, they must update it in three places. Which solution best addresses this issue while maintaining data integrity?

A. Create more backup copies of the database
B. Use Datasheet View to update records faster
C. Redesign the database with proper normalization, storing email in one table and using relationships ✓
D. Create a form that automatically updates all three tables simultaneously

Answer: C. Redesign the database with proper normalization, storing email in one table and using relationships
Proper database normalization eliminates data redundancy by storing each data item in only one place and using relationships to access it, ensuring data consistency.