System Integration Reviewer

• Database Management System (DBMS)

What DBMS stands for.

• Use of tables with rows and columns

A characteristic of relational databases.

• To reduce data redundancy

The main purpose of normalization in relational databases.

• MySQL

A relational database system.

• Not Only SQL

What NoSQL stands for.

• To separate functionality, logic, and interface

The main purpose of the MVC design pattern.

• Model

The component of MVC that handles data logic and database interactions.

• Model View Controller

What MVC stands for.

• Controller

The MVC component that acts as a middleman between the Model and View.

• Displays data to the user

What the View component in MVC does.

• Handles user input and updates the Model

What the Controller does in MVC.

• Maps a GET request to the /Profile route

What the @GetMapping("/Profile") annotation does.

• To extract values from the URL path

The function of @PathVariable.

• Configures application settings like port and database

What the application.properties file does in a Spring Boot project.

• @RequestParam

The annotation used to extract query parameters from a URL.

• Eclipse Enterprise Java and Web Developer Tools 3.37

What you should install from Eclipse Marketplace to enable JSP support.

• It can read Java code

Why .jsp is used instead of .html.

• It loads actual content pages

Why @Controller is used instead of @RestController.

• addAttribute()

The method used to pass data to the view.

• ${attributeName}

How the attribute is called in JSP.

• GET

The method that appends data to the URL.

• POST

The method suitable for sending sensitive data.

•

The tag used in JSP to loop through ArrayList items.

• @PostMapping

The annotation used to handle POST requests in Spring.

• Passes data to the view

What the Model.addAttribute() method does.

• method

The attribute in an HTML

tag that specifies how form data is sent to the server.

• action

The

attribute that specifies the URL where form data should be sent.

• A way to store user data across multiple requests

What a session is in web development.

• HTTP

The protocol that is stateless and does not remember previous interactions.

• removeAttribute()

The method that removes a specific attribute from a session.

• setAttribute()

The method that stores data in a session.

• getAttribute()

The method that retrieves data from a session.

• Data Modeling

The feature that allows visual creation of tables and relationships.

• To secure database access

The purpose of creating a root account password.

• drop database ;

The command that deletes a database.

• MySQL Server stores and manages data, while MySQL Workbench provides a graphical interface to interact with that data.

The main difference between MySQL Server and MySQL Workbench.

• use ;

The command that switches to a specific database.

• To route and process web requests

The role of the HomeController in a Spring Boot application.

• @Controller

The annotation used to define a class as a Spring-managed controller.

• pom.xml

The file used to define project dependencies in a Spring Boot app.

• mysql-connector-java

The dependency that allows Java to connect to MySQL.

• @Table

The annotation that maps a class to a database table.

• @Id

The annotation that marks a field as the primary key.

• Basic CRUD operations

What CrudRepository provides.

• Injects dependencies automatically

What @Autowired does in Spring Boot.

• findAll()

The method that retrieves all records from the database.

• save()

The method used to save a new user to the database.

• Automatically generates the ID using auto

increment - The purpose of @GeneratedValue(strategy = GenerationType.IDENTITY).

• Repository

The annotation used to mark a Spring interface for database operations.

• @Service

The annotation that marks a class as a business logic component in Spring Boot.