Filter interviews by
I applied via campus placement at Malviya National Institute of Technology (NIT), Jaipur and was interviewed before Mar 2023. There were 2 interview rounds.
Asked about simple sorting question and one based on two pointers.
DDL commands are used to define the structure of the database, while DML commands are used to manipulate the data within the database.
DDL (Data Definition Language) commands are used to create, modify, and delete database objects such as tables, indexes, and views.
Examples of DDL commands include CREATE, ALTER, and DROP.
DML (Data Manipulation Language) commands are used to retrieve, insert, update, and delete data in t...
Delete removes specific rows from a table, drop removes the entire table, and truncate removes all rows from a table.
Delete is a DML command used to remove specific rows from a table based on a condition.
Drop is a DDL command used to remove an entire table along with its structure and data.
Truncate is a DDL command used to remove all rows from a table but keeps the table structure intact.
Example: DELETE FROM table_name...
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
Quantitative , figure ,mcq question based on tech stack and 2 coding question which are basic. 90 minute time limit.
Quantitive Aptitude, General programming,oops
GK, Quantitative Aptitude
C# Fundamentals , ADO.NET,LINQ
Frequent changes in technology are driven by advancements, market demands, and user feedback.
Advancements in technology lead to new tools and frameworks being developed.
Market demands require companies to adapt quickly to stay competitive.
User feedback helps improve products and services, leading to updates and changes.
Examples: Introduction of new programming languages like Swift, shift towards cloud computing, update...
Roll is a term used in web development to describe the process of deploying code changes to a live server.
Rolling back changes means reverting to a previous version of the code.
Rolling forward means applying new changes to the live server.
Rolling deployments involve gradually updating servers in a controlled manner to minimize downtime.
Automated rollbacks can be triggered in case of errors or issues during deployment.
posted on 15 Jul 2024
The project architecture follows a microservices design pattern with separate front-end and back-end components.
Utilizes microservices architecture for scalability and flexibility
Separate front-end and back-end components for modularity
May include technologies like Docker for containerization and Kubernetes for orchestration
Async and await are keywords in JavaScript used for handling asynchronous operations.
Async is used to define a function as asynchronous, allowing it to use the await keyword.
Await is used to pause the execution of an async function until a Promise is settled.
Async functions always return a Promise, which resolves with the value returned by the function.
Using async/await makes asynchronous code easier to read and write
posted on 4 Sep 2024
I am a passionate Full Stack Developer with experience in building web applications using various technologies.
Experienced in front-end technologies like HTML, CSS, JavaScript, and frameworks like React and Angular
Proficient in back-end technologies like Node.js, Express, and databases like MongoDB and SQL
Familiar with version control systems like Git and deployment tools like Heroku
posted on 29 Nov 2021
I was interviewed in Sep 2021.
Round duration - 90 Minutes
Round difficulty - Medium
It was at 9 am in the morning
We will use the naive method to add two linked lists. While adding two numbers, we always add digits in the right to left manner. So first, we will reverse both linked lists so that we can easily process the number in this manner.
We will be storing the result of the addition in a different linked list. We will start adding the nodes of both linked lists and use another variable ‘carry’ to keep track o...
There is a cycle in the graph only if there is a back edge (back edge is an edge that connects a vertex to another vertex that is discovered before it's parent) present in the graph. To detect a back edge, we will keep track of vertices that have been already visited. If we reach a vertex that is already visited and is not the parent vertex of the current vertex, then there is a cycle in the graph.&n...
Round duration - 50 Minutes
Round difficulty - Hard
What is OOPS . Tell the different OOps features. Implement method overloading in c++
What is Synchronisation. How can we implement synchronisation in C++
What is Normalisation? Also implem...
We will iterate through all possible boundaries of the subarrays in the given array with the help of two nested loops.
Then, we will iterate through each subarray with the help of another loop and find the sum of the subarray. We will maintain the maximum subarray sum through our iterations and finally return it.
Space Complexity: O(1)Explanation:O(1), constant space is used.
Time Complexity: O(n^3...Round duration - 30 Minutes
Round difficulty - Hard
Happened on teams
Explain yourself. How will you manage a team of 10 employees
Tip 1 : Practice Leetcode
Tip 2 : Solve COdeforces A,B,C
Tip 1 : Make a clear resume with normal style
Tip 2 : Use overleaf for templates
I was interviewed in Aug 2021.
Round duration - 70 minutes
Round difficulty - Medium
There were 3 problems 1 was easy and 2 were of medium types.
The first line contains an integer '...
oddSum: denotes sum of nodes at odd levels, initially 0.
evenSum: denotes sum of nodes at ecen levels, initially 0.
level: the level of the current node, initially 1.
void oddEvenLevelHelper(current, oddSum, evenSum, level)
The idea is very simple and naive. We will process the rotten oranges second by second. Each second, we rot all the fresh oranges that are adjacent to the already rotten oranges. The time by which there are no rotten oranges left to process will be our minimum time.
In the first traversal of the grid, we will process all the cells with value 2 (rotten oranges). We will also mark their adjacent cells ...
Round duration - 50 minutes
Round difficulty - Medium
the interviewer was very polite and straightforward, he didn't ask me to introduce myself and he directly jumps to the coding problems.
What is new about the relationship between the and tags in HTML5?
Explain Components, Modules and Services in Angular
Initialize a variable ‘direction’ with 0 which means that the robot is initially facing towards the north.
direction: 0 -> Robot is facing towards the North
direction: 1 -> Robot is facing towards the West
direction: 2 -> Robot is facing towards the South
direction: 3 -> Robot is facing towards the West
Initialize two variables ‘x’ and ‘y’ as 0. They will represent the position ...
Round duration - 70 minutes
Round difficulty - Easy
What is a View in sql? What are the TRUNCATE, DELETE and DROP statements?
The idea is to find the transpose of the given matrix and then reverse the columns of the transposed matrix. For example:
For the given 2D matrix:
[ [ 1, 2, 3 ],
[ 4, 5, 6 ],
[ 7, 8, 9 ] ]
After taking transpose, it will become:
[ [ 1, 4, 7 ],
[ 2, 5, 8 ],
[ 3, 6, 9 ] ]
After reversing the columns, it will ...
Round duration - 20 minutes
Round difficulty - Easy
Tell me about yourself?
What do you know about Paytm?
What are your strength and weaknesses?
Job location preference?
Tip 1 : Deep knowledge of the projects mentioned in your resume is a must.
Tip 2 : Practice as many problems as you can from leetcode.
Tip 1 : mention 1 or 2 projects in your resume.
Tip 2 : don't put false things in your resume.
I was interviewed in Sep 2021.
Round duration - 60 minutes
Round difficulty - Medium
11:05am – 12:05pm (IST). What are classes in javascript? how do you integrate js in html.
Suppose given input is ...
In the brute force approach, we will use two nested loops. The outer loop is used to select the starting index of the substring and the inner loop is used to fix the ending index of the substring. After selecting the substring, we will use another loop (or a method) to check whether the substring contains all unique characters or not using a HashSet.
Space Complexity: O(n)Explanation:O(L), where L is the len...
The problem boils down to find the number of connected components in the grid.
If we are on a land cell and explore every cell connected to it 8-directionally (and recursively cells connected to those cells, and so on), then the total number of cells with land explored will be one island.
To ensure we don't count cells in the island more than once, we will mark 1(land) as 0 during the recursion call...
Round duration - 60 minutes
Round difficulty - Medium
12:30pm – 1:30pm (IST). SQL questions What are Aggregate and Scalar functions? What is a Stored Procedure?
For every element in the array, we will run a loop on its right side. As soon as we find an element on its right side which is greater than it, we will break the loop, assign it as the NGE of this element, move forward, and do the same for the next element.
Space Complexity: O(1)Explanation:O(1)
No extra space is used.
Time Complexity: O(n^2)Explanation:O(N ^ 2), Where N is the number of elements ...
Since we need to find the container with most water, let us try to find all possible containers and choose the one which has the maximum area.
So how can we find the area of all possible containers?
We can, for each line with the position ‘i’ find another line ‘j’ such that ‘j’ > ‘i’ and find the amount of water contained i.e (‘j’-’i’)*min('A[i]', ‘A[j]’) where ‘A[i]’ and ‘A[j]’ represents the heig...
Round duration - 60 minutes
Round difficulty - Easy
5pm – 6pm (IST)
Discussion regarding Project
Behavioral questions
Tip 1 : Practice a lot of questions from Leetcode and Interviewbit
Tip 2 : Go through all theory questions regarding OOPs, DBMS, Networking from GeeksForGeeks
Tip 3 : Go through all the basics SQL queries or must know about any 1 database perfectly.
Tip 1 : Try to keep it on one page . And never put false things on resume and write only those topics that you have thorough knowledge
Tip 2 : Thorough with the project mentioned and aware of all tech stack used
posted on 20 Sep 2023
I applied via Shine and was interviewed before Sep 2022. There were 3 interview rounds.
It is very easy. Practice daily on Indiabix
I was given 2-3mins yo speak on the topic. It was is Indian Education system needs modification. Be confident while speaking.
I applied via Approached by Company and was interviewed in Oct 2021. There were 2 interview rounds.
A piece of paper was given to me and I need to tell the some basics of computer languages
How can I lead my team
Assistant Vice President
51
salaries
| ₹20 L/yr - ₹42 L/yr |
Senior Analyst
47
salaries
| ₹3.4 L/yr - ₹14 L/yr |
Process Advisor
42
salaries
| ₹1.1 L/yr - ₹8 L/yr |
Analyst
36
salaries
| ₹8.5 L/yr - ₹14 L/yr |
Assistant Manager
18
salaries
| ₹7.5 L/yr - ₹17 L/yr |
HSBC Group
Standard Chartered Plc
Citigroup
JPMorgan Chase & Co.