Filter interviews by
Be the first one to contribute and help others!
I applied via Company Website and was interviewed in Dec 2019. There were 4 interview rounds.
Explanation of row number, rank, dense rank, partition by, indexing joins, and query optimization techniques.
Row number is a function that assigns a unique number to each row in a result set.
Rank is a function that assigns a rank to each row based on the values in a specified column.
Dense rank is a function that assigns a rank to each row based on the values in a specified column, but with no gaps in the ranking.
Partit...
Real-time examples of data analytics
Predictive maintenance in manufacturing
Real-time fraud detection in banking
Personalized recommendations in e-commerce
Real-time traffic analysis for smart cities
Real-time health monitoring in medical devices
posted on 7 Mar 2022
I applied via Walk-in and was interviewed before Mar 2021. There were 2 interview rounds.
Link list program, few objective based on cpp
I applied via Approached by Company and was interviewed before Jul 2021. There were 7 interview rounds.
I applied via Naukri.com and was interviewed before Nov 2023. There was 1 interview round.
3 online dsa questions easy to medium
I applied via IIM Jobs and was interviewed in Jun 2024. There were 3 interview rounds.
SQL Coding Test - asked 5 queries related to joins, ranks, group by
Asked guesstimates, technical CV Question, case
Asked guesstimate, market entry question, case
I applied via Naukri.com and was interviewed in Aug 2023. There were 3 interview rounds.
A bug in an application is an error, flaw, failure, or fault in the software code that causes it to produce incorrect or unexpected results.
Bugs can range from simple syntax errors to complex logic issues.
Common types of bugs include logic errors, syntax errors, and runtime errors.
Examples of bugs include a calculator app displaying incorrect results, a website crashing when a specific button is clicked, or a game free
Bug life cycle includes identification, reporting, fixing, retesting, and closing.
Identification: Bug is identified by testers during testing.
Reporting: Testers report the bug to developers.
Fixing: Developers fix the bug in the code.
Retesting: Testers retest the fixed bug to ensure it is resolved.
Closing: Once bug is confirmed fixed, it is closed.
Question completely out of domain
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
Union removes duplicate rows from the result set, while Union all includes all rows.
Union sorts the result set, while Union all does not.
Union is slower than Union all because it performs a distinct operation.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FRO
Joins are generally faster than unions.
Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.
Joins can utilize indexes on the columns being joined, which can improve performance.
Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...
based on 7 reviews
Rating in categories
Administration Executive
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Legal & Compliance Officer
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Pole To Win
International Game Technology
Ubisoft Entertainment
Aristocrat