ONPASSIVE UI Developer Interview Questions and Answers

HackersRank 2 questions

Q1. Context API's in react
Ans. 
Context API is a feature in React that allows sharing data between components without having to pass props through every level of the component tree.
• Context API provides a way to pass data through the component tree without having to pass props down manually at every level.

• It is useful for sharing global data such as themes, user authentication, or language preferences.

• Context API consists of three main parts: Provider...read more
Answered by AI
Add your answer
Q2. Hooks in react js
Ans. 
Hooks in React JS are functions that let you use state and other React features without writing a class.
• Hooks were introduced in React 16.8 to allow functional components to have state and lifecycle methods.

• useState() is a hook that allows you to add state to functional components.

• useEffect() is a hook that allows you to perform side effects in functional components.

• Custom hooks are reusable functions that can contain ...read more
Answered by AI
Add your answer

Q1. COnteaxt API, Hooks, Redux etc
Add your answer
Q2. React lifecycle and some basic sorting/searching alogo questions
Add your answer

Q1. It was mainly java, interviewers are very good and supportive to elaborate more about problem.
Add your answer
Q2. Scenario based on your earlier work experience
Add your answer

Q1. What is your approach to building basic logic skills?
Ans. 
My approach to building basic logic skills involves practicing problem-solving exercises, breaking down complex problems into smaller parts, and seeking feedback to improve.
• Practice problem-solving exercises regularly to strengthen logical thinking abilities.

• Break down complex problems into smaller, more manageable parts to better understand the problem and find solutions.

• Seek feedback from peers or mentors to identify...read more
Answered by AI
Add your answer

Q1. Some behavioural questions?
Add your answer

Q1. How do you optimize Stored procedure
Ans. 
Optimizing stored procedures involves using proper indexing, reducing unnecessary loops, and minimizing database calls.
• Use proper indexing on columns used in WHERE clauses to improve query performance

• Avoid using cursors and loops whenever possible, as they can be inefficient

• Minimize the number of database calls by combining multiple queries into a single query or using temporary tables

• Consider using bulk processing tec...read more
Answered by AI
Add your answer
Q2. How do you optimize SQL query
Ans. 
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
• Use indexes on columns frequently used in WHERE clauses

• Minimize data retrieval by selecting only necessary columns

• Avoid unnecessary joins by using EXISTS or IN clauses instead

• Optimize query structure by using appropriate join types and conditions
Answered by AI
Add your answer
Q3. What is use of returning clause
Ans. 
Returning clause is used to return a value from a function or procedure in PL/SQL.
• Used to return a single value from a function or procedure

• Can be used to return multiple values using OUT parameters

• Helps in passing values back to the calling program
Answered by AI
View 1 more answer
Q4. Disadvantages of triggers
Ans. 
Triggers can lead to performance issues, complexity, and potential for unintended consequences.
• Triggers can make code harder to debug and maintain

• They can lead to cascading effects if not carefully implemented

• Performance can be impacted if triggers are not optimized

• Triggers can introduce dependencies between different parts of the codebase
Answered by AI
Add your answer

Q1. Core java, advanced java, spring boot, Hibernate, database
Add your answer
Q2. Design pattern, previous project experience
Add your answer

The interview will last for 30 minutes and will include basic Node.js questions, followed by two coding questions.