Filter interviews by
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
What is difference between stored procedure and Function
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down data into smaller, more manageable tables
It helps in reducing data redundancy by storing data in a structured manner
Normalization ensures data integrity by minimizing data anomalies
There are different normal forms such as 1NF, 2NF, 3NF, BCNF, and 4NF
Views are virtual tables that display data from one or more tables, while stored procedures are a set of SQL statements that perform a specific task.
Views are used to simplify complex queries by storing them as a virtual table.
Views do not store data themselves, but rather display data from underlying tables.
Stored procedures are precompiled sets of SQL statements that can be executed with parameters.
Stored procedures ...
To get the highest salary by grouping department, use SQL queries with GROUP BY and ORDER BY clauses.
Use GROUP BY clause to group the data by department.
Use MAX() function to find the highest salary within each department.
Use ORDER BY clause to sort the results in descending order of salary.
Example: SELECT department, MAX(salary) AS highest_salary FROM employees GROUP BY department ORDER BY highest_salary DESC;
I appeared for an interview before Sep 2016.
I applied via Recruitment Consultant and was interviewed before Sep 2018. There were 4 interview rounds.
I appeared for an interview in Jul 2017.
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
based on 3 interviews
Interview experience
TCS
Accenture
Wipro
Cognizant