Foray Software SQL Developer Interview Questions and Answers

Q1. How pagination work in jpa
Ans. 
Pagination in JPA allows for retrieving a subset of results from a query by specifying a limit and offset.
• Use the setFirstResult() method to specify the starting index of the results to retrieve

• Use the setMaxResults() method to specify the maximum number of results to retrieve

• Combine setFirstResult() and setMaxResults() to implement pagination in JPA queries
Answered by AI
Add your answer
Q2. How to create restful api
Ans. 
To create a RESTful API, define endpoints, use HTTP methods, handle requests and responses, and follow REST principles.
• Define endpoints for different resources (e.g. /users, /products)

• Use HTTP methods like GET, POST, PUT, DELETE for CRUD operations

• Handle requests and responses in JSON format

• Follow REST principles like statelessness, uniform interface, and client-server architecture
Answered by AI
Add your answer

Pseudocode problems and 2 coding questions

Q1. Introduction, family background, logical question of English alphabet
Add your answer

Q1. AI/ML trends, bitcoin info
Add your answer
Q2. Java code for finding even number
Ans. 
Java code to find even numbers in an array
• Iterate through the array and check if each element is divisible by 2

• Use the modulus operator (%) to check for even numbers

• Store the even numbers in a separate array or print them out
Answered by AI
Add your answer
Q3. Basic questions about technologies mentioned in the resume
Add your answer

Q1. Intro, family background
Add your answer
Q2. HTML, CSS, JAVA, CPP code
Add your answer
Q3. Logical Questions
Add your answer
Q4. Speaking Communication
Add your answer

Q1. Technology related
Add your answer
Q2. Programming related
Add your answer

Q1. Why should we choose you?
Add your answer

Q1. Be cool as a cucumber.
Add your answer

Javascript & Angular question -
1. Write piece of code to display the array item using iteration method?
2. Write piece of code for API integration using services ?
3. What is the method of data transferring in Angular Components ?
4. What is Routing ?

Q1. Angular Question 1. What is the difference between Angular 8 and Angular 12 version ? 2. What is Call Back Function ? 3. What is Life Cycle Hooks ? 4. How to handle large data transferring from Backend ?
Add your answer

Design a full frontend page ..

Q1. Basic questions about your technology
Add your answer

Q1. About your salary expectation
Add your answer

Q1. Introduction myself
Add your answer
Q2. Core based questions
Add your answer

Q1. Asked to count the top m frequent word of n length in pdf
Add your answer

Q1. Easy level aptitude questions and OOPs questions
Add your answer

Q1. A medium level programming question and question on top trending technology
Add your answer