PowerSchool India Software Engineer Interview Questions and Answers

Q1. Java, java script,html,css
Add your answer

Q1. JbeiuJNEKA DIOAJSD
Add your answer

Q1. Question on Binary trees: if symmetric, easy string question using hashmap
Add your answer
Q2. If we are hosting a live test how to show real time ranking, HLD for this and what algorithms can we use
Add your answer

Q1. Database schema design for a feature where user can be free, gold, platinum.
Ans. 
Use a user table with a column for user type (free, gold, platinum)
• Create a user table with columns for user ID, name, email, user type

• Use a separate table for user types with columns for type ID and type name

• Establish a one-to-many relationship between user and user type tables

• Example: user table - user_id, name, email, type_id; user_type table - type_id, type_name
Answered by AI
Add your answer

Q1. HLD for live rank dashboard for a live test where millions of users are doing test
Ans. 
High-level design for a live rank dashboard for a live test with millions of users.
• Use a scalable architecture to handle millions of users concurrently.

• Implement real-time data processing to update ranks dynamically.

• Utilize caching mechanisms to improve performance and reduce load on the database.

• Design a user-friendly interface with intuitive data visualization.

• Include features for filtering, sorting, and searching to
Answered by AI
Add your answer

Q1. What is angular pipes
Ans. 
Angular pipes are used in Angular applications to transform data before displaying it in the view.
• Angular pipes are used to format data in the template.

• They can be used to transform data such as currency, dates, and text.

• Pipes can be chained together for more complex transformations.

• Custom pipes can also be created for specific formatting needs.
Answered by AI
Add your answer
Q2. What is routing
Ans. 
Routing is the process of selecting a path for network traffic to travel from one point to another.
• Routing involves determining the best path for data packets to travel through a network.

• Routers use routing tables to make decisions on how to forward packets.

• Routing protocols like OSPF and BGP help routers communicate and update routing information.

• Examples of routing include IP routing in the internet and routing withi
Answered by AI
Add your answer

Q1. What is auth gurd
Ans. 
Auth guard is a feature in software development that restricts access to certain resources based on user authentication.
• Auth guard is commonly used in web applications to control access to certain pages or features.

• It checks if a user is authenticated before allowing them to access a specific resource.

• Examples include restricting access to admin pages or requiring login to view certain content.
Answered by AI
Add your answer
Q2. What is interceptor
Ans. 
An interceptor is a middleware component that intercepts incoming requests and outgoing responses in a web application.
• Interceptors can be used for logging, authentication, authorization, error handling, and more

• In Angular, interceptors can be used to modify HTTP requests before they are sent to the server or responses before they are returned to the calling code
Answered by AI
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

Round duration - 120 minutes
Round difficulty - Easy

It was a mix of mathematical aptitude, logical ability, and puzzles along with 2 programming questions of easy and medium level. Time was enough and no sectional time was present. 1-2 MCQs on SQL were also present.

This round was immediately followed by an SHL aptitude test which was basically a quick limited time check of your verbal ability and math because many questions were to be done in 1 hour.

Q1. Boolean Matrix
Given a 2-dimensional boolean matrix mat of size N x M, modify the matrix such that if an element is 1, set its entire row and column to 1 i.e. if mat[i][j] = 1, then make all the elements o...read more
Ans. 
You need to make the modifications in the input matrix.
You do not need to print anything, it has already been taken care of.
Answered by CodingNinjas
View 2 more answers

Round duration - 60 minutes
Round difficulty - Easy

It was an online video interview round on HackerEarth with simultaneous code option. It was mostly justifying your resume in the first 15 minutes. After that OOPS was majorly asked. Basics of programming including questions on STL were asked. A class which required inheritance was asked by the interviewer to write. I was helped by the interviewer if i got stuck somewhere, Some questions on implementation of hashmaps and priority queues were also asked. A puzzle was asked which luckily struct to me at that moment.

Q1. Oops Concept
Implement a class which inherits features from another class. Basically i had to provide a list of employees of a particular department. along with their salary details when i was given a depar...read more
Ans. 
I used inheritance and also used hashmaps to maintain a map of an integer for every department.
Answered by CodingNinjas
Add your answer
Q2. Puzzle
10 boxes each with 10 stones are present. each box has stones of different weight but weight in each box is uniform. Only one box has one stone of non-uniform weight. Find optimized way to find in wh...read more
Ans. 
Take 1 stone from box1, 2 from box 2 and so on.
Its a straight-forward puzzle available on internet as well.
Answered by CodingNinjas
Add your answer