Filter interviews by
I applied via LinkedIn and was interviewed in Dec 2022. There were 3 interview rounds.
Indexing is a technique to improve database performance by reducing the time taken to retrieve data.
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.
Non-clustered indexes are separate structures that contain a copy of the indexed columns and a pointer to the actual data...
Optimize select statements by using indexes, avoiding unnecessary joins, and limiting the number of columns selected.
Use indexes to speed up queries
Avoid unnecessary joins and subqueries
Limit the number of columns selected
Use WHERE clauses to filter results
Use GROUP BY and ORDER BY clauses wisely
Consider using stored procedures or views
Regularly analyze and optimize the database
Stored procedures are pre-written SQL codes that can be saved and reused in a database.
Stored procedures are used to improve database performance and security.
They can be called from within an application or directly from the database.
They can accept input parameters and return output parameters or result sets.
Examples include procedures for inserting, updating, and deleting data.
They can also be used for complex data
Joins are used to combine data from two or more tables based on a related column. A view is a virtual table created from a query.
Joins are used to retrieve data from multiple tables based on a related column
There are different types of joins such as inner join, left join, right join, and full outer join
Views are virtual tables created from a query that can be used to simplify complex queries or restrict access to sensi...
I applied via Recruitment Consultant and was interviewed before Sep 2018. There were 4 interview rounds.
I am a software engineer with experience in developing and maintaining software applications.
I have a strong background in programming languages such as Java, C++, and Python.
I have worked on various projects, including developing web applications and implementing software solutions.
I am skilled in problem-solving and debugging, ensuring efficient and effective software development.
I have experience in collaborating wi...
I learned valuable teamwork and problem-solving skills during my summer internship.
Developed strong collaboration skills by working with a team of software engineers to complete projects
Gained experience in troubleshooting and debugging software issues
Learned to effectively communicate and present technical concepts to both technical and non-technical stakeholders
Improved problem-solving abilities by identifying and re...
Java is an object-oriented language while C is a procedural language.
Java is platform-independent while C is platform-dependent.
Java has automatic garbage collection while C requires manual memory management.
Java has built-in support for multithreading while C requires external libraries.
Java has a larger standard library compared to C.
Java is more secure than C due to its strong type checking and exception handling.
C ...
Pointers are variables that store memory addresses of other variables in programming languages.
Pointers allow direct access and manipulation of memory locations.
They are commonly used in programming languages like C and C++.
Pointers can be used to pass variables by reference, allowing modifications to the original value.
They can also be used to dynamically allocate memory.
Example: int* ptr; // declares a pointer to an
In 5 years, I see myself as a senior software engineer leading a team of developers.
Leading a team of developers
Working on complex projects
Continuing to learn and grow in my role
Contributing to the success of the company
I am a software engineer with experience in developing web applications and expertise in programming languages such as Java and Python.
Proficient in Java and Python programming languages
Experience in developing web applications using frameworks such as Spring and Django
Familiarity with database technologies such as MySQL and MongoDB
Strong problem-solving and analytical skills
Ability to work in a team and collaborate ef
My strengths include problem-solving skills and attention to detail. My weaknesses are sometimes being too critical of my own work and difficulty saying no.
Strengths: problem-solving skills, attention to detail
Weaknesses: being too critical of my own work, difficulty saying no
In the next 5 years, I see myself as a senior software engineer leading a team of developers.
I plan to continue learning and expanding my skillset
I hope to take on more leadership roles and mentor junior developers
I aim to contribute to the development of innovative software solutions
I plan to stay up-to-date with the latest technologies and industry trends
Yes, I know C language. Here's a program to print numbers from 1 to 10 excluding 5.
Use a loop to iterate from 1 to 10
Inside the loop, check if the current number is equal to 5
If it is not equal to 5, print the number
The question was about finding the average of a set of numbers.
I approached the problem by first summing all the numbers in the set.
Then, I divided the sum by the total number of elements in the set to find the average.
I used a loop to iterate through the set and keep track of the sum and count of elements.
based on 1 interview
Interview experience
Devops Engineer
55
salaries
| ₹4 L/yr - ₹11.4 L/yr |
Software Engineer
22
salaries
| ₹4 L/yr - ₹7.2 L/yr |
Project Manager
11
salaries
| ₹7 L/yr - ₹17 L/yr |
Cloud Security Engineer
7
salaries
| ₹4.5 L/yr - ₹6 L/yr |
Cloud Operations Manager
6
salaries
| ₹18.7 L/yr - ₹24 L/yr |
TCS
Accenture
Cognizant
Infosys