DBMS Architecture Quiz

What does DBMS stand for?

• Database Model System

• Data Management Base System

• Data Base Management System

• Database Management System

Which architecture allows direct access to the database by the user?

• 1-Tier Architecture

• 2-Tier Architecture

• 3-Tier Architecture

• Multi-Tier Architecture

What is a major disadvantage of 1-Tier Architecture?

• Not used in industry

• Scalability

• Cost

• Complexity

Which architecture is known for being cost-effective and easy to implement?

• Distributed Architecture

• 1-Tier Architecture

• 2-Tier Architecture

• 3-Tier Architecture

In 2-Tier Architecture, what is the role of the server side?

• User interface

• Client application

• Query processing

• Data storage

What is a key advantage of 2-Tier Architecture?

• High complexity

• Poor performance

• Limited scalability

• Easy access to the database

What does 3-Tier Architecture introduce between the client and server?

• Direct communication

• An application server

• A user interface

• A database

Which of the following is NOT an advantage of 3-Tier Architecture?

• Improved security

• Data integrity

• Enhanced scalability

• Simplicity

What is the primary focus of Data Independence?

• Data retrieval speed

• Changing database schema

• Maintaining data integrity

• User access control

What does Physical Data Independence allow?

• Modifying logical schema

• Altering user views

• Updating application programs

• Changing physical schema without affecting logical schema