PowerSchool India Associate Software Engineer Interview Questions, Process, and Tips

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

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

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

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

Q1. Q1 difference between let and const
Ans. 
let is mutable and can be reassigned, const is immutable and cannot be reassigned
• let allows reassignment of values, const does not

• const must be initialized with a value, let can be declared without a value

• const is block-scoped, let is function-scoped
Answered by AI
Add your answer
Q2. Q2 what are closures?
Ans. 
Closures are functions that have access to variables from their containing scope even after the parent function has finished executing.
• Closures allow functions to maintain access to variables from their parent scope

• They are created when a function is defined within another function

• Closures are commonly used in event handlers and callbacks
Answered by AI
Add your answer
Q3. Q3. What is typeof null
Ans. 
typeof null returns 'object' in JavaScript.
• typeof null is 'object' in JavaScript

• This is a historical bug in JavaScript that has not been fixed for backward compatibility

• Example: console.log(typeof null) will output 'object'
Answered by AI
Add your answer

Q1. Q1. Find palindrome strings in an array of strings.
Ans. 
Finding palindrome strings in an array of strings.
• Iterate through each string in the array.

• For each string, check if it is equal to its reverse to determine if it is a palindrome.

• Store palindrome strings in a separate array or print them out.
Answered by AI
Add your answer
Q2. Q2. Explain debouncing with example.
Ans. 
Debouncing is a technique used to limit the rate at which a function is called.
• Debouncing is used to prevent multiple rapid calls to a function, typically in response to user input.

• It involves setting a delay before allowing the function to be called again.

• Example: Debouncing a search input field to only trigger the search function after the user has stopped typing for a certain period.
Answered by AI
Add your answer