Filter interviews by
I appeared for an interview in Feb 2024.
To get data from one sheet to another workbook with reference data in Excel, you can use the VLOOKUP function.
Open both workbooks in Excel
In the destination workbook, select the cell where you want the data to appear
Type the formula =VLOOKUP(lookup_value, '[WorkbookName]SheetName'!table_array, col_index_num, range_lookup)
Replace [WorkbookName] with the name of the source workbook, SheetName with the name of the source ...
I applied via Naukri.com and was interviewed in Sep 2022. There were 2 interview rounds.
I applied via Indeed and was interviewed in May 2022. There were 2 interview rounds.
Top trending discussions
I appeared for an interview before Sep 2020.
Round duration - 60 minutes
Round difficulty - Medium
30 Aptitude problems and two coding questions
Given an integer array ARR
of size N
, your task is to find the total number of inversions that exist in the array.
An inversion is defined for a pair of integers in the...
Count the total number of inversions in an integer array.
Iterate through the array and for each pair of elements, check if the conditions for inversion are met.
Use a nested loop to compare each pair of elements efficiently.
Keep a count of the inversions found and return the total count at the end.
Given an array of integers, determine the maximum possible sum of any contiguous subarray within the array.
array = [34, -50, 42, 14, -5, 86]
Find the maximum sum of any contiguous subarray within an array of integers.
Iterate through the array and keep track of the maximum sum of subarrays encountered so far.
At each index, decide whether to include the current element in the subarray or start a new subarray.
Use Kadane's algorithm to solve the problem efficiently.
Example: For array [34, -50, 42, 14, -5, 86], the maximum subarray sum is 137.
Round duration - 90 minutes
Round difficulty - Medium
Data structure and algorithms plus object oriented problems
You are given a sequence of numbers, ARR
. Your task is to return a sorted sequence of ARR
in non-descending order using the Merge Sort algorithm.
The Merge Sort...
Implement Merge Sort algorithm to sort a sequence of numbers in non-descending order.
Divide the input array into two halves recursively until each array has only one element.
Merge the sorted halves to produce a completely sorted array.
Time complexity of Merge Sort is O(n log n).
Example: Input: [3, 1, 4, 1, 5], Output: [1, 1, 3, 4, 5]
Given a singly linked list of integers and a reference to a node, your task is to delete that specific node from the linked list. Each node in the linked li...
Given a singly linked list of integers and a reference to a node, delete the specified node from the linked list.
Traverse the linked list to find the node to be deleted
Update the pointers to skip over the node to be deleted
Print the modified linked list after deletion
Round duration - 60 miinutes
Round difficulty - Easy
Database questions and discussion about projects
Normal forms in database management systems help in organizing data to reduce redundancy and improve data integrity.
Normal forms are rules used to design relational database tables to minimize redundancy and dependency.
Boyce-Codd Normal Form (BCNF) is a stricter version of Third Normal Form (3NF) where every determinant is a candidate key.
BCNF helps in eliminating anomalies like insertion, update, and deletion anomalie...
WHILE is used in loops to repeatedly execute a block of code, while HAVING is used in SQL queries to filter results based on aggregate functions.
WHILE is used in programming languages like SQL to create loops for executing a block of code multiple times.
HAVING is used in SQL queries to filter results based on aggregate functions like SUM, COUNT, AVG, etc.
WHILE is used for iterative operations, while HAVING is used for ...
Tip 1 : Competitive Programming
Tip 2 : Do atleast 2 projects
Tip 1 : To be precise, mention your technical skills, achievements, dont write anything unnecessary plus write your professional summary good mention your project details in not more than 2 lines and make sure those sentences make sense to reader.
Tip 2 : Resume should be not more than one page. Write everything within one page
posted on 18 Sep 2020
I applied via Walk-in and was interviewed before Sep 2019. There were 3 interview rounds.
I am motivated by the opportunity to learn, contribute to a team, and make a positive impact through my work.
Desire for personal growth: I thrive in environments where I can learn new skills, like when I took on a challenging project that expanded my expertise.
Team collaboration: Working with diverse teams inspires me, as seen in my previous role where we achieved a common goal through effective teamwork.
Making a diffe...
I manage myself in a hectic environment by prioritizing tasks, staying organized, and practicing stress management techniques.
Prioritize tasks based on urgency and importance
Break down complex tasks into smaller, manageable steps
Use tools like to-do lists, calendars, and reminders to stay organized
Practice time management techniques, such as setting deadlines and allocating specific time slots for different tasks
Take s...
I applied via LinkedIn and was interviewed before Oct 2020. There were 3 interview rounds.
Stack using queues: push() - enqueue to queue1, pop() - dequeue from queue2 after transferring n-1 elements from queue1 to queue2
To push an element, enqueue it to queue1
To pop an element, transfer n-1 elements from queue1 to queue2, dequeue the last element from queue1 and swap the names of queue1 and queue2
Queue using stacks: enqueue() - push to stack1, dequeue() - pop from stack2 after transferring all elements from ...
Doubly linked list is a data structure where each node has a pointer to both previous and next nodes.
Create a Node class with data, prev and next pointers
Create a LinkedList class with head and tail pointers
Implement methods to add, remove and traverse nodes
Yes, I am a leader.
I have experience leading teams in previous projects.
I am able to communicate effectively and motivate team members.
I am proactive in identifying and solving problems.
I am able to delegate tasks and trust team members to complete them.
I am constantly seeking to improve my leadership skills through learning and feedback.
Formula to calculate number of squares that can fit inside a triangle
Calculate the area of the triangle and the area of the square
Divide the area of the triangle by the area of the square to get the number of squares that can fit inside the triangle
Formula: (h*b)/(a*a)
SVM is a machine learning algorithm used for classification and regression analysis.
SVM finds the best hyperplane that separates data into different classes.
It works by maximizing the margin between the hyperplane and the closest data points.
SVM can handle both linear and non-linear data using kernel functions.
It is widely used in image classification, text classification, and bioinformatics.
SVM has been shown to be ef...
Logistic regression is used for classification while linear regression is used for regression analysis.
Logistic regression predicts the probability of an event occurring, while linear regression predicts the value of a continuous variable.
Logistic regression uses a sigmoid function to map input values to a probability between 0 and 1.
Linear regression assumes a linear relationship between the independent and dependent ...
posted on 18 Feb 2016
Eligible customers for Vodafone's 4G service launch in India.
Customers with 4G compatible devices
Customers with high data usage
Customers in areas with good network coverage
Customers who have shown interest in technology and gadgets
Customers who have previously used Vodafone's high-speed data services
Customers who have opted-in to receive promotional messages
I am a detail-oriented Business Analyst with strong analytical skills. My strengths include problem-solving and communication, while my weakness is sometimes being too detail-oriented.
Strengths: strong analytical skills
Strengths: problem-solving abilities
Strengths: effective communication skills
Weakness: being too detail-oriented
Weakness: sometimes struggle with delegation
The number of soft drinks sold in J&K on a particular day depends on various factors such as population, demand, availability, and marketing strategies.
The population of J&K can be a factor in determining the potential number of soft drink sales.
The demand for soft drinks can vary based on factors such as weather, events, and cultural preferences.
The availability of soft drinks in J&K, including distribution channels a...
Estimating the market size of 4K and 8K display screens.
Analyze sales data and market research reports
Consider the adoption rate of 4K and 8K technology
Evaluate the market demand from various industries (entertainment, gaming, advertising, etc.)
Assess the pricing and availability of 4K and 8K displays
Factor in the growth potential and competition in the market
based on 2 interview experiences
Difficulty level
Duration
based on 151 reviews
Rating in categories
Dentist
16
salaries
| ₹3 L/yr - ₹6 L/yr |
Dental Surgeon
11
salaries
| ₹3.7 L/yr - ₹8.4 L/yr |
Administration Executive
9
salaries
| ₹1.5 L/yr - ₹3.4 L/yr |
Resident Doctor
8
salaries
| ₹3.2 L/yr - ₹7 L/yr |
General Dentist
8
salaries
| ₹3.2 L/yr - ₹6.1 L/yr |
Pathcare Labs
Biotech Vision Care
Narayana Medical College & Hospital
Cytecare Cancer Hospital