Filter interviews by
posted on 22 Jul 2023
Join in SQL is used to combine rows from two or more tables based on a related column between them.
Join is used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
CTE stands for Common Table Expression in SQL, used to create temporary result sets for complex queries.
CTE is defined using the WITH keyword followed by a query.
It helps in breaking down complex queries into smaller, more manageable parts.
CTEs can reference themselves recursively, making them useful for hierarchical data.
They are commonly used in scenarios where subqueries or temporary tables would be used.
Example: WI...
Yes, I have a personal system for organizing my work and personal tasks.
I use a combination of digital tools like Trello and Google Calendar to keep track of my tasks and deadlines.
I also have a physical planner where I jot down important notes and reminders.
Having a personal system helps me stay organized and efficient in managing my workload.
Yes, we have Tableau in our system for data visualization and analysis.
We use Tableau for creating interactive dashboards and reports.
Tableau helps us in visualizing complex data and identifying trends.
Our team is trained in using Tableau for data analysis and reporting.
Top trending discussions
I was interviewed before Sep 2016.
I applied via Recruitment Consultant and was interviewed before Sep 2018. There were 4 interview rounds.
I was interviewed 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 1 interview
Interview experience
based on 1 review
Rating in categories
Software Developer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
3
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Accenture
Wipro
Cognizant