Filter interviews by
A recursive CTE is a Common Table Expression that references itself.
It is used to perform recursive operations on hierarchical data.
It consists of two parts: the anchor member and the recursive member.
The anchor member is the base case and the recursive member is the recursive case.
It can be used to traverse a tree structure or to calculate running totals.
It can improve performance and simplify complex queries.
Output parameters are variables used to return values from a function or stored procedure.
Output parameters are declared with the OUTPUT keyword in SQL Server.
They can be used to return a single value or a table of values.
Output parameters are useful for passing data between stored procedures or functions.
They can also be used to return status codes or error messages.
Transactions ensure data consistency and integrity in a database.
Allows multiple operations to be treated as a single unit of work
Ensures that all operations are either committed or rolled back as a whole
Prevents data inconsistencies and corruption
Provides ACID properties to the database
Example: transferring funds between bank accounts
Example: updating inventory levels after a purchase
File groups are logical containers for database files that can be used to manage storage and backup operations.
File groups allow for the organization of database files into logical units.
They can be used to manage storage and backup operations.
A database can have multiple file groups, each with its own set of files.
File groups can be used to control the placement of data and indexes on different physical disks.
Fil...
MERGE is a SQL command used to combine INSERT, UPDATE, and DELETE operations into a single statement.
MERGE is used to synchronize two tables by inserting, updating, or deleting rows based on a specified condition.
It is useful for data warehousing and ETL processes.
MERGE can improve performance by reducing the number of round trips between the client and server.
Syntax: MERGE INTO target_table USING source_table ON ...
Temp tables are used to store intermediate results during query processing.
Temp tables are created in tempdb database.
They can be local or global.
Local temp tables are only visible to the current session.
Global temp tables are visible to all sessions.
They can be created using SELECT INTO or CREATE TABLE statements.
They can be used to store intermediate results during complex queries.
They are automatically dropped ...
Magic tables are temporary tables created by SQL Server during DML operations.
Magic tables are used to access the data before and after an INSERT, UPDATE, or DELETE operation.
They are created automatically by SQL Server and cannot be modified by the user.
The inserted and deleted tables are examples of magic tables.
They are useful for auditing and logging changes to a database.
I applied via Naukri.com and was interviewed in Apr 2021. There was 1 interview round.
A recursive CTE is a Common Table Expression that references itself.
It is used to perform recursive operations on hierarchical data.
It consists of two parts: the anchor member and the recursive member.
The anchor member is the base case and the recursive member is the recursive case.
It can be used to traverse a tree structure or to calculate running totals.
It can improve performance and simplify complex queries.
Output parameters are variables used to return values from a function or stored procedure.
Output parameters are declared with the OUTPUT keyword in SQL Server.
They can be used to return a single value or a table of values.
Output parameters are useful for passing data between stored procedures or functions.
They can also be used to return status codes or error messages.
Transactions ensure data consistency and integrity in a database.
Allows multiple operations to be treated as a single unit of work
Ensures that all operations are either committed or rolled back as a whole
Prevents data inconsistencies and corruption
Provides ACID properties to the database
Example: transferring funds between bank accounts
Example: updating inventory levels after a purchase
File groups are logical containers for database files that can be used to manage storage and backup operations.
File groups allow for the organization of database files into logical units.
They can be used to manage storage and backup operations.
A database can have multiple file groups, each with its own set of files.
File groups can be used to control the placement of data and indexes on different physical disks.
File gro...
MERGE is a SQL command used to combine INSERT, UPDATE, and DELETE operations into a single statement.
MERGE is used to synchronize two tables by inserting, updating, or deleting rows based on a specified condition.
It is useful for data warehousing and ETL processes.
MERGE can improve performance by reducing the number of round trips between the client and server.
Syntax: MERGE INTO target_table USING source_table ON condi...
Top trending discussions
I appeared for an interview before Mar 2021.
Round duration - 60 minutes
Round difficulty - Medium
Technical round with questions based on DSA were discussed.
Ninja is tasked with merging two given sorted integer arrays ARR1
and ARR2
of sizes 'M' and 'N', respectively, such that the merged result is a single sorted array w...
Given a perfect binary tree consisting of 'N' nodes, reverse the nodes at alternate levels in the tree (i.e., reverse level 2, level 4, ...
Reverse alternate levels of a perfect binary tree by reversing nodes at even levels starting from level 2.
Traverse the tree in level order and store nodes at even levels in a separate list.
Reverse the list of nodes at even levels.
Update the tree with the reversed nodes at even levels.
Repeat the process for alternate levels starting from level 2.
Round duration - 60 minutes
Round difficulty - Medium
Technical round with questions based on OS, Java were discussed.
Characteristics of distributed file systems include scalability, fault tolerance, and data replication.
Scalability: Distributed file systems can easily scale to accommodate a large amount of data and users.
Fault tolerance: They are designed to continue functioning even if some components fail, ensuring high availability.
Data replication: Data is often replicated across multiple nodes to ensure reliability and performan...
ConcurrentHashMap is a thread-safe implementation of the Map interface in Java.
ConcurrentHashMap allows multiple threads to read and write to the map concurrently without causing any issues like deadlocks or data corruption.
It achieves thread-safety by dividing the map into segments, each of which can be locked independently.
ConcurrentHashMap is more efficient than using synchronized maps for concurrent access.
Example:...
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I appeared for an interview before Mar 2021.
Round duration - 60 minutes
Round difficulty - Medium
Technical interview round with questions based on DSA.
Your task is to compute the In-Order, Pre-Order, and Post-Order traversals for a given Binary Tree with 'N' nodes, where each node has an integer value.
T
For each test cas...
Compute In-Order, Pre-Order, and Post-Order traversals for a given Binary Tree with 'N' nodes.
Implement tree traversal algorithms: In-Order, Pre-Order, and Post-Order.
Use recursion to traverse the binary tree efficiently.
Handle null nodes represented by -1 in the input.
Follow the order of nodes as they appear in the level order traversal.
Ensure the output is space-separated lists for each traversal type.
Design a data structure for a Least Recently Used (LRU) cache that supports the following operations:
1. get(key)
- Return the value of the key if it exists in the cache; otherw...
Round duration - 60 minutes
Round difficulty - Medium
Technical Interview round with questions on DSA, OS etc.
You have a 2D grid of dimensions 'N' rows by 'M' columns, initially filled with water. You are given 'Q' queries, where each query contains two integers 'X' and 'Y'....
The task is to determine the number of islands present on a 2D grid after each query of converting water to land.
Create a function that takes the grid dimensions, queries, and coordinates as input.
For each query, convert the water at the given coordinates to land and update the grid.
Use depth-first search (DFS) to find connected lands and count the number of islands.
Return the number of islands after each query.
Synchronized blocks are needed in Java to ensure thread safety by allowing only one thread to access a block of code at a time.
Prevents multiple threads from accessing critical sections of code simultaneously
Ensures data consistency and prevents race conditions
Improves performance by reducing contention for shared resources
Example: synchronized block in a method that updates a shared variable
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I appeared for an interview before Mar 2021.
Round duration - 90 minutes
Round difficulty - Easy
This test has 2 sections :
Section 1 ( Technical objective questions)
– 25 mcq’s mainly focusing on c , c++ , os , data structures , algorithms
Section 2 ( 2 Coding questions )
– Code was supposed to be written on paper.
Given a string S
which represents a number, determine the smallest number strictly greater than the original number composed of the same digits. Each digit's frequenc...
You are given a string of length N
. Your task is to reverse the string word by word. The input may contain multiple spaces between words and may have leading o...
Round duration - 60 minutes
Round difficulty - Easy
First round of interview was based on basic data structures. Concepts related to binary search tree , uses and comparing complexity were asked. He also asked about Hashing , Collisions.
Given an unsorted array containing 'N' integers, you are required to find 'K' largest elements from the array and return them in non-decreasing order.
The fir...
Round duration - 60 minutes
Round difficulty - Medium
The interview started with a programming question. Then he asked me a puzzle. There was a small discussion about my projects then .Then he started asking questions about operating system. The interviewer wanted to test my understanding about semaphores and asked some tricky and confusing questions .
Given a binary tree of integers, return the level order traversal of the binary tree.
The first line contains an integer 'T', representing the number of te...
Producer-Consumer problem involves multiple threads sharing a common buffer. Producers add items to the buffer while consumers remove them.
Producers and consumers need to synchronize their access to the shared buffer to avoid race conditions.
Semaphores can be used to control access to the buffer. Two semaphores are used - one to track the empty slots in the buffer and one to track the filled slots.
Producers increment t...
Round duration - 60 minutes
Round difficulty - Medium
Technical Interview round with questions based on DSA.
For a given array of integers arr
, identify the peak element. A peak element is an element that is greater than its neighboring elements. Specifically, if arr[i]
is the peak, then both...
Round duration - 60 minutes
Round difficulty - Easy
This round was a telephonic interview with the CTO of the company. The he started with a small discussion about my projects and research paper .He then moved on to data structures and asked me how to choose a relevant data structure for a given problem. I gave him advantages of every data structure and certain problems where specific data structures could be useful .Then he gave a question and asked me for what data structure should be used keeping time complexity in mind. He asked me a few HR questions in the end .
Given the initial letter of a student's name and three integer marks for that student, calculate and display the student's initial letter followed by the integer part of th...
Calculate and display the student's initial letter followed by the integer part of their average marks.
Calculate the average of the three marks provided for each student.
Display the initial letter of the student's name followed by the integer part of the average marks.
Round down the average to the nearest integer to get the integer part.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I appeared for an interview before Mar 2021.
Round duration - 60 minutes
Round difficulty - Medium
Technical Interview round with questions on DSA.
Given a stream of integers, calculate and print the median after each new integer is added to the stream.
Output only the integer part of the median.
N = 5
Stre...
Given a Binary Search Tree (BST) and a target value 'K', determine if there exist two unique elements in the BST such that their sum equals the target 'K'.
A ...
Calculate various statistical measures given a large sample of integers in the range [0, 255]. For efficiency, you are provided with an array 'count' where the i-th ele...
Calculate various statistical measures given a large sample of integers in the range [0, 255] using the provided frequency array.
Iterate through the 'count' array to calculate minimum and maximum values.
Calculate the mean by summing up all values and dividing by the total count.
Find the median by sorting the sample and determining the middle element(s).
Identify the mode by finding the element with the highest frequency...
Round duration - 60 minutes
Round difficulty - Medium
Technical Interview round with questions on DSA. A puzzle was also asked.
Design a data structure for a Least Recently Used (LRU) cache that supports the following operations:
1. get(key)
- Return the value of the key if it exists in the cache; otherw...
You are provided with a rotated sorted array of size N
. Your task is to sort the given array in increasing order.
N = 4
Array = [2, 3,...
Implement a function to sort a rotated sorted array in increasing order without using the sort() function.
Find the pivot element in the rotated sorted array.
Split the array into two subarrays based on the pivot element.
Sort each subarray separately.
Merge the sorted subarrays to get the final sorted array.
Round duration - 30 minutes
Round difficulty - Easy
HR round with typical behavioral problems.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
Generator functions are functions that can be paused and resumed, allowing for lazy evaluation of data.
Generator functions use the yield keyword to pause execution and return a value.
They can be used to generate an infinite sequence of values.
They are memory efficient as they only generate values when needed.
Example: function* myGenerator() { yield 1; yield 2; yield 3; }
Example: const infiniteGenerator = function*() { ...
Push notifications can be implemented in Android and iOS using Firebase Cloud Messaging (FCM) and Apple Push Notification service (APNs) respectively.
For Android, integrate FCM SDK in the app and use FCM console to send notifications.
For iOS, create an APNs certificate, configure the app to receive notifications, and use APNs to send notifications.
Both platforms require handling of notification payload in the app to di...
I used React Native for my last app.
Developed UI components using React Native
Integrated APIs to fetch and display data
Implemented Redux for state management
Used Firebase for authentication and database
Optimized app performance using React Native Debugger
Functional components are stateless and return UI elements based on input props, while non-functional components have state and can change UI based on user interaction.
Functional components are simpler and easier to test than non-functional components.
Non-functional components can have state and lifecycle methods, while functional components cannot.
Examples of functional components include buttons, labels, and icons, w...
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
Flip-flops and latches are sequential logic circuits used to store and manipulate binary data.
Flip-flops are edge-triggered devices, while latches are level-sensitive devices.
Flip-flops have separate clock and data inputs, while latches have a single input for both clock and data.
Flip-flops are used in synchronous circuits, while latches are used in asynchronous circuits.
Flip-flops are more complex and require more cir...
posted on 5 Apr 2021
based on 1 interview experience
based on 46 reviews
Rating in categories
Software Developer
21
salaries
| ₹3 L/yr - ₹9.4 L/yr |
Engineering Manager
8
salaries
| ₹29 L/yr - ₹33 L/yr |
Software Engineer
7
salaries
| ₹5 L/yr - ₹10.5 L/yr |
Database Developer
6
salaries
| ₹2.1 L/yr - ₹5 L/yr |
Senior Software Developer
6
salaries
| ₹5.8 L/yr - ₹12.2 L/yr |
Maxgen Technologies
F1 Info Solutions and Services
ANR Software Private Limited
MCM Telecom Equipment