Three Schema Architecture Multiple Choice Questions with Answers – PDF Download

MCQ 1: In the three-tier architecture, the intermediate layer between database and client servers is classified as:

1. functional server
2. transaction server
3. application server
4. disk server

MCQ 2: The architecture of database in which the characteristics such as program insulations, multiple user support and the use of catalogs are achieved is classified as:

1. multiple-schema architecture
2. single-schema architecture
3. two-schema architecture
4. three-schema architecture

MCQ 3: The process of converting the requests into results between three-schema architecture internal, external and conceptual levels is called:

1. mapping
2. pitching
3. transforming
4. dependence

MCQ 4: The levels in which the three schema architecture can be defined includes:

1. internal schema
2. conceptual schema
3. external schema
4. all of above

MCQ 5: The database management architecture in which there is middle level between database server and client server is classified as:

1. three-tier architecture
2. two-tier architecture
3. single-tier architecture
4. three way DBMS module