Filter interviews by
Clear (1)
I applied via LinkedIn and was interviewed in Feb 2024. There was 1 interview round.
I applied via Referral and was interviewed before Aug 2022. There were 3 interview rounds.
Yes, aggregate functions can be used with HAVING and WHERE clauses. WHERE filters rows before grouping, HAVING filters groups after grouping.
Aggregate functions can be used with HAVING clause to filter groups based on the result of the aggregate function.
Aggregate functions can also be used with WHERE clause to filter rows before grouping.
WHERE clause filters rows before grouping, while HAVING clause filters groups aft...
The order of execution of a SQL query is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
FROM: Specifies the tables involved in the query
WHERE: Filters the rows based on specified conditions
GROUP BY: Groups the rows that have the same values into summary rows
HAVING: Filters the groups based on specified conditions
SELECT: Selects the columns to be displayed in the result set
ORDER BY: Sorts the result set based on speci
User Defined Functions, Stored Procedures, and Triggers are database objects used to perform specific tasks in database management systems.
User Defined Functions are custom functions created by users to perform specific calculations or operations in a database.
Stored Procedures are precompiled SQL statements that can be executed by calling the procedure name.
Triggers are special types of stored procedures that are auto...
I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
Complex SQL scenarios and their results
Using subqueries to filter data
Joining multiple tables with complex conditions
Using window functions to calculate running totals
Pivoting data to transform rows into columns
Using recursive queries to traverse hierarchical data
I was interviewed in Nov 2021.
Payment methods and per transaction cost for income processing.
Payment methods include credit/debit cards, bank transfers, and digital wallets.
Per transaction cost varies depending on the payment method and the service provider.
For example, credit card transactions may have a higher cost compared to bank transfers.
It is important to consider the cost and convenience of each payment method when choosing a service provid
I applied via Referral and was interviewed before Apr 2021. There was 1 interview round.
I was interviewed before Mar 2021.
To check if a number is a power of 2, we can use bitwise operations.
A power of 2 has only one bit set to 1, so we can use the bitwise AND operator to check if the number is a power of 2.
If n is a power of 2, then n & (n-1) will be 0.
For example, 8 (1000 in binary) is a power of 2, and 8 & 7 (0111 in binary) is 0.
Sort a stack without using another data structure
Use recursion to pop the top element and insert it at the bottom of the remaining stack
Repeat until the stack is sorted in ascending order
Time complexity: O(n^2), space complexity: O(n) due to recursion
Check if array has continuous increasing and decreasing values
Loop through the array and check if each element is greater than the previous one
Once you find the maximum element, check if the remaining elements are in decreasing order
If yes, return true else false
Design a cricinfo (LLD)
Identify the entities: players, teams, matches, scorecards, tournaments, etc.
Define the relationships between entities
Create a database schema to store the data
Implement APIs to fetch and update data
Design a UI to display the information
Consider scalability and performance
Ensure data security and privacy
posted on 6 Oct 2024
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.
You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.
ADF supports a wide range of d...
based on 1 interview
Interview experience
Technical Support Engineer 3
40
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Support Engineer
29
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
22
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Support Engineer 2
15
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer III
13
salaries
| ₹0 L/yr - ₹0 L/yr |
Gen
McAfee
Palo Alto Networks
Check Point Software Technologies