18 Questions
What is the purpose of a database dump?
To backup the database schema and records as SQL statements
In database terms, what does 'CSV' stand for?
Comma Separated Values
What issue complicates backing up databases?
Gaining exclusive access for a consistent copy
In a one-tier application architecture, where are the front-end, processing logic, and the database engine hosted?
On the same computer
What is the primary characteristic of a two-tier client-server application architecture?
Separates the presentation layer from the application layer
Which file format is commonly used to export data from databases to MS Excel?
.XLSX
What is the main purpose of the presentation layer in a three-tier application architecture?
To provide the client front-end and user interface
In a three-tier application, where does the application layer typically run?
On the server or server cluster that the client connects to
Why should the client have no direct communications with the data tier in a three-tier application architecture?
To prevent unauthorized access to the data tier
How is a 'layer' different from a 'tier' in the context of application architecture?
A layer is an independent processing function while a tier is a logical function
When using an n-tier application architecture, what could be implemented as virtual machines?
Application layers
What is an alternative use of an n-tier application architecture besides two-tier or three-tier models?
Complex architectures with separate access control services
What is the purpose of a database in the context of structured databases?
To provide a permanent storage solution for data
Which application architecture model involves all layers being on the same system like a desktop application?
One-tier architecture
In the context of database structures, what does 'schema' refer to?
A collection of metadata that defines the database structure
What is a key feature of non-relational databases like document databases?
Storage of data in flexible, document-based formats
Which aspect is NOT typically associated with a one-tier application architecture?
Scalability challenges
What is one key advantage of exporting data from databases for analytical purposes?
Allowing for detailed insights and trend analysis
Test your knowledge about the different layers in a three-tier application setup, including the presentation, application, and data layers. Learn about how requests are handled from the client front-end to the data layer at the back-end.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free