Filter interviews by
Clear (1)
1 hr - Basic Programs on Strings, Arrays
Tables can be created in databases using SQL commands like CREATE TABLE.
Use CREATE TABLE statement in SQL to create a new table
Specify the table name and column names along with their data types
Add constraints like primary key, foreign key, etc. if needed
ER Diagram is created by identifying entities, attributes, and relationships in a database.
Identify entities in the database (e.g. Customer, Product, Order)
Identify attributes for each entity (e.g. Customer has attributes like Name, Address)
Identify relationships between entities (e.g. Customer places Order)
CRUD operations in Node.js involve creating, reading, updating, and deleting data from a database.
Use libraries like Express and Mongoose to handle CRUD operations in Node.js
Create: Use HTTP POST method to add new data to the database
Read: Use HTTP GET method to retrieve data from the database
Update: Use HTTP PUT or PATCH method to modify existing data in the database
Delete: Use HTTP DELETE method to remove data from t
MVC architecture is a design pattern used in software development to separate the application into three main components: Model, View, and Controller.
Model represents the data and business logic of the application.
View is responsible for displaying the data to the user.
Controller acts as an intermediary between Model and View, handling user input and updating the Model accordingly.
Example: In a web application, the Mod...
I applied via Campus Placement and was interviewed before Mar 2023. There was 1 interview round.
I applied via Approached by Company and was interviewed before Feb 2023. There were 3 interview rounds.
Basic questions like portions, percentage and quants
Really basic question like star pyramid
Top trending discussions
I applied via Campus Placement and was interviewed before Jul 2020. There were 3 interview rounds.
I applied via Recruitment Consultant and was interviewed in Feb 2021. There were 3 interview rounds.
I applied via Company Website and was interviewed before Jan 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed before Oct 2020. There were 3 interview rounds.
I applied via Job Portal and was interviewed before May 2020. There were 4 interview rounds.
I applied via Recruitment Consultant and was interviewed in May 2020. There were 4 interview rounds.
MVC is a software architecture pattern that separates an application into three interconnected components: Model, View, and Controller.
Model represents the data and business logic of the application
View is responsible for rendering the user interface
Controller handles user input and updates the model and view accordingly
MVC promotes separation of concerns and modularity
Examples of MVC frameworks include Ruby on Rails,
Web API is for building HTTP services while WCF is for building services that support multiple transport protocols.
Web API is lightweight and ideal for building RESTful services over HTTP.
WCF is a more heavy-duty framework that supports multiple transport protocols like HTTP, TCP, Named Pipes, etc.
Web API is more suited for building services that are consumed by web applications while WCF is more suited for building se...
Session management in ASP.NET
ASP.NET provides in-built session management through HttpSessionState class
Session can be used to store user-specific data across multiple requests
Session can be configured to use different storage options like InProc, StateServer, SQLServer
Session can be accessed using HttpContext.Current.Session property
Session can be secured using SSL, cookieless sessions, and timeout settings
Filters in MVC are used to intercept and modify HTTP requests and responses.
Filters are used to implement cross-cutting concerns like logging, caching, authentication, etc.
There are five types of filters in MVC: Authorization filters, Action filters, Result filters, Exception filters, and Resource filters.
Authorization filters are used to authenticate and authorize users before executing an action.
Action filters are us...
Authentication is verifying the identity of a user, while authorization is granting access to specific resources.
Authentication confirms the identity of a user through credentials such as username and password.
Authorization determines what resources a user can access based on their role or permissions.
Examples of authentication include logging into a website or entering a PIN at an ATM.
Examples of authorization include...
Bootstrap is a popular front-end framework that provides a range of benefits for web development.
Bootstrap offers a responsive grid system that makes it easy to create mobile-friendly websites.
It includes pre-built CSS styles and JavaScript plugins that can save time and effort in development.
Bootstrap is well-documented and has a large community, making it easy to find support and resources.
It is constantly updated to...
Ajax can cause security issues and affect SEO.
Ajax can make a website less accessible to users with slow internet connections.
It can also cause issues with browser history and back button functionality.
Ajax can make it difficult for search engines to crawl and index website content.
Cross-site scripting (XSS) attacks can be carried out through Ajax if proper security measures are not taken.
Functions return a single value while stored procedures execute multiple SQL statements.
Functions can be used in SELECT, WHERE, and HAVING clauses.
Stored procedures can have input and output parameters.
Functions cannot modify the database while stored procedures can.
Functions are deterministic while stored procedures are not necessarily so.
Examples of functions: AVG, COUNT, MAX, MIN, SUM.
Examples of stored procedures:
Aggregate functions perform calculations on a set of values and return a single value.
Common aggregate functions include COUNT, SUM, AVG, MIN, and MAX.
COUNT returns the number of rows in a table or the number of non-null values in a column.
SUM returns the sum of all values in a column.
AVG returns the average of all values in a column.
MIN returns the smallest value in a column.
MAX returns the largest value in a column.
CTE benefits and difference between temp table and table variables
CTE (Common Table Expression) allows for recursive queries and simplifies complex queries
Temp tables are physical tables stored in tempdb and can be indexed and have constraints
Table variables are stored in memory and have limited scope and no statistics
Temp tables are better for large data sets and complex queries, while table variables are better for s
Indexes are data structures that improve the speed of data retrieval operations in a database.
Indexes are created on one or more columns of a table.
Types of indexes include clustered, non-clustered, unique, and full-text indexes.
Clustered indexes determine the physical order of data in a table, while non-clustered indexes create a separate structure to store the index data.
Unique indexes ensure that each value in the i...
I was interviewed before Nov 2020.
Round duration - 360 minutes
Round difficulty - Medium
They give you 6 hr. For 6 question but the good part is that you need to complete atleast 1 question and you are good to go.
Round will be cleared only after attempting one question and rest of the questions are for improving your rank.
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Find pairs of elements in an array that sum up to a given value, sorted in a specific order.
Iterate through the array and for each element, check if the complement (S - current element) exists in a hash set.
If the complement exists, add the pair to the result list.
Sort the result list based on the criteria mentioned in the problem statement.
You are given the arrival and departure times of N trains at a railway station for a particular day. Your task is to determine the minimum number of pl...
The task is to determine the minimum number of platforms needed at a railway station based on arrival and departure times of trains.
Sort the arrival and departure times in ascending order.
Use two pointers to keep track of overlapping schedules.
Increment platform count when a new train arrives before the previous one departs.
You are given a matrix of 'N' rows and 'M' columns and a non-negative integer 'K'. Determine the minimum possible sum of all elements in each submatrix after performing at m...
Given a matrix and a non-negative integer K, find the minimum possible sum of all elements in each submatrix after performing at most K decrements.
Iterate through all submatrices and find the minimum possible sum after performing decrements
Keep track of the number of decrements performed on each element
Use dynamic programming to optimize the solution
Ensure not to decrease any number below 0
Return the minimum possible s
You are given an array/list CHOCOLATES
of size 'N', where each element represents the number of chocolates in a packet. Your task is to distribute these chocolates among 'M'...
Distribute chocolates among students to minimize the difference between the largest and smallest number of chocolates.
Sort the array of chocolates packets.
Use sliding window technique to find the minimum difference between the largest and smallest packets distributed to students.
Consider edge cases like when number of students is equal to number of packets.
You are given two integers DAY_HOURS
and PARTS
. Consider a day with DAY_HOURS
hours, which can be divided into PARTS
equal parts. Your task is to determine the total ins...
Calculate total instances of equivalent prime groups in a day divided into equal parts.
Divide the day into equal parts and find prime numbers in each part.
Identify prime groups where prime numbers occur at the same position in different parts.
Count the total instances of equivalent prime groups.
Ensure each hour in a prime group is in a different part of the day.
Given a matrix named UNIVERSE
with 3 rows and 'N' columns, filled with characters {#, *, .}, where:
The task is to identify constellations shaped like vowels within a matrix filled with characters {#, *, .}.
Iterate through the matrix to find 3x3 constellations shaped like vowels.
Check for vowels 'A', 'E', 'I', 'O', 'U' in each 3x3 constellation.
Print the vowels found in each constellation for each test case.
Round duration - 20 Minutes
Round difficulty - Easy
Tip 1 : learn basics
Tip 2 : learn any oops language and practice.
Tip 3 : code as much as you can.
Tip 1 : short and precise. Upto the point.
Tip 2 : keep few things aside from resume
based on 3 interviews
Interview experience
Senior Engineer
14
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
10
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Specialist
10
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Technical Lead
4
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech