The Annet Group 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

Basic aptitude asked for all company

One question to find substring of string which has double chars

Q1. Basic oops and sql
Add your answer
Q2. Write pandas for dataframe
Ans. 
Pandas is a Python library used for data manipulation and analysis, including creating and working with dataframes.
• Import the pandas library: import pandas as pd

• Create a dataframe: df = pd.DataFrame(data)

• Accessing data in a dataframe: df['column_name']

• Filtering data in a dataframe: df[df['column_name'] > value]

• Adding a new column: df['new_column'] = values
Answered by AI
Add your answer

Q1. Give angle betweeen hour hand and min hand art 12:20
Ans. 
The angle between the hour hand and minute hand at 12:20 is 10 degrees.
• Calculate the angle made by the hour hand from 12 o'clock position: (20/60)*30 = 10 degrees

• Calculate the angle made by the minute hand from 12 o'clock position: (20/60)*360 = 120 degrees

• Find the difference between the two angles: 120 - 10 = 110 degrees
Answered by AI
Add your answer
Q2. Basic operating system questions
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

The test had 2 standard DSA questions and 9 MCQs based on CS fundamentals.

Q1. Two Sum Of leetcode
Ans. 
Given an array of integers, return indices of the two numbers such that they add up to a specific target.
• Use a hashmap to store the difference between the target and current element

• Iterate through the array and check if the current element's complement exists in the hashmap

• Return the indices of the two numbers if found
Answered by AI
Add your answer
Q2. SQL Top 2 candidates query
Add your answer

Q1. JWT authentication and authorisation.
Add your answer

Q1. Run tasks on Code Sandbox
Ans. 
Code Sandbox allows running tasks for front-end development
• Open Code Sandbox and create a new project

• Add necessary dependencies and files

• Run tasks using npm scripts or command line

• Examples: build, start, test
Answered by AI
Add your answer

Pattern question has been provided to me

Q1. Write html code for form
Ans. 
HTML code for a basic form
• Use the <form> tag to create a form

• Include <input> tags for user input fields

• Use <button> tag for submit button
Answered by AI
Add your answer
Q2. Difference between candidate key and foreign key
Ans. 
Candidate key uniquely identifies a record in a table, while foreign key establishes a relationship between two tables.
• Candidate key is a unique key that can be used to uniquely identify a record in a table.

• Foreign key is a key that establishes a relationship between two tables.

• Candidate key can be a primary key or a unique key, while foreign key references a primary key in another table.

• Example: In a 'students' table,...read more
Answered by AI
Add your answer