PowerSchool India Associate Software Engineer Interview Questions and Answers for Freshers

First round was coding test in online platform with 5 questions

Q1. Settings a server in Express JS
Ans. 
Setting up a server in Express JS involves creating an instance of the Express application and defining routes.
• Create an instance of the Express application using the 'express' module

• Define routes using the 'app.get', 'app.post', etc. methods

• Listen for incoming requests using the 'app.listen' method

• Configure middleware using the 'app.use' method

• Handle errors using the 'app.use' method with an error handling middleware
Answered by AI
Add your answer
Q2. What are all join table query and Write an example to join 2 tables.
Ans. 
Explaining join table query and providing an example of joining 2 tables.
• Join table query is used to combine data from two or more tables based on a related column between them.

• Types of join include inner join, left join, right join, and full outer join.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer

Q1. Manual testing interview questions like sanity, smoke regression etc with basic SQL queries.
Add your answer
Q2. Automation based questions
Add your answer

Q1. Automation based questions
Add your answer

Via placement got this oppurtunity asked base questions
Coding test on java for factorial all ways
Database qstns

Q1. Polyfills and Logical
Add your answer
Q2. List in react and the input box
Ans. 
Answer on how to list in react and the input box
• Use the map function to create a list in React

• Use the state to store the input value

• Use onChange event to update the state when the input value changes

• Use onSubmit event to handle the form submission
Answered by AI
Add your answer

Q1. Check if string is palindrome
Ans. 
Check if a string is the same forwards and backwards
• Iterate through the string from both ends and compare characters

• Use built-in functions like reverse() to check for palindrome

• Ignore spaces and punctuation when checking for palindrome
Answered by AI
Add your answer

Python technical SQL basic

Two dynamic programming challenges at the hard level on LeetCode and 10 medium-level SQL challenge.

Q1. What is react, diff between react and angular, deep copy shallow copy, hoisting, diff between props and state
Ans. 
React is a JavaScript library for building user interfaces. It is different from Angular in various ways.
• React is a library while Angular is a framework

• React uses virtual DOM while Angular uses real DOM

• React is more flexible and easier to learn than Angular

• Deep copy creates a new object with the same values while shallow copy creates a new reference to the same object

• Hoisting is a JavaScript mechanism where variables a...read more
Answered by AI
Add your answer
Q2. Implement custom hooks and array flat method
Ans. 
Implement custom hooks and array flat method
• Custom hooks are reusable functions that allow you to extract component logic into reusable functions

• Array flat method is used to flatten an array of nested arrays into a single array

• To implement custom hooks, create a function that uses the useState and useEffect hooks

• To implement array flat method, use the reduce method to flatten the array
Answered by AI
Add your answer