Filter interviews by
There are four types of joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN: Returns rows when there is at least one match in both tables.
LEFT JOIN: Returns all rows from the left table, and the matched rows from the right table.
RIGHT JOIN: Returns all rows from the right table, and the matched rows from the left table.
FULL JOIN: Returns rows when there is a match in one of the tables.
Top trending discussions
Aptitude, core concepts and a code
I learned the importance of teamwork and collaboration from my college club.
Developed strong communication skills by working with diverse group of individuals
Learned how to delegate tasks effectively to achieve common goals
Gained experience in problem-solving and conflict resolution through group projects
I want to experience living in a different country and immersing myself in a new culture.
Traveling to a foreign country and learning about their customs and traditions
Trying new foods and experiencing different ways of life
Making friends with locals and exploring the local attractions
Relational DBMS stores data in tables with predefined relationships, while non-relational DBMS stores data in flexible, schema-less formats.
Relational DBMS uses structured query language (SQL) for querying data
Non-relational DBMS can store data in various formats like key-value pairs, document-based, graph databases
Relational DBMS ensures data integrity through normalization and constraints
Non-relational DBMS offers be...
Class is a blueprint for creating objects, abstract class cannot be instantiated and can have abstract methods, interface is a contract for classes to implement certain methods.
Class is a blueprint for creating objects with attributes and methods.
Abstract class cannot be instantiated and can have abstract methods that must be implemented by subclasses.
Interface is a contract for classes to implement certain methods, bu
I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.
Normal questions (technical and logical question)
posted on 19 Jul 2024
posted on 22 Oct 2024
I applied via Company Website and was interviewed in Sep 2024. There were 3 interview rounds.
Question related to profile.
Aptitude test questions
I applied via campus placement at Anna University and was interviewed in Aug 2022. There were 3 interview rounds.
Two Easy questions to be solved
Heap sort is a comparison-based sorting algorithm that uses a binary heap data structure.
Heap sort works by building a binary heap from the array and then repeatedly extracting the maximum element and placing it at the end of the array.
The heap is maintained as a complete binary tree, where each parent node is greater than or equal to its children.
The time complexity of heap sort is O(n log n) and it is an in-place sor...
posted on 9 Dec 2024
I applied via Job Portal and was interviewed before Dec 2023. There were 2 interview rounds.
Full selectors select all descendants of a specified element, while partial selectors select only direct children.
Full selectors use a space between the parent and child elements, while partial selectors use the > symbol.
Full selectors are more general and can target multiple levels of descendants, while partial selectors are more specific and target only direct children.
Example of full selector: div p selects all
ele...
Screen scraping is extracting data from a website's HTML code, while data scraping is extracting data from various sources.
Screen scraping involves extracting data from the visual representation of a website, usually using automation tools like web scrapers.
Data scraping involves extracting data from various sources such as databases, APIs, and documents.
Both screen scraping and data scraping are used to collect and an...
Interview experience
based on 3 reviews
Rating in categories
Software Developer
7
salaries
| ₹1.8 L/yr - ₹9.5 L/yr |
Project Manager
7
salaries
| ₹5.3 L/yr - ₹7 L/yr |
Administration Executive
5
salaries
| ₹2.4 L/yr - ₹3.1 L/yr |
Senior Graphic Designer
5
salaries
| ₹3.8 L/yr - ₹4.5 L/yr |
Senior Web Designer
4
salaries
| ₹3.2 L/yr - ₹5.9 L/yr |
Optum
UnitedHealth
R1 RCM
Apollo Hospitals