R22 II Year DBMS Unit-1 Quiz
1. Which of the following is a primary advantage of a DBMS over a traditional file system?
- A) Complexity
- B) Data redundancy
- C) Data isolation
- D) Data integrity
- Answer: D) Data integrity
2. What does a DBMS primarily help to manage?
- A) Hardware resources
- B) Software applications
- C) Database and its operations
- D) Network communication
- Answer: C) Database and its operations
3. In comparison to a file system, a DBMS offers better data security through which of the following?
- A) Data encryption
- B) Data integrity
- C) Data isolation
- D) Access control mechanisms
- Answer: D) Access control mechanisms
4. What is the purpose of transaction management in a DBMS?
- A) To ensure data consistency during transactions
- B) To manage network traffic
- C) To optimize query performance
- D) To backup the database
- Answer: A) To ensure data consistency during transactions
5. Which of the following is NOT a component of the DBMS structure?
R22 II Year DBMS Unit-1 Quiz
- A) Database engine
- B) Query processor
- C) Data dictionary
- D) Compiler
- Answer: D) Compiler
6. Which of the following is the primary goal of data modeling?
- A) To store large amounts of data
- B) To ensure efficient data retrieval
- C) To represent the data structure of a database
- D) To enhance the user interface
- Answer: C) To represent the data structure of a database
7. Which data model is based on a hierarchical arrangement of data?
- A) Relational model
- B) Network model
- C) Hierarchical model
- D) Object-oriented model
- Answer: C) Hierarchical model
8. What is considered the basic building block of a data model?
- A) Entity
- B) Relationship
- C) Attribute
- D) Schema
- Answer: A) Entity
9. Why are different levels of data abstraction important in a DBMS?
- A) To speed up the design process
- B) To reduce storage requirements
R22 II Year DBMS Unit-1 Quiz
- C) To handle data complexity efficiently
- D) To enable multiple views of the database
- Answer: C) To handle data complexity efficiently
10. Which of the following represents the highest level of data abstraction?
- A) Physical level
- B) Logical level
- C) Conceptual level
- D) View level
- Answer: D) View level
