Chapter-2 Database Management Systems (MS Access) — Online MCQ Test
INFORMATION TECHNOLOGY · Grade 8 · CBSE(NCERT)
Practice Chapter-2 Database Management Systems (MS Access) with a free chapter-wise online MCQ test.
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.
Chapter-2 Database Management Systems (MS Access) — Important Questions & Answers
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.
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.
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.
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.
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.
Proper database normalization eliminates data redundancy by storing each data item in only one place and using relationships to access it, ensuring data consistency.