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.
In a relational database, what is a 'field'?
- A. A row in a table containing data for one record
- B. A column in a table containing a specific type of data
- C. The entire collection of data in a database
- D. A visual representation of data
Answer: B. A column in a table containing a specific type of data
A field is a column in a table that stores a specific attribute or characteristic of the data.
A field is a column in a table that stores a specific attribute or characteristic of the data.
What is a 'record' in a database table?
- A. A column containing a single type of information
- B. A row in a table containing data for one entity
- C. A backup copy of the database
- D. A query result
Answer: B. A row in a table containing data for one entity
A record is a complete row of data in a table, containing all the fields for a single entity.
A record is a complete row of data in a table, containing all the fields for a single entity.
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.
What would be the most appropriate primary key for an 'Employee' table?
- A. Employee Name
- B. Employee ID
- C. Employee Department
- D. Employee Salary
Answer: B. Employee ID
Employee ID is unique for each employee, making it the best choice for a primary key, whereas names can be duplicate.
Employee ID is unique for each employee, making it the best choice for a primary key, whereas names can be duplicate.
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.
If you have a database with student records where the same student's name appears multiple times with different IDs, what problem does this indicate?
- A. The database is performing optimally
- B. Data redundancy and lack of proper primary key usage
- C. The database needs more storage space
- D. Forms are not being used correctly
Answer: B. Data redundancy and lack of proper primary key usage
This indicates poor database design with data redundancy; each student should have one unique ID as a primary key.
This indicates poor database design with data redundancy; each student should have one unique ID as a primary key.
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.
In MS Access, when you create a table with fields for Employee data, you choose 'Text' for the EmployeeID field instead of 'Number', and you set it as the primary key. Later, you notice that the system allows IDs like 'EMP001' and 'EMP#2' in the same field. What is the primary issue with this design decision?
- A. Text data type cannot be used for primary keys
- B. The Text data type allows non-uniform data entry, making the EmployeeID unreliable as a unique identifier
- C. Number data type is always required for primary keys
- D. This design is optimal because it allows flexibility in data entry
Answer: B. The Text data type allows non-uniform data entry, making the EmployeeID unreliable as a unique identifier
While Text can be a primary key, it allows varying formats; proper design would enforce a consistent format through validation rules or use appropriate data types to maintain data integrity.
While Text can be a primary key, it allows varying formats; proper design would enforce a consistent format through validation rules or use appropriate data types to maintain data integrity.