Filter interviews by
I appeared for an interview 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
For loop is used for iterating over a range of values while for each loop is used for iterating over elements of an array.
For loop is used when the number of iterations is known beforehand.
For each loop is used when the number of iterations is not known beforehand.
For loop can be used with any iterable object.
For each loop can only be used with arrays and other iterable objects.
For loop uses an index variable to access...
I appeared for an interview before Aug 2016.
posted on 29 Aug 2023
I applied via Naukri.com and was interviewed in Jul 2023. There were 3 interview rounds.
Basic Aptitude Test
posted on 12 Sep 2023
I applied via Naukri.com and was interviewed before Sep 2022. There were 3 interview rounds.
Advanced JS, PHP related questions
posted on 24 Oct 2024
posted on 8 Nov 2024
I applied via Cutshort and was interviewed in Oct 2024. There was 1 interview round.
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...
I applied via Recruitment Consulltant and was interviewed before Apr 2023. There were 3 interview rounds.
An actual component is a reusable and modular piece of software that performs a specific function within a larger system.
Components are often designed to be independent and can be easily integrated into different systems.
Examples of components include buttons, input fields, and dropdown menus in a user interface.
Components can have their own logic, styling, and functionality, making them versatile building blocks for s
Designing the architecture for a software system involves planning the structure and components of the system.
Identify the key components of the system and their interactions
Choose appropriate technologies and frameworks for each component
Consider scalability, performance, security, and maintainability
Create a detailed diagram or documentation of the architecture
posted on 11 Feb 2022
I applied via Campus Placement and was interviewed in Aug 2021. There were 4 interview rounds.
1st test was aptitude and a easy coding test
The 2nd test was pure coding based test on hacker rank platform and contains 2 easy and 2 medium question
based on 1 interview
Interview experience
based on 1 review
Rating in categories
MIS Executive
6
salaries
| ₹1.8 L/yr - ₹3.8 L/yr |
Operations Executive
5
salaries
| ₹2.1 L/yr - ₹3.5 L/yr |
Business Development Executive
5
salaries
| ₹2 L/yr - ₹3 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 |
Appsierra
Diverse Lynx
Accel Frontline
Prologic Web Solutions