Three Schema Architecture MCQ (Multiple Choice Questions) PDF Download

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

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

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

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

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