Filter interviews by
There are four types of joins in SQL: 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 table.
FULL JOIN: Returns rows when there is a match in one of the tables.
Top trending discussions
I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.
Normal questions (technical and logical question)
posted on 19 Jul 2024
posted on 22 Oct 2024
I applied via Company Website and was interviewed in Sep 2024. There were 3 interview rounds.
Question related to profile.
Aptitude test questions
I applied via unstop and was interviewed before Oct 2023. There were 3 interview rounds.
It was medium to difficult level test
I applied via campus placement at Anna University and was interviewed in Aug 2022. There were 3 interview rounds.
Two Easy questions to be solved
Heap sort is a comparison-based sorting algorithm that uses a binary heap data structure.
Heap sort works by building a binary heap from the array and then repeatedly extracting the maximum element and placing it at the end of the array.
The heap is maintained as a complete binary tree, where each parent node is greater than or equal to its children.
The time complexity of heap sort is O(n log n) and it is an in-place sor...
posted on 11 Sep 2024
I applied via Recruitment Consulltant and was interviewed before Sep 2023. There were 5 interview rounds.
IT was basic question from string and array
Use depth-first search to traverse the tree and identify leaf nodes.
Implement depth-first search algorithm to traverse the tree.
Identify nodes with no children as leaf nodes.
Store leaf nodes in an array for retrieval.
Reverse each word in a sentence without using default function.
Split the sentence into words
Iterate through each word and reverse it
Join the reversed words back into a sentence
Fibonacci series using recursion is a classic programming problem where each number is the sum of the two preceding ones.
Define a recursive function that takes an integer n as input
Base case: if n is 0 or 1, return n
Recursive case: return the sum of the previous two Fibonacci numbers
Call the function recursively with n-1 and n-2 until base case is reached
Find 1st, 2nd, and 3rd highest integers from an array.
Sort the array in descending order.
Retrieve the first three elements from the sorted array.
Handle cases where array length is less than 3.
Full selectors select all descendants of a specified element, while partial selectors select only direct children.
Full selectors use a space between the parent and child elements, while partial selectors use the > symbol.
Full selectors are more general and can target multiple levels of descendants, while partial selectors are more specific and target only direct children.
Example of full selector: div p selects all
ele...
Screen scraping is extracting data from a website's HTML code, while data scraping is extracting data from various sources.
Screen scraping involves extracting data from the visual representation of a website, usually using automation tools like web scrapers.
Data scraping involves extracting data from various sources such as databases, APIs, and documents.
Both screen scraping and data scraping are used to collect and an...
Pagination is the process of dividing content into separate pages to improve user experience and optimize performance.
Pagination is commonly used in websites to display a large amount of data in manageable chunks.
It allows users to navigate through different pages of content, typically with options like 'Next' and 'Previous'.
Pagination can also include features like page numbers, page size selection, and total item cou...
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Software Developer
7
salaries
| ₹1.8 L/yr - ₹9.5 L/yr |
Project Manager
7
salaries
| ₹5.3 L/yr - ₹7 L/yr |
Administration Executive
5
salaries
| ₹2.4 L/yr - ₹3.1 L/yr |
Senior Graphic Designer
5
salaries
| ₹3.8 L/yr - ₹4.5 L/yr |
Senior Web Designer
4
salaries
| ₹3.2 L/yr - ₹5.9 L/yr |
Apollo Hospitals
UnitedHealth
GeBBS Healthcare Solutions
Sahrudaya Healthcare (Medicover Hospitals)