Q1medium
In the Three-Schema Architecture, what mechanism allows the DBMS to translate a request on an External View into a request against the Conceptual Schema, and finally into a read operation on the physical disk?
Back to Database Management Systems
9 Questions TotalUnder 10 MCQs (Noindex)
Database System Architecture MCQs
Topic-wise practice questions for Database Management Systems. Test your knowledge, check solutions on demand, and pace your preparation.
Zero-leak answer engine • Rate-limited explanations
Practice in Timed ModeQ2medium
(Diagram/Visual Interpretation) If you were to draw an architectural diagram of a modern Web Application, where does the DBMS Engine itself typically reside?
Q3medium
A developer runs the following command in their terminal. Which specific internal component of the DBMS architecture is responsible for generating the output shown?
Q4medium
In the context of database application architecture, what is the primary distinction between a 2-Tier and a 3-Tier architecture?
Q5hard
A DBA notices that queries searching for a specific user's email are too slow. They create a B-Tree index on the email column. The backend application's SQL queries remain exactly the same, but execution speed increases 10x. This is a practical example of:
Q6medium
When a database crash occurs, the recovery manager ensures that incomplete transactions are undone and committed transactions are preserved. Which file structure, maintained by the DBMS architecture, is strictly required to accomplish this?
Q7medium
Look at the SQL script below. The object hr_employee_view belongs to which level of the database architecture?
Q8hard
An application suddenly starts throwing SQLSyntaxErrorException errors. Upon investigation, you discover a DBA split a massive Customers table into two normalized tables (Customers_Core and Customers_Address). What architectural concept failed to protect the application?
Q9easy
What is the primary role of the Storage Manager module in a database system?