Filter interviews by
Clear (1)
Use pagination, indexing, caching, and query optimization to fetch 1 lakh entries efficiently from the database.
Implement pagination to fetch data in smaller chunks
Create indexes on columns frequently used in queries
Use caching to store frequently accessed data
Optimize queries by avoiding unnecessary joins and using appropriate indexes
Consider using database-specific optimizations like query hints or stored procedures
I was interviewed in Jan 2022.
Round duration - 60 Minutes
Round difficulty - Medium
The round started with the Introduction followed by the discussion of projects done mentioned in my resume(all related to Machine Learning and Deep Learning). Then the recruiter asked me about my previous company experience and the work which I was doing there. After the discussion, interviewer started asking basic questions of SQL and PLSQL.
Round duration - 70 Minutes
Round difficulty - Hard
Interviewer directly started asking questions in SQL,PLSQL AND SHELL SCRIPTING
SQL query to find the second highest salary
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to limit the result to the second row
Use a subquery to exclude the highest salary from the result
Tip 1 : Remember all the basic commands and their syntax in PLSQL
Tip 2 : Try to optimize the query being asked in the interview.
Tip 1 : No false things.
Tip 2 : Highlight your achievements and skills.
I applied via Campus Placement and was interviewed before Jul 2022. There were 4 interview rounds.
Coding round with 3 DSA questions and a few MCQs on aptitude.
I was interviewed before May 2021.
Round duration - 60 Minutes
Round difficulty - Medium
Online Technical Interview ( Coding Round) with 2 medium-hard problem
You are given a long type array/list ARR
of size N
, representing an elevation map. The value ARR[i]
denotes the elevation of the ith
bar. Your task is to determine th...
Calculate the total amount of rainwater that can be trapped between given elevations in an elevation map.
Iterate through the array to find the maximum height on the left and right of each bar.
Calculate the amount of water that can be trapped above each bar by taking the minimum of the maximum heights on the left and right.
Sum up the trapped water above each bar to get the total trapped water for the elevation map.
You are provided with an unsorted array/list ARR
of N
integers. Your task is to determine the length of the longest consecutive sequence present in the array...
Find the length of the longest consecutive sequence in an unsorted array of integers.
Iterate through the array and store each element in a set for constant time lookup.
For each element, check if it is the start of a sequence by looking for its previous number in the set.
Update the length of the current consecutive sequence and track the longest sequence found so far.
Return the length of the longest consecutive sequence...
Round duration - 60 Minutes
Round difficulty - Medium
Online Technical Coding Interview
Develop a Stack Data Structure to store integer values using two Queues internally.
Your stack implementation should provide these public functions:
Implement a stack using two queues to store integer values with specified functions.
Create a stack using two queues internally
Implement functions for push, pop, top, size, and isEmpty
Handle edge cases such as empty stack or invalid data
Ensure the stack functions work correctly and efficiently
Test the implementation with sample inputs and outputs
Given a binary tree, your task is to print the left view of the tree. The left view of a binary tree contains the nodes visible when the tree is viewed from the left side.
Print the left view of a binary tree, containing nodes visible from the left side.
Traverse the tree in a level order manner and print the first node at each level.
Use a queue to keep track of nodes at each level.
Handle null nodes represented by -1 in the input.
Tip 1 : Practice problem solving as much as you can
Tip 2 : Try to solve online coding problem as much as possible to get good understanding of DSA
Tip 3 : Be confident with your Resume
Tip 1 : Should have some projects on resume
Tip 2 : Resume sections should be clear and no false information
Bharti Airtel interview questions for designations
I was interviewed in Oct 2020.
Round duration - 90 minutes (60 minutes for coding and 30 minutes for MCQs)
Round difficulty - Medium
The test was conducted in the evening from 7:00 pm to 8:30 pm. Because of the covid situation, the test was online and was given by all the students from their home.
Login window of 15 minutes was given and all students were supposed to login within initial 15 minutes (between 7:00 and 7:15 pm). The test was conducted on AMCAT and webcam was on during the whole test duration.
There were two sections in the test: 1.) Coding round with 2 coding questions - 60 minutes (2.) MCQ round with 30 MCQs - 30 minutes
120 students appeared for this round and 20 were shortlisted for further process.
You are given a string 'S' of length 'N'. Your task is to find the frequency of each character from 'a' to 'z' in the string.
S : abcdg
1...
Given a string, find the frequency of each character from 'a' to 'z' in the string.
Create an array of size 26 to store the frequency of each character from 'a' to 'z'.
Iterate through the string and increment the count of the corresponding character in the array.
Print the array of frequencies as the output for each test case.
You are given two strings 'A' and 'B'. While string 'A' is constant, you may apply any number of left shift operations to string 'B'.
Your task is to calcu...
Calculate the minimum number of left shift operations needed to achieve the longest common prefix between two strings.
Apply left shift operations to string B to find the longest common prefix with string A
Count the number of left shifts needed to achieve the longest common prefix
Return the minimum number of left shift operations for each test case
Round duration - 50-60 minutes
Round difficulty - Medium
This round started at 11 am and went till 3 pm.
Out of 120 students that appeared in online coding test, 20 were shortlisted for the first round of interviews.
In this round, everyone was asked some moderate level coding questions. We were supposed to write the code in our IDE, present the screen and show the interviewer the output of our code.
The interview started with the introduction being followed by 2 coding problems.
Ninja enjoys working with numbers, and as a birthday challenge, his friend provides him with an array consisting of both positive and negative integers. Ninja is curious to ...
Find the length of the longest subarray with zero sum in an array of integers.
Iterate through the array and keep track of the running sum using a hashmap.
If the running sum is seen before, the subarray between the current index and the previous index with the same sum is a subarray with zero sum.
Update the length of the longest subarray with zero sum as you iterate through the array.
Example: For arr1 = [1, -1, 3, 2, -2...
Round duration - 20 minutes
Round difficulty - Medium
7 students were shortlisted for the HR round. This round started at 7:30 pm and went till 8:30 pm.
Like all the other rounds, this round too was virtual (on google meet). In the beginning, the interviewer introduced himself and then asked questions based on my resume.
All the 7 candidates were selected in the HR round.
Tip 1 : Questions are asked on DSA, so practice questions and it is not the number of questions you practice, but how well you practice the questions. Prepare a notebook and write down the approach you follow. Make proper notes and maintain that notebook. Will help for quick revision.
Tip 2 : Conceptual questions are asked from topics other than DSA. So watching videos on youtube will not help. Read the book thoroughly to make yourself ready for interviews.
Tip 3 : ALWAYS read about the real-life examples of the concepts you read. This is often asked in interviews and you will definitely regret failing to answer this question.
Tip 1 : Having projects in resume will help you to give the direction to your interview, which increases the chances of selection.
Tip 2 : Add some achievements other than academics, it shows that you are a team player and increases the probability of getting shortlisted. BUT do not write anything that is not true or else, it will backfire.
Get interview-ready with Top Bharti Airtel Interview Questions
Top trending discussions
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
Mcq based on language
STL knowledge and finding loop in linked list
STL (Standard Template Library) is a C++ library that provides containers, algorithms, and iterators.
To find a loop in a linked list, we can use Floyd's cycle-finding algorithm.
In this algorithm, we use two pointers, one moving at a slower pace and the other at a faster pace.
If there is a loop in the linked list, the faster pointer will eventually catch up to the slower poin...
based on 3 interviews
Interview experience
based on 15 reviews
Rating in categories
Assistant Manager
2.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Network Engineer
1.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Accounts Manager
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Territory Sales Manager
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Jio
Vodafone Idea
TCS
Infosys