SEASON 3 - Wrap up Quiz [OP]

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

• INSERT
• UPDATE
• DELETE
• SELECT

DATABASES

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

• To uniquely identify records in a table
• To establish a link between the data in two tables
• To allow duplicate values in a column
• To automatically increment a value

DATABASES

What is the main goal of database normalization?

• To reduce data redundancy and improve data integrity
• To speed up database queries
• To create duplicate data for backup purposes
• To combine multiple tables into one

DATABASES

What does the Atomicity property of a database transaction ensure?

• That a transaction is divided into smaller sub-transactions
• That a transaction is visible to other transactions
• That a transaction is executed with high performance
• That a transaction is all-or-nothing, fully completing or fully failing

DATABASES

How does JDBC achieve database independence for Java applications?

• By using a common query language
• By supporting only a single database management system
• By abstracting the database access through a standard API
• By embedding database-specific code in the application

ARCHITECTURAL PATTERNS

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

• Model -> View -> Controller
• Controller -> Model -> View
• View -> Model -> Controller
• View -> Controller -> Model

ARCHITECTURAL PATTERNS

Where is the business logic primarily located?

• In the data access layer
• In the service layer
• In the controller layer
• In the view layer

ARCHITECTURAL PATTERNS

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

• By allowing the View to directly interact with the database
• By ensuring the business logic is centralized and not tied to the presentation or data access layers
• By combining business logic with data access operations
• By merging the responsibilities of the Controller and View

ARCHITECTURAL PATTERNS

In the DAO pattern, which of the following is NOT a typical responsibility of the DAO?

• Managing database connections
• Persisting data
• Defining business rules
• Retrieving data

SOFTWARE TESTING

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

• Unit Testing
• Integration Testing
• System Testing
• Acceptance Testing