PowerSchool India Associate Software Engineer Interview Questions and Answers

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

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

Easy leetcode code 2 questions , HTML5 css javascript simple screen design

Q1. Oop, Simple coding javascript, react basic, sql basic
Add your answer

Round duration - 60 Minutes
Round difficulty - Easy

It was an coding round

Q1. 
The Skyline Problem
Compute the skyline of given rectangular buildings in a 2D city, eliminating hidden lines and forming the outer contour of the silhouette when viewed from a distance. Each building is ...read more
Ans. 
Compute the skyline of given rectangular buildings in a 2D city, eliminating hidden lines and forming the outer contour of the silhouette.
• Iterate through the buildings and create a list of critical points (x, y) where the height changes.

• Sort the critical points based on x-coordinate and process them to form the skyline.

• Merge consecutive horizontal segments of equal height into one to ensure no duplicates.

• Return the fin...read more
Answered by AI
Add your answer
Q2. 
Rat in a Maze Problem Statement
You need to determine all possible paths for a rat starting at position (0, 0) in a square maze to reach its destination at (N-1, N-1). The maze is represented as an N*N ma...read more
Ans. 
Find all possible paths for a rat in a maze from source to destination.
• Use backtracking to explore all possible paths in the maze.

• Keep track of visited cells to avoid revisiting them.

• Recursively try moving in all directions (up, down, left, right) until reaching the destination.

• Return a list of strings representing valid paths sorted in alphabetical order.
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

It was an HR round with some general questions. it was just for formality.