Master Hibernate and JPA with Spring Boot in 100 Steps - Step 69 - Custom Queries Using Spring Data JPA Repository

The video tutorial covers the use of JPA repository methods, including CRUD operations, pagination, and sorting. It then delves into creating custom queries using Spring Data JPA, demonstrating how to define methods like 'find by name' and use multiple parameters. Advanced techniques such as named and native queries are also explored, showing how to execute specific queries when default methods are insufficient.

What are the default methods provided by JPA repository?

• Only CRUD operations

• Only sorting

• CRUD operations, pagination, and sorting

• Only pagination

How can you create a custom query method to find courses by name?

• By defining a method with 'findByName' in the interface

• By using a third-party library

• By writing a SQL query directly

• By modifying the database schema

What is the purpose of using multiple parameters in a query method?

• To increase the complexity of the query

• To refine the search criteria

• To decrease the performance

• To make the code harder to read

How can you sort the results of a query by ID in descending order?

• By using 'orderByIdDesc'

• By using 'sortByIdDescending'

• By using 'orderByIdDescending'

• By using 'sortByIdDesc'

What happens when you define a method with 'deleteBy' in the interface?

• It deletes the method itself

• It deletes all rows in the table

• It deletes rows matching the criteria

• It deletes the entire database

What is a named query in Spring Data JPA?

• A query with a specific name defined in the code

• A query that is executed randomly

• A query that is automatically generated

• A query that is not used

What is the advantage of using native queries in Spring Data JPA?

• They are automatically optimized

• They are faster than JPQL

• They allow for more complex queries

• They are easier to write