The questions can come in any order, so make sure you are selecting right option for all questions.
In the three-tier architecture, what functions does the Application Layer primarily handle?
(b) Business logic and application processing
What component is responsible for interacting directly with the database management system in the three-tier architecture?
What role does a database system play in business applications?
(b) Efficiently storing and retrieving business data
What is the primary purpose of a database system?
(b) To manage and organize data efficiently
What is the primary role of the Storage Management component in a database system?
(c) Organizing and managing storage structures like tables and indexes
Why is the three-tier architecture preferred in many database systems?
(c) It improves scalability and maintenance
Which layer ensures that data consistency and integrity are maintained in a three-tier DBMS architecture?
What is a primary application of a database system?
(b) Efficient data management
Which component of a database system is responsible for handling core functionality such as CRUD operations (Create, Read, Update, Delete)?
In the context of a database system, which component is responsible for optimizing SQL queries for better performance?
Why is data organization a crucial aspect of a database system?
(c) To ensure efficient storage and retrieval of information
In which of the following scenarios would a database system be most beneficial?
(b) Storing and managing large amounts of customer information for an online store
What is the primary purpose of the Presentation Layer in a three-tier DBMS architecture?
User interface and interaction
