i
Aristocrat
Filter interviews by
Clear (1)
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 ...
Top trending discussions
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
Contained aptitude test with both numericals as well as coding questions
It was a one on one round
Yes, I am open to relocation for the right opportunity.
I am willing to relocate for a job that aligns with my career goals and offers growth opportunities.
I am open to exploring new cities and cultures.
I understand that relocation may come with some challenges, but I am prepared to face them.
I am excited about the prospect of working with a new team and contributing to the success of the company.
I applied via Naukri.com and was interviewed before Nov 2021. There were 5 interview rounds.
I was given 10 logical questions to solve on a portal with 30min timer.
Most question were printing of patterns, fibonacci, prime no., palindrome etc.
out of 10 questions atleast 8 has to be right to qualify.
Systematic interview test
Java is a popular programming language used for developing various applications. OOPs concepts refer to Object-Oriented Programming principles.
Java is a high-level, class-based, object-oriented programming language.
OOPs concepts include Inheritance, Encapsulation, Polymorphism, and Abstraction.
Inheritance allows a class to inherit properties and behavior from another class.
Encapsulation refers to bundling data and meth...
3 coding questions and 10 logical reasoning questions
Play a game on tablet which consists of coding questions
Basic coding test like palindrome, series,arrays
I applied via Company Website and was interviewed in Feb 2023. There were 6 interview rounds.
Prepare aptitude well as some questions are tricky which consume our time. There are 20 questions in total. And most of them are mathematical numeric problems.
This round is included in aptitude round in which you have to write down 3 coding problems which are easy one if you are moderate programmer
based on 1 interview
Interview experience
Senior Technical Lead
208
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
203
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Engineer
118
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Engineer II
96
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
94
salaries
| ₹0 L/yr - ₹0 L/yr |
International Game Technology
Light & Wonder
Playtech India
Bet365