Pervacio Interview Questions and Answers

Q1. Types of SQL Joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left tab...read more
Answered by AI
Add your answer
Q2. Machine Learning algorithms and coding
Add your answer

Overivew of the previous company project, and question about the system design ex LRUCache system and IRCTC DB design

2nd Round -
Basic Interview, Mostly system Design Question.

Simple staright forward necessary domain questions

Q1. What are joins you have worked onshowcase. Them
Add your answer
Q2. What is query folding power query
Ans. 
Query folding in Power Query is the process of pushing data transformation steps back to the data source for more efficient query execution.
• Query folding helps optimize query performance by minimizing data transfer between the data source and Power Query.

• It allows Power Query to generate and execute SQL queries against the data source instead of loading all data into memory for processing.

• Query folding is particularly ...read more
Answered by AI
Add your answer
Q3. What are earlier projects worked on
Add your answer
Q4. How to you handle load effectively
Ans. 
I handle load effectively by prioritizing tasks, delegating when necessary, and utilizing time management techniques.
• Prioritize tasks based on deadlines and importance

• Delegate tasks to team members to distribute workload

• Utilize time management techniques such as Pomodoro technique or Eisenhower matrix

• Stay organized with to-do lists and calendars

• Communicate with team members to ensure everyone is on the same page
Answered by AI
Add your answer
Q5. Walk through the challenges you faced
Add your answer

Q1. Discuss 4 case study related to supply chain management.
Add your answer

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

Q1. 
Sum of Two Numbers Represented as Arrays
Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...read more
Ans. 
Given two numbers represented as arrays, calculate their sum and return the result as an array.
• Iterate through the arrays from right to left, adding digits and carrying over if necessary

• Handle cases where one array is longer than the other by considering the remaining digits

• Ensure the final sum array does not have any leading zeros
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.