Filter interviews by
I was interviewed in Jul 2023.
Having clause is used in SQL to filter groups based on specified conditions after the group by clause.
Used in SQL queries to filter groups of rows based on specified conditions
Applied after the group by clause
Similar to where clause but operates on groups rather than individual rows
Aggregate functions are functions in databases that perform a calculation on a set of values and return a single value.
Aggregate functions are used in SQL queries to perform operations on groups of rows and return a single result.
Examples of aggregate functions include SUM, AVG, COUNT, MIN, and MAX.
These functions are commonly used with the GROUP BY clause to group rows based on a specific column.
Enum in SQL is a data type that restricts a column's value to a predefined set of constants.
Enum is used to define a list of possible values for a column.
It helps in ensuring data integrity by limiting the values that can be inserted into a column.
Example: CREATE TABLE Users (gender ENUM('Male', 'Female', 'Other'));
var and let are both used for variable declaration in JavaScript, but they have different scopes and hoisting behaviors.
var has function scope and is hoisted to the top of the function, while let has block scope and is not hoisted.
Variables declared with var can be redeclared within the same scope, but variables declared with let cannot.
Using var outside of a function will declare the variable in the global scope, whil...
Top trending discussions
posted on 24 Dec 2024
I applied via LinkedIn and was interviewed in Nov 2024. There were 4 interview rounds.
Experienced Full Stack Developer with expertise in front-end and back-end technologies.
Experienced in HTML, CSS, JavaScript for front-end development
Proficient in Node.js, Express, MongoDB for back-end development
Familiar with React, Angular for building interactive web applications
GraphQL is a query language for APIs and a runtime for executing those queries. REST API is a set of rules for building web services. Both have their own advantages.
GraphQL allows clients to request only the data they need, reducing over-fetching and under-fetching.
REST API follows a more rigid structure and is easier to understand for beginners.
GraphQL is more efficient for complex queries involving multiple resources...
I was asked to discuss the system design of Google Meet, with a primary focus on video processing and WebRTC.
A graph question regarding LC 1334.
Experienced Full Stack Developer with a passion for creating innovative solutions and a strong desire to contribute to a dynamic team.
Over 5 years of experience in full stack development, working on various projects from concept to deployment.
Proficient in front-end technologies such as HTML, CSS, JavaScript, and React.
Skilled in back-end technologies including Node.js, Express, and MongoDB.
Motivated by the opportunity...
Eq and iq test that contain you emotions management
The $lookup operator in MongoDB is used to perform a left outer join between two collections.
Used to combine data from two collections based on a common field
Requires a local field and a foreign field to match documents
Returns an array of documents that include matched data from both collections
The $graphlookup operator in MongoDB is used to perform recursive queries on graph-like data structures.
Used to perform recursive queries on graph-like data structures
Can be used to traverse relationships between documents in a collection
Helps in querying hierarchical data structures
I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.
It was good and to the point
posted on 1 Jun 2021
I applied via LinkedIn and was interviewed in May 2021. There was 1 interview round.
posted on 1 Nov 2024
I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.
Number series in aptitude involves identifying the pattern in a sequence of numbers and predicting the next number.
Look for patterns such as arithmetic progression, geometric progression, or a combination of both.
Check for alternate numbers, differences between consecutive numbers, or multiplication factors.
Consider prime numbers, squares, cubes, or other mathematical operations applied to the series.
Example: 2, 4, 6, ...
Relationships in verbal communication are crucial for effective collaboration and understanding.
Verbal communication involves both verbal and non-verbal cues
Active listening is key to building strong relationships in verbal communication
Clarity and conciseness in speech can enhance relationships
Empathy and understanding of others' perspectives are important in verbal relationships
The four branches of OOP are encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Inheritance: Allowing a class to inherit properties and behavior from another class.
Polymorphism: The ability for objects of different classes to respond to the same method call.
Abstraction: Hiding the complex implementation details and showing only
Structures in C are user-defined data types that allow grouping of variables of different data types under a single name.
Structures are used to represent a record which consists of different data types.
They are defined using the 'struct' keyword.
Each variable in a structure is called a member.
Structures can be nested within other structures.
Example: struct employee { int emp_id; char emp_name[50]; float emp_salary; };
E
I was interviewed in Nov 2024.
The aptitude test evaluates problem-solving, coding skills, and logical reasoning, offering a fair challenge to showcase technical expertise.
I address conflicts in team projects by promoting open communication, active listening, and seeking compromise.
Encourage open communication among team members to address conflicts early on
Practice active listening to understand all perspectives and concerns
Seek compromise and find common ground to resolve conflicts effectively
Interface is a contract that defines the methods a class must implement, while an abstract class can have both implemented and abstract methods.
Interface can only have abstract methods and cannot have any implementation, while abstract class can have both abstract and implemented methods.
A class can implement multiple interfaces but can only inherit from one abstract class.
Interfaces are used to achieve multiple inheri...
posted on 17 Jan 2025
I applied via Campus Placement and was interviewed in Sep 2024. There were 3 interview rounds.
Aptitude questions with some basic coding questions
They have given 3 coding questions and some pseudo codings
posted on 17 Oct 2024
I applied via campus placement at Dr Mahalingam College of Engineering & Technology, Coimbatore and was interviewed in Sep 2024. There were 3 interview rounds.
Logical thinking and quantitative
One Java and one SQL and one js question
Collections are data structures that store and organize multiple elements in a single unit.
Collections provide methods to add, remove, and manipulate elements.
Examples of collections include arrays, lists, sets, and maps.
Collections can be used to efficiently manage and access large amounts of data.
A constructor is a special method in a class that is automatically called when an object of that class is created.
Constructors have the same name as the class they belong to
They are used to initialize the object's state
Constructors can have parameters to customize the initialization process
Data science is a field that uses scientific methods, algorithms, and systems to extract knowledge and insights from structured and unstructured data.
Data science involves collecting, analyzing, and interpreting large amounts of data to make informed decisions.
It combines statistics, machine learning, and domain knowledge to uncover patterns and trends in data.
Data scientists use programming languages like Python and R...
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Operations Executive
5
salaries
| ₹2.1 L/yr - ₹3.5 L/yr |
Business Development Executive
5
salaries
| ₹2 L/yr - ₹3 L/yr |
MIS Executive
5
salaries
| ₹1.8 L/yr - ₹3.8 L/yr |
IT Operations Executive
5
salaries
| ₹1.2 L/yr - ₹3 L/yr |
Data Analyst
4
salaries
| ₹3.6 L/yr - ₹5 L/yr |
Reliance Industries
Tata Group
Adani Group
Bharti Enterprises