SEASON 3 - Wrap up Flashcard [105]

Front

DATABASES
Which SQL statement is used to retrieve data from a database?

Back

SELECT

Front

What is the purpose of a foreign key in a relational database?

Back

To establish a link between the data in two tables.

Front

What is the main goal of DATABASES normalization?

Back

To reduce data redundancy and improve data integrity.

Front

What does the Atomicity property of a database transaction ensure?

Back

That a transaction is all-or-nothing, fully completing or fully failing.

Front

How does JDBC achieve database independence for Java applications?

Back

By abstracting the database access through a standard API.

Front

In the MVC pattern, when a user interacts with the application, what is the typical sequence of component interactions?

Back

View -> Controller -> Model

Front

Where is the business logic primarily located? ARCHITECTURAL PATTERNS

Back

In the service layer

Front

How does the Service Layer pattern contribute to the decoupling of the application layers?

Back

By ensuring the business logic is centralized and not tied to the presentation or data access layers.

Front

In the DAO pattern, which of the following is NOT a typical responsibility of the DAO? Managing database connections, Persisting data, Retrieving data

Back

Defining business rules

Front

SOFTWARE TESTING Which type of testing focuses on testing individual components in isolation?

Back

Unit Testing