Filter interviews by
Online test on sql join sub query
Spark Context is the entry point to any Spark functionality while Spark Session is a unified entry point for Spark 2.0+.
Spark Context is the old entry point to Spark functionality.
Spark Session is a unified entry point for Spark 2.0+.
Spark Context is used to create RDDs, accumulators and broadcast variables.
Spark Session is used to create DataFrames, execute SQL queries and read data from external sources.
Repartitioning increases partitions while Coalesce reduces partitions.
Repartitioning shuffles data across the cluster and can be used to increase parallelism.
Coalesce merges partitions without shuffling data and can be used to reduce overhead.
Repartitioning is expensive and should be used sparingly.
Coalesce is faster but may not be as effective as repartitioning in increasing parallelism.
Both can be used to optimize da
Sql query to find Second Highest Salary
Use ORDER BY and LIMIT to select the second highest salary
Use subquery to select the maximum salary and exclude it from the result set
Handle cases where there are ties for the highest salary
Spark is a distributed computing engine that processes large datasets in parallel across a cluster of computers.
Spark uses a master-slave architecture with a driver program that coordinates tasks across worker nodes.
Data is stored in Resilient Distributed Datasets (RDDs) that can be cached in memory for faster processing.
Spark supports multiple programming languages including Java, Scala, and Python.
Spark can be used f...
Broadcast Join is a technique used in distributed computing to optimize join operations.
Broadcast Join is used when one table is small enough to fit in memory of all nodes in a cluster.
The smaller table is broadcasted to all nodes in the cluster, reducing network traffic.
Broadcast Join is faster than other join techniques when used appropriately.
Example: Joining a small reference table with a large fact table in a data
I applied via Naukri.com and was interviewed before Jun 2022. There were 3 interview rounds.
They gave me case study in interview based on that I had provide the solution.
posted on 20 May 2024
I applied via Campus Placement and was interviewed in Nov 2023. There were 2 interview rounds.
It consited of apti as well as coding questions
Polymorphism is a key feature of OOP in C#. Extension methods allow adding new functionality to existing types.
Polymorphism allows objects of different classes to be treated as if they are of the same type.
Extension methods are static methods that can be called as if they were instance methods of the extended type.
Polymorphism and extension methods can be used together to add new behavior to existing types without modi
Angular is a framework for building web applications using TypeScript, which is a superset of JavaScript.
Angular provides a structure for building web applications using components, services, and modules.
TypeScript is a statically typed language that provides better tooling and error checking than JavaScript.
Services in Angular are used for sharing data and functionality across components.
Components in Angular are the ...
I applied via Naukri.com and was interviewed before Oct 2021. There were 2 interview rounds.
posted on 19 Oct 2024
I am a software engineer with 5 years of experience in developing web applications using Java, Spring Boot, and Angular.
5 years of experience in software development
Proficient in Java, Spring Boot, and Angular
Strong problem-solving skills
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Associate Manager
238
salaries
| ₹6 L/yr - ₹16 L/yr |
Business Manager
149
salaries
| ₹6.8 L/yr - ₹18 L/yr |
Senior Associate
137
salaries
| ₹7.8 L/yr - ₹26 L/yr |
Analyst
117
salaries
| ₹3 L/yr - ₹8.2 L/yr |
Associate
110
salaries
| ₹3.2 L/yr - ₹12.3 L/yr |
R.R. Donnelley
Epsilon
Smollan Group
ChannelPlay