Free Test Database System Archit... – Databas...

Q1: What is the primary component of a DBMS architecture?

A. Database Engine B. Operating System C. Web Browser D. Compiler

Q2: Which architecture layer handles user interactions?

A. External level B. Conceptual level C. Internal level D. Physical level

Q3: What does the conceptual level describe?

A. Overall logical structure of the database B. Physical storage details C. User views D. Hardware configuration

Q4: Which level of DBMS architecture describes physical storage?

A. Internal level B. External level C. Conceptual level D. User level

Q5: Which of the following is NOT part of the three-schema architecture?

A. Physical schema B. Conceptual schema C. External schema D. Internal schema

Q6: Which component is responsible for query optimization?

A. Query Processor B. Storage Manager C. Transaction Manager D. Buffer Manager

Q7: The storage manager does NOT handle?

A. Buffer management B. Query parsing C. File management D. Disk space allocation

Q8: What is the role of the transaction manager?

A. Ensures database consistency during transactions B. Manages user interface C. Controls network communication D. Handles hardware errors

Q9: Which of the following is a part of DBMS software?

A. Data definition language compiler B. Operating system C. Network router D. Web browser

Q10: The buffer manager handles?

A. Managing data in main memory B. Writing user applications C. User authentication D. Query optimization

Q11: Which layer of DBMS hides physical storage details from users?

A. Conceptual layer B. Internal layer C. External layer D. Physical layer

Q12: Which component translates high-level queries into low-level instructions?

A. Query Processor B. Storage Manager C. Transaction Manager D. Authorization Manager

Q13: Data independence refers to?

A. Ability to change schema without affecting applications B. Ability to store large data C. Ability to process queries faster D. Ability to backup data easily

Q14: Physical data independence means?

A. Changes in internal schema do not affect conceptual schema B. Changes in conceptual schema do not affect external schema C. Changes in user view D. Changes in application code

Q15: Logical data independence means?

A. Changes in conceptual schema do not affect external schemas B. Changes in physical storage C. Changes in user interfaces D. Changes in network setup

Q16: Which architecture separates user views from physical database?

A. Three-schema architecture B. Two-tier architecture C. Client-server architecture D. Peer-to-peer architecture

Q17: Which layer is closest to the physical storage?

A. Internal layer B. Conceptual layer C. External layer D. User layer

Q18: What does the data dictionary contain?

A. Metadata about the database B. Actual data C. User programs D. Hardware specifications

Q19: Which component handles concurrency control?

A. Transaction Manager B. Query Processor C. Storage Manager D. Buffer Manager

Q20: The internal schema defines?

A. Physical storage structure B. User views C. Conceptual design D. Network settings

Quiz for Database System Architecture