Recently, I was interviewed for a Java Developer profile requiring 2 years of experience. It was an average interview that consisted of 4 rounds.

The 1st and 2nd rounds were technical interviews. The 3rd round was a managerial interview. The last round was an HR interview.

There were average kinds of questions from J2SE, Spring Frameworking, Data Structures like Sorting, and SQL. The managerial round was a bit scenario-based, related to real-time issues in a project.

Can we use static variables inside static methods?

Can we use the final keyword with the constructor?

Difference between List and ArrayList?

What are the different bean scopes in Spring?

Difference between StringBuffer and StringBuilder?

Difference between Post and Put in Spring REST.

How to get the second highest salary from the table?

Difference between Inner Join and Outer Join.

Code to sort an array without using any predefined classes and methods.

Explain the MVC design pattern with a diagram.

Difference between Application Server and Web Server.

A login page is validating user ID and password by getting details from the database. However, as the database has billions of rows, it is taking a long time to fetch the data from the database, hence throwing errors. What should be the short-term and long-term solutions for this issue?