Q3 Technologies SQL Developer Interview Questions and Answers

Q1. Explain event loop nodejs.
Ans. 
Event loop in Node.js manages asynchronous operations by executing callbacks when certain events occur.
• Event loop is a single-threaded mechanism that allows Node.js to perform non-blocking I/O operations.

• It continuously checks the call stack for any functions that need to be executed, as well as the callback queue for any functions that are ready to be executed.

• Event loop prioritizes the execution of I/O operations and...read more
Answered by AI
Add your answer
Q2. Write the code for quick sort
Ans. 
Quick sort is a popular sorting algorithm that uses divide and conquer approach.
• Divide the array into two sub-arrays based on a pivot element

• Recursively sort the sub-arrays

• Combine the sorted sub-arrays to get the final sorted array
Answered by AI
Add your answer

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

Reasoning, maths, Devops, AI, ML

Q1. What are semantic tags in HTML?

Ans. 

Semantic tags in HTML are specific tags that provide meaning to the content they enclose.

• Semantic tags help search engines and screen readers understand the structure of a webpage.

• Examples of semantic tags include

  ,

• Using semantic tags improves SEO and accessibility of a website.

Add your answer