Filter interviews by
A stored procedure is a precompiled collection of SQL statements that can be executed by calling the procedure name.
Stored procedures can improve performance by reducing network traffic and increasing security.
They can be used to encapsulate business logic and promote code reusability.
Stored procedures are stored in the database and can be called from various applications or scripts.
Example: CREATE PROCEDURE GetEm...
Functions return a single value while stored procedures can return multiple values. Functions can be called from SQL statements while stored procedures cannot.
Functions return a single value while stored procedures can return multiple values
Functions can be called from SQL statements while stored procedures cannot
Functions cannot modify the database state while stored procedures can
Functions are used for computati...
OOPs concepts refer to Object-Oriented Programming principles like Inheritance, Encapsulation, Polymorphism, and Abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Polymorphism: Ability to present the same interface for different data types.
Abstraction: Hiding the complex implementation d...
Web.config file is a configuration file used in ASP.NET applications to store settings and configurations.
Contains settings for the ASP.NET application
Can include connection strings, authentication settings, and custom error pages
Located in the root directory of the ASP.NET application
Can be used to specify custom error pages, session state settings, and more
ASP.NET page life cycle is the series of events that occur from the time a page is requested to the time the page is fully rendered and sent to the client browser.
Page request is received by the server
Page is initialized, controls are created and their properties are set
Page is loaded with data and controls are rendered
Page is unloaded and disposed
Yes, I have used WebApi in multiple projects to create RESTful APIs for web applications.
Used WebApi to build RESTful APIs for communication between client and server
Implemented CRUD operations using WebApi endpoints
Secured WebApi endpoints with authentication and authorization mechanisms
Utilized WebApi to integrate third-party services and data sources
Interface is a blueprint for a class, while abstract class can have some implementation.
Interface cannot have any implementation, only method signatures.
A class can implement multiple interfaces but can inherit only one abstract class.
Abstract class can have abstract and non-abstract methods, while interface can only have abstract methods.
Interfaces are used to achieve multiple inheritance in C#, while abstract cl...
An interface in programming defines a contract for classes to implement, specifying methods and properties that must be included.
Interfaces in C# are similar to abstract classes but can only contain method signatures, properties, events, and indexers.
Classes can implement multiple interfaces, allowing for flexibility in defining behavior.
Interfaces are used to achieve polymorphism and decouple code, making it easi...
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include 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 tab...
ASP.NET is a web application framework developed by Microsoft for building dynamic web sites, web applications, and web services.
Developed by Microsoft
Used for building dynamic web sites, web applications, and web services
Supports multiple programming languages like C# and VB.NET
Uses server-side scripting to generate dynamic web pages
I applied via Naukri.com and was interviewed before Nov 2022. There were 3 interview rounds.
ASP.NET is a web application framework developed by Microsoft for building dynamic web sites, web applications, and web services.
Developed by Microsoft
Used for building dynamic web sites, web applications, and web services
Supports multiple programming languages like C# and VB.NET
Uses server-side scripting to generate dynamic web pages
ASP.NET page life cycle is the series of events that occur from the time a page is requested to the time the page is fully rendered and sent to the client browser.
Page request is received by the server
Page is initialized, controls are created and their properties are set
Page is loaded with data and controls are rendered
Page is unloaded and disposed
Web.config file is a configuration file used in ASP.NET applications to store settings and configurations.
Contains settings for the ASP.NET application
Can include connection strings, authentication settings, and custom error pages
Located in the root directory of the ASP.NET application
Can be used to specify custom error pages, session state settings, and more
Access modifiers are keywords in programming languages that define the accessibility of classes, methods, and other members.
Access modifiers control the visibility and accessibility of classes, methods, and variables in a program.
Common access modifiers include public, private, protected, and default (package-private).
Public access modifier allows a class, method, or variable to be accessed from any other class.
Private...
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include 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.
RI...
OOPs concepts refer to Object-Oriented Programming principles like Inheritance, Encapsulation, Polymorphism, and Abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Polymorphism: Ability to present the same interface for different data types.
Abstraction: Hiding the complex implementation detail...
An interface in programming defines a contract for classes to implement, specifying methods and properties that must be included.
Interfaces in C# are similar to abstract classes but can only contain method signatures, properties, events, and indexers.
Classes can implement multiple interfaces, allowing for flexibility in defining behavior.
Interfaces are used to achieve polymorphism and decouple code, making it easier to...
Functions return a single value while stored procedures can return multiple values. Functions can be called from SQL statements while stored procedures cannot.
Functions return a single value while stored procedures can return multiple values
Functions can be called from SQL statements while stored procedures cannot
Functions cannot modify the database state while stored procedures can
Functions are used for computations a...
Interface is a blueprint for a class, while abstract class can have some implementation.
Interface cannot have any implementation, only method signatures.
A class can implement multiple interfaces but can inherit only one abstract class.
Abstract class can have abstract and non-abstract methods, while interface can only have abstract methods.
Interfaces are used to achieve multiple inheritance in C#, while abstract classes...
A stored procedure is a precompiled collection of SQL statements that can be executed by calling the procedure name.
Stored procedures can improve performance by reducing network traffic and increasing security.
They can be used to encapsulate business logic and promote code reusability.
Stored procedures are stored in the database and can be called from various applications or scripts.
Example: CREATE PROCEDURE GetEmploye...
Yes, I have used WebApi in multiple projects to create RESTful APIs for web applications.
Used WebApi to build RESTful APIs for communication between client and server
Implemented CRUD operations using WebApi endpoints
Secured WebApi endpoints with authentication and authorization mechanisms
Utilized WebApi to integrate third-party services and data sources
Top trending discussions
I applied via Naukri.com and was interviewed before Aug 2020. There were 4 interview rounds.
Reversing a string involves rearranging its characters in the opposite order, which can be done using various methods.
Use built-in functions: In Python, you can reverse a string with slicing: `reversed_string = original_string[::-1]`.
Iterative approach: Loop through the string from the end to the beginning and build a new string.
Using recursion: Define a function that calls itself with a smaller substring until it reac...
I appeared for an interview in Nov 2020.
Round duration - 120 minutes
Round difficulty - Medium
This was an online coding, mcq and debugging round round held on Amcat platform, there were 3 sections in the test.
1)20 MCQ questions {10 involving mathematics and the other 10 on programming fundamentals}; duration:20 mins;
you cannot navigate back to a questions after moving further, so have to answer carefully
2)debugging section- it involved 7 questions which were to be completed within 20 mins, 5 of them were very easy, each question only took almost a minute to figure out the problem with the code, last 2 questions were relatively moderate and there were errors at 3-4 sections of the entire code. I was able to solve all the questions in 15 mins
3)2 Coding questions- duration:80 mins, one was moderate on string while the other one involved dynamic programming, I was able to successfully execute all the available test cases.
Given two strings, S
and X
, your task is to find the smallest substring in S
that contains all the characters present in X
.
S = "abdd", X = "bd"
Find the smallest substring in S that contains all characters in X.
Use a sliding window approach to find the smallest window in S containing all characters of X.
Maintain a hashmap to keep track of characters in X and their frequencies.
Slide the window by moving the right pointer until all characters in X are found, then move the left pointer to minimize the window size.
Return the smallest window found.
Example: S = 'abd...
You are given a 2D matrix 'ARR' of size 'N x 3' with integers, where 'N' is the number of rows. Your task is to compute the smallest sum achievable by selecting one...
Find the smallest sum achievable by selecting one element from each row of a 2D matrix, following certain constraints.
Iterate through each row and find the minimum element that does not violate the constraints.
Keep track of the minimum sum achieved by selecting elements from each row.
Avoid selecting elements directly beneath previously selected elements.
Round duration - 45 minutes
Round difficulty - Hard
The interview started with introduction, there were two interviewers, they both introduced themselves and then asked me to introduce myself. Then we had a brief description on my projects, and they really appreciated my projects. Then as they were more concerned with DSA part, so we moved towards solving a coding problem. It was a famous rotten oranges problem with some change in language but as I haven't seen it beforehand, I wasn't able to give them an optimal approach and had to ask for some hints, but with a certain amount of help and hints, I was able to solve the problem and successfully coded it in 5 mins. Then the interviewers went for a dry run of the algorithm and tried to run it on each and every corner case, but as my algorithm was kind of bullet proof, it successfully passed all the corner cases.
Then they went for some questions on OOPS concepts involving inheritance and we had a long discussion on virtual function and runtime polymorphism. Then the interview was ended after a Q/A round that lasted for 3-4 minutes.
Given a grid containing oranges in three possible states:
Every second, any fresh orange adjac...
Given a grid with fresh and rotten oranges, determine the minimum time for all oranges to become rotten.
Create a queue to store the coordinates of rotten oranges and perform BFS to rot adjacent fresh oranges
Track the time taken to rot all oranges and return -1 if some fresh oranges remain
Handle edge cases like empty grid or no fresh oranges present
Example: For input grid = [[2,1,1],[1,1,0],[0,1,1]], the minimum time to...
Tip 1 : Try to keep yourself involved in competitive programming on regular basis {ex-Codechef, codeforces etc}
Tip 2 : brush up concepts on DSA and practice at least all questions from interviewbit and around 300 questions from GFG and Leetcode of upto intermediate level, this will help you in building your concepts and you will be quickly able to answer the questions in face to face interviews
Tip 3 : Complete some courses on data structures and algorithms and some programming languages{coding ninjas courses are preferable for valuable content}
Tip 1 : Try to keep only those things in resume on which you have very good command and you should be able to answer all of the questions(upto moderate level) related to your technical skills
Tip 2 : Mention your projects with brief description, try avoiding very high level description because some times reader might not be able to understand your work, keep it descriptive and understandable
I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 4 interview rounds.
MCQ's and Coding Problem - 1 related with Java, RDBMS, JS
I appeared for an interview in Oct 2020.
Round duration - 120 minutes
Round difficulty - Medium
Evening test around 5
Platform :- SHL
Environment was amazing
Given two binary trees, T and S, determine whether S is a subtree of T. The tree S should have the same structure and node values as a subtree of T.
Given two binary trees T and S, determine if S is a subtree of T with the same structure and node values.
Check if the second tree is a subtree of the first tree by comparing their structures and node values.
Use a recursive approach to traverse both trees and check for equality.
Handle cases where one tree is null or the values do not match.
Return true if S is a subtree of T, false otherwise.
You are given an N * N matrix of integers where each row and each column is sorted in increasing order. Your task is to find the positi...
Given a sorted N*N matrix, find the position of a target integer X.
Iterate over each row and column to find the target integer X
Utilize the sorted nature of the matrix to optimize the search process
Return the position of X if found, else return -1 -1
Round duration - 60 minutes
Round difficulty - Medium
1 Hour
Afternoon
You are provided with two singly linked lists containing integers, where both lists converge at some node belonging to a third linked list.
Your task is to determine t...
Find the node where two linked lists merge, return -1 if no merging occurs.
Traverse both lists to find their lengths and the difference in lengths
Move the pointer of the longer list by the difference in lengths
Traverse both lists simultaneously until they meet at the merging point
Given a Binary Search Tree (BST) and an integer 'S', your task is to find all pairs of nodes within the BST that total to 'S' and return these pairs. If no such p...
Find pairs of nodes in a BST that sum up to a given value 'S'.
Traverse the BST in-order to get a sorted list of nodes.
Use two pointers approach to find pairs with sum 'S'.
Keep track of visited nodes to avoid using the same node twice in a pair.
Round duration - 60 minutes
Round difficulty - Medium
Online Round held on Chime
You are given a binary tree of integers. Your task is to determine if it is a binary heap tree or not.
The first line of input contains an integer ‘T’ denoti...
Determine if a given binary tree is a binary heap tree or not based on certain properties.
Check if the binary tree is a complete binary tree where every level, except the last level, is completely filled and the last level is as far left as possible.
Ensure that every parent node is greater than all its children nodes, forming a max-heap.
If any node does not have a left or right child, it should be represented as -1 in ...
Given two strings S
and T
with lengths N
and M
respectively, your task is to find the "Edit Distance" between these strings.
The Edit Distance is defined as the minimum nu...
The task is to find the minimum number of operations required to convert one string into another using delete, replace, and insert operations.
Use dynamic programming to solve the problem efficiently.
Create a 2D array to store the edit distances between substrings of the two input strings.
Fill up the array based on the minimum of three possible operations: insert, delete, or replace.
The final answer will be the value at...
Tip 1 : 1 Programming Language
Tip 2 : Practice Data Structures with atleast 300 ques.
Tip 3 : CS Fundamental
Tip 1 : 1 Pager
Tip 2 : Add top 3 projects in Resume.
I applied via Recruitment Consultant and was interviewed in Aug 2021. There was 1 interview round.
Questions related to Java programming language concepts and features.
StringBuilder and StringBuffer are used for efficient string manipulation.
Arrays are fixed in size while linked lists can grow dynamically.
TreeSet is a sorted set implementation in Java.
Java 8 introduced lambda expressions, streams, and functional interfaces.
Static keyword is used to create class-level variables and methods.
Dynamic method dispatch is ...
based on 1 interview experience
Difficulty level
Duration
Manager
4
salaries
| ₹4.5 L/yr - ₹12 L/yr |
Senior Software Engineer
4
salaries
| ₹9.4 L/yr - ₹15.5 L/yr |
Data Entry Operator
4
salaries
| ₹1.8 L/yr - ₹1.9 L/yr |
QA Test Engineer
4
salaries
| ₹2.9 L/yr - ₹5.6 L/yr |
Senior Software Test Engineer
4
salaries
| ₹9 L/yr - ₹10.1 L/yr |
TCS
Accenture
Wipro
Cognizant