Office Banao Interview Questions and Answers

Q1. Core java based questions, followed by springboot and then sql queries
Add your answer

Q1. Scenario based java and spring boot questions and more complex sql queries
Add your answer

Q1. Previous project related questions like difficulty faced in project, how you overcome that, day to day routine, discussed role in projects
Add your answer

Q1. Salary discussion and onboarding instructions
Add your answer

2 coding questions .
topics were array and string

Q1. 2D array question and a linkedlist question (find the middle element of the list)
Add your answer
Q2. Dbms questions like keys ,normalization, acid properties, types of network layer , deadlock in os
Add your answer

Q1. Detect loop in a linkedlist
Ans. 
Use Floyd's Tortoise and Hare algorithm to detect loop in a linked list.
• Initialize two pointers, slow and fast, at the head of the linked list.

• Move slow pointer by one step and fast pointer by two steps.

• If they meet at any point, there is a loop in the linked list.
Answered by AI
Add your answer
Q2. SQL queries basic level .
Add your answer

Q1. Oops questions like inheritance and interface
Add your answer
Q2. Sql queries from leetcode hard level
Add your answer

Q1. ACID Properties
Ans. 
ACID properties are a set of properties that guarantee reliable and consistent transactions in a database system.
• Atomicity ensures that either all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a valid state before and after the transaction.

• Isolation ensures that the concurrent execution of transactions results in a system state that would be obtai...read more
Answered by AI
Add your answer
Q2. What are Idempotent HTTP Requests?
Ans. 
Idempotent HTTP requests are requests that can be repeated multiple times without changing the result beyond the initial request.
• Idempotent requests have the same outcome no matter how many times they are executed.

• GET, PUT, and DELETE HTTP methods are typically idempotent.

• POST requests are not idempotent as they can create new resources with each execution.
Answered by AI
Add your answer
Q3. Questions regarding your project, and how did you learn from the projects and tasks assigned to you?
Add your answer
Q4. System Design
Add your answer

Q1. About yourself, your past work experience and why you want to get into this role The interviewer was very calm and just wanted to learn about the background.
Add your answer

Q1. All behavioural questions- 1 how do your prioritise your work? 2 do you have experience in managing cross functional teams? 3 what if one of your Co-worker decline working on a project, How would you tackl...read more
Add your answer

Q1. Again all behavioural questions- How do you work with large volume of works? How do you manage work life balance? How do you give harsh feedbacks to your coworkers?
Add your answer

Q1. All behavioural questions again- same as above just a bit here and there asked in different ways
Add your answer

Q1. Questions related to devops tools such as azure terraform kubernetes.
Add your answer
Q2. Java concurrency and exception handling
Add your answer

Q1. Why do you want to join this organization?
Add your answer
Q2. Expected salary
Add your answer

Q1. What is the SQL query used to remove duplicates from a dataset?
Ans. 
Use the DISTINCT keyword in a SELECT query to remove duplicates from a dataset.
• Use the SELECT DISTINCT statement to retrieve unique rows from a table

• Example: SELECT DISTINCT column1, column2 FROM table_name;

• Another way is to use the GROUP BY clause with aggregate functions like COUNT() or SUM() to remove duplicates
Answered by AI
Add your answer
Q2. What is the SQL query to find the third highest salary in a table?
Ans. 
Use a subquery to find the third highest salary in a table using SQL.
• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the results to the third row.

• Use a subquery to select the third highest salary from the sorted list.
Answered by AI
Add your answer

Q1. What are the different roles in Power BI?
Ans. 
Different roles in Power BI include Power BI Developer, Power BI Analyst, Power BI Administrator, and Power BI User.
• Power BI Developer - responsible for creating and maintaining Power BI reports and dashboards

• Power BI Analyst - analyzes data using Power BI to provide insights and recommendations

• Power BI Administrator - manages security, access, and data sources in Power BI

• Power BI User - consumes reports and dashboards
Answered by AI
Add your answer
Q2. SQL - basicand advanced questions
Add your answer

Q1. Two sum problem.
Add your answer

Q1. System Design concepts
Add your answer

Q1. Database design and principles
Add your answer

Q1. Final discussion and job offer
Add your answer

Mostly questions on logical aptitude

Q1. DSA questions. Reverse word of string, bubble sort, swap two variables without use of third variable
Add your answer
Q2. OOPs concepts also some questions on project
Add your answer
Q3. 1 puzzle (refer gfg)
Add your answer

Q1. Why do you want to work at our company?
Add your answer
Q2. What was the toughest challenge you have ever faced?
Add your answer