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 2 Feb 2024
I applied via Campus Placement and was interviewed in Jan 2024. There were 3 interview rounds.
Computer fundamentals
I applied via unstop and was interviewed before Oct 2023. There were 3 interview rounds.
It was medium to difficult level test
posted on 8 Feb 2022
I applied via Recruitment Consulltant and was interviewed in Aug 2021. There were 3 interview rounds.
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 19 Jul 2024
posted on 19 Apr 2024
I applied via Naukri.com and was interviewed before Apr 2023. There were 3 interview rounds.
C++ related aptitude test. OOPs questions.
Questions related to linked list. Virtual functions and virtual destructor.
Reversing a LinkedIn list.
We primarily use the MERN stack for our web development projects.
MERN stack includes MongoDB, Express.js, React, and Node.js
MongoDB is used as the database to store data
Express.js is used as the backend framework for building APIs
React is used for building the user interface
Node.js is used as the server-side runtime environment
Threads are handled by creating and managing lightweight processes within a program to improve performance and responsiveness.
Threads are managed by the operating system or a thread library.
Threads share the same memory space within a process.
Threads can communicate with each other through shared memory or message passing.
Thread synchronization is important to prevent race conditions and ensure data consistency.
Example...
I applied via Campus Placement 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...
They asked easy to medium DSA . It includes arrays, strings, recursion.
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...
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