Orpak Systems Interview Questions and Answers

Q1. Explain joins in SQL
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Types of 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

• ...read more
Answered by AI
Add your answer
Q2. What are object and class in OOPs?
Ans. 
Objects are instances of classes in OOPs. Classes are blueprints for creating objects with attributes and methods.
• Objects are instances of classes

• Classes are blueprints for creating objects

• Classes define attributes and methods for objects

• Example: Class 'Car' with attributes like 'color' and methods like 'drive'
Answered by AI
Add your answer

I was asked to implement lru cache which i did but still didn’t made to next round as apparently i didn’t complete the working code though in my opinion i did

SQL and quant, logical questions were asked.

Q1. 1. Tell me about your self 2. Resume based questions 3. Need to write basic SQL queries and also print same output using pandas
Add your answer

Q1. 1. Tell me about your self 2. Statistics questions 3. Guestimates 4. Why do you want to join company
Add your answer

Android basic + DSA and problem solving

Q1. Android in depth
Ans. 
Android is a mobile operating system developed by Google, based on the Linux kernel.
• Android is open-source and allows developers to create applications using Java or Kotlin.

• Android apps can be distributed through the Google Play Store or other third-party app stores.

• Android supports a wide range of devices, from smartphones and tablets to smart TVs and wearables.

• Android provides a rich set of APIs for accessing device ...read more
Answered by AI
Add your answer

Medium DSA question on dynamic programming

HackerRank Test - 2 Medium Questions
1. Given an Array Weights of Chocolates, Find Maximum amount of Chocolate that can be saved after "d" days, if you eat half the weight of one of the chocolates every day.
2. Find Closest String with equal number of vowels and consonants.

Q1. Question on DSA, Trees
Add your answer

Mathematics, logical reasoning

C/C++, device driver, Networking, objectives