i
Nirvasa Healthcare
Filter interviews by
Different storage engines are used in databases to manage data storage and retrieval efficiently.
InnoDB: ACID-compliant, supports transactions and foreign keys
MyISAM: Fast and efficient for read-heavy workloads, no transaction support
Memory: Stores data in memory for fast access, but data is lost on restart
CSV: Stores data in CSV files, suitable for importing and exporting data
Archive: Optimized for high compression, s
Group by is used to group rows based on a column, while distinct function is used to remove duplicate values from a column.
Group by is used with aggregate functions like count, sum, avg, etc.
Distinct function is used to retrieve unique values from a column.
Group by can be used with multiple columns to create groups based on multiple criteria.
Distinct function can be used with multiple columns to retrieve unique combina...
To find the second highest salary, we can use the SQL query 'SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees)'.
Use the MAX() function to find the highest salary in the table
Use a subquery to find the maximum salary excluding the highest salary
Use the WHERE clause to filter out the highest salary
Use the MAX() function again to find the second highest salary
Top trending discussions
posted on 9 Nov 2022
I applied via Approached by Company and was interviewed before Nov 2021. There were 4 interview rounds.
Basic problem solving easy to medium level
Sorting algorithm arranges elements in a specific order.
Choose an appropriate sorting algorithm based on the data size and type.
Common sorting algorithms include bubble sort, insertion sort, merge sort, quicksort, and selection sort.
Implement the chosen algorithm in the programming language of choice.
Test the algorithm with various input sizes and types to ensure correctness and efficiency.
posted on 2 Feb 2024
I applied via Campus Placement and was interviewed in Jan 2024. There were 3 interview rounds.
Computer fundamentals
End to end automation cycle involves automating the entire software development process from planning to deployment.
The cycle starts with requirements gathering and planning
Next, the code is developed and tested using automation tools
Continuous integration and delivery are used to deploy the code to production
Monitoring and feedback are used to improve the process
Examples of automation tools include Jenkins, Selenium,
posted on 31 Oct 2023
I applied via Campus Placement and was interviewed before Oct 2022. There were 4 interview rounds.
It was an MCQ based test. Code Snippets as well as OOPS, OS, DBMS questions were there
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.
posted on 14 Sep 2024
I applied via LinkedIn and was interviewed before Sep 2023. There was 1 interview round.
posted on 9 Dec 2024
I applied via Job Portal and was interviewed before Dec 2023. There were 2 interview rounds.
posted on 31 May 2021
I applied via Company Website and was interviewed in May 2021. There were 4 interview rounds.
Multithreading in Java allows multiple threads to execute concurrently within a single program.
Java provides built-in support for multithreading through the java.lang.Thread class.
Threads can be created by extending the Thread class or implementing the Runnable interface.
Synchronization is used to prevent race conditions and ensure thread safety.
Java also provides several classes and interfaces for managing thread exec...
posted on 5 Sep 2022
based on 1 interview
Interview experience
Team Lead
17
salaries
| ₹2.7 L/yr - ₹5.2 L/yr |
Sales Executive
15
salaries
| ₹1.7 L/yr - ₹2.6 L/yr |
Assistant Manager
6
salaries
| ₹4.1 L/yr - ₹13.1 L/yr |
BPO Executive
5
salaries
| ₹1.8 L/yr - ₹2.1 L/yr |
Customer Service Executive
5
salaries
| ₹2.2 L/yr - ₹2.6 L/yr |
Max Healthcare
Paras Hospital
Dr Lal PathLabs
Johnson & Johnson