50+ Ernst & Young Interview Questions and Answers

Clustering groups data points based on similarity while classification assigns labels to data points based on predefined categories.

• Clustering is unsupervised learning while classification is supervised learning.

• Clustering is used to find patterns in data while classification is used to predict the category of a data point.

• Examples of clustering algorithms include k-means and hierarchical clustering while examples of classification algorithms include decision trees and logist...read more

DBMS stands for Database Management System, while RDBMS stands for Relational Database Management System. RDBMS is a type of DBMS.

• DBMS is a software system that allows users to define, create, maintain and control access to the database.

• RDBMS is a type of DBMS that stores data in a structured format using tables with rows and columns.

• RDBMS enforces a set of rules called ACID properties to ensure data integrity, while DBMS may not necessarily enforce these rules.

• Examples of DB...read more

Encapsulation, Inheritance, Polymorphism, Abstraction

• Encapsulation: Bundling data and methods that operate on the data into a single unit

• Inheritance: Ability of a class to inherit properties and behavior from another class

• Polymorphism: Ability to present the same interface for different data types

• Abstraction: Hiding the complex implementation details and showing only the necessary features

To understand customer behaviour based on credit card transaction, I would analyze spending patterns, transaction frequency, and purchase categories.

• Analyze spending patterns to identify high and low spenders

• Analyze transaction frequency to identify regular and irregular customers

• Analyze purchase categories to identify customer preferences and interests

• Use data visualization tools to identify trends and patterns

• Compare customer behavior to industry benchmarks and competitors

• I...read more

Object oriented programming is a programming paradigm based on the concept of objects, which can contain data and code.

• Objects are instances of classes, which define the structure and behavior of the objects.

• Encapsulation, inheritance, and polymorphism are key principles of object oriented programming.

• Example: Inheritance allows a class to inherit properties and methods from another class.

• Example: Encapsulation hides the internal state of an object and only exposes necessary ...read more

My area of interest is machine learning and artificial intelligence.

• I enjoy working with large datasets and developing algorithms to analyze and extract insights from them.

• I have experience with various machine learning techniques such as regression, classification, and clustering.

• I am also interested in natural language processing and computer vision.

• Some examples of my work include developing a recommendation system for an e-commerce website and building a chatbot for custo...read more

Code implementing all 4 pillars of OOPs

• Encapsulation: Encapsulate data within classes and provide public methods to access and modify the data.

• Inheritance: Create a hierarchy of classes where child classes inherit attributes and methods from parent classes.

• Polymorphism: Allow objects of different classes to be treated as objects of a common superclass through method overriding and overloading.

• Abstraction: Hide complex implementation details and only show the necessary feature...read more

SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.

• SQL stands for Structured Query Language and is used to communicate with databases.

• SQL is a standard language that can be used with various database management systems.

• MySQL is a specific open-source relational database management system that uses SQL.

• MySQL is one of the most popular database management systems that uses SQL for querying and managing ...read more

Code to find the 2nd largest element in an array

• Sort the array in descending order and return the element at index 1

• Iterate through the array and keep track of the two largest elements

• Handle edge cases like arrays with less than 2 elements

Different types of join include inner, outer, left, right, cross, and self join.

• Inner join returns only the matching rows from both tables.

• Outer join returns all rows from both tables and null values for non-matching rows.

• Left join returns all rows from the left table and null values for non-matching rows from the right table.

• Right join returns all rows from the right table and null values for non-matching rows from the left table.

• Cross join returns the Cartesian product of b...read more

I approach conflicts by actively listening, identifying the root cause, and finding a mutually beneficial solution.

• Listen to all parties involved and understand their perspectives

• Identify the root cause of the conflict

• Brainstorm potential solutions with all parties

• Find a mutually beneficial solution

• Communicate the solution clearly and ensure all parties agree

C is a procedural programming language while C++ is an object-oriented programming language.

• C is a procedural programming language, while C++ supports both procedural and object-oriented programming.

• C does not have classes and objects, while C++ does.

• C does not support function overloading, while C++ does.

• C does not have exception handling, while C++ does.

• C does not have namespaces, while C++ does.

Delete removes specific rows from a table, Truncate removes all rows from a table, and Drop removes the table itself.

• Delete is a DML command that removes specific rows from a table based on a condition.

• Truncate is a DDL command that removes all rows from a table but keeps the table structure.

• Drop is a DDL command that removes the entire table along with its structure.

Merge sort is a divide and conquer algorithm that divides the input array into two halves, sorts them recursively, and then merges them.

• Divide the input array into two halves

• Recursively sort each half

• Merge the sorted halves back together

Banking products include savings accounts, checking accounts, loans, credit cards, and investment accounts.

• Savings accounts: earn interest on deposited funds

• Checking accounts: used for daily transactions and bill payments

• Loans: borrowed money with interest

• Credit cards: allows purchases on credit with interest

• Investment accounts: used to invest in stocks, bonds, and mutual funds

I would like to create a program that generates a random password.

• Use a combination of letters, numbers, and special characters

• Allow the user to specify the length of the password

• Ensure that the password is strong and not easily guessable

Different types of joins in DBMS include inner join, outer join, left join, right join, and full join.

• Inner join: Returns rows when there is a match in both tables.

• Outer join: Returns all rows from one table and only matching rows from the other table.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full join: Returns rows when there is a match i...read more

Stacks are Last In First Out (LIFO) data structures, while Queues are First In First Out (FIFO) data structures.

• Stacks: Elements are added and removed from the same end, like a stack of plates. Example: Undo feature in text editors.

• Queues: Elements are added at the rear and removed from the front, like a line of people waiting. Example: Print queue in a printer.

Lazy evaluation in Spark delays the execution of transformations until an action is called.

• Lazy evaluation allows Spark to optimize the execution plan by combining multiple transformations into a single stage.

• Transformations are not executed immediately, but are stored as a directed acyclic graph (DAG) of operations.

• Actions trigger the execution of the DAG and produce results.

• Example: map() and filter() are transformations that are lazily evaluated until an action like collec...read more

Skewness is a measure of asymmetry in a distribution. Skewed tables are tables with imbalanced data distribution.

• Skewness is a statistical measure that describes the asymmetry of the data distribution around the mean.

• Positive skewness indicates a longer tail on the right side of the distribution, while negative skewness indicates a longer tail on the left side.

• Skewed tables in data engineering refer to tables with imbalanced data distribution, which can impact query performan...read more

Spark is a distributed computing framework designed for big data processing.

• Spark is built around the concept of Resilient Distributed Datasets (RDDs) which allow for fault-tolerant parallel processing of data.

• It provides high-level APIs in Java, Scala, Python, and R for ease of use.

• Spark can run on top of Hadoop, Mesos, Kubernetes, or in standalone mode.

• It includes modules for SQL, streaming, machine learning, and graph processing.

• Spark uses in-memory processing to speed up ...read more

List is mutable, tuple is immutable in Python.

• List can be modified after creation, tuple cannot.

• List uses square brackets [], tuple uses parentheses ().

• List is used for collections of items that may change, tuple for fixed collections.

• Example: list - [1, 2, 3], tuple - (1, 2, 3)

Binary search is a divide and conquer algorithm that finds the position of a target value within a sorted array.

• Start by defining the low and high indices of the array.

• Calculate the middle index and compare the target value with the middle element.

• If the target value is less than the middle element, update the high index to mid-1.

• If the target value is greater than the middle element, update the low index to mid+1.

• Repeat the process until the target value is found or the low ...read more

Strengths: Leadership skills, problem-solving abilities, strong communication. Weaknesses: Impatience, perfectionism, delegation.

• Strengths: Leadership skills - ability to motivate and guide team members towards goals

• Problem-solving abilities - adept at finding solutions to complex issues

• Strong communication - effective at conveying ideas and information clearly

• Weaknesses: Impatience - tendency to rush through tasks without thorough consideration

• Perfectionism - difficulty in a...read more

MapReduce is a programming model and processing technique for parallel and distributed computing.

• MapReduce is used to process large datasets in parallel across a distributed cluster of computers.

• It consists of two main functions - Map function for processing key/value pairs and Reduce function for aggregating the results.

• Popularly used in big data processing frameworks like Hadoop for tasks like data sorting, searching, and counting.

• Example: Counting the frequency of words in...read more

Data frames in pandas are two-dimensional, size-mutable, and potentially heterogeneous tabular data structures with labeled axes (rows and columns).

• Data frames are like spreadsheets or SQL tables with rows and columns.

• They can hold different types of data in each column.

• Data frames can be created from dictionaries, lists, or other data structures.

• Operations like filtering, merging, and grouping can be performed on data frames.

• Example: df = pd.DataFrame({'A': [1, 2, 3], 'B': [...read more

Social media has advantages like easy communication and networking, but also has disadvantages like cyberbullying and addiction.

• Advantages: easy communication, networking, access to information, marketing opportunities

• Disadvantages: cyberbullying, addiction, spread of misinformation, privacy concerns

• Example: Social media can be used to connect with friends and family, but can also lead to cyberbullying and mental health issues.

• Example: Social media can be used for marketing a...read more

NAV components refer to the various elements that make up the Net Asset Value of a fund.

• NAV components include assets, liabilities, income, and expenses.

• Assets can include stocks, bonds, and other investments held by the fund.

• Liabilities can include expenses owed by the fund, such as management fees.

• Income can include dividends and interest earned by the fund.

• Expenses can include management fees, legal fees, and other costs associated with running the fund.

Find the greatest element in an array of strings.

• Convert the strings to numbers if applicable before comparing.

• Use a loop to iterate through the array and keep track of the greatest element.

• Handle edge cases like empty array or non-numeric strings.

Feature selection methods help in selecting the most relevant features for building predictive models.

• Feature selection methods aim to reduce the number of input variables to only those that are most relevant.

• Common methods include filter methods, wrapper methods, and embedded methods.

• Examples include Recursive Feature Elimination (RFE), Principal Component Analysis (PCA), and Lasso regression.

VPN stands for Virtual Private Network, a technology that allows users to securely access a private network over a public network.

• VPN creates a secure and encrypted connection between the user's device and the private network.

• It masks the user's IP address and encrypts data to ensure privacy and security.

• VPN can be used to access restricted websites, secure remote access to a company's network, and protect data while using public Wi-Fi.

• Popular VPN services include NordVPN, Ex...read more

I am highly efficient and always strive to complete tasks quickly without sacrificing quality.

• I prioritize tasks based on urgency and impact on users

• I constantly look for ways to streamline processes and improve efficiency

• I have a track record of resolving issues promptly and effectively

• I am proficient in troubleshooting and problem-solving techniques

DHCP (Dynamic Host Configuration Protocol) is a network protocol that automatically assigns IP addresses to devices on a network.

• DHCP server assigns IP addresses to devices on a network

• DHCP clients request IP addresses from the DHCP server

• DHCP lease time determines how long an IP address is valid for

• DHCP uses UDP port 67 for server and port 68 for client communication