Full Name: Ernst & Young Global Limited
Commonly Known As: EY
Founded: 1989 (merger of Ernst & Whinney and Arthur Young & Co.)
Headquarters: London, United Kingdom
Type: Private (Structured as a network of member firms)
Employees: Over 400,000 globally (as of 2024)
Presence: 150+ countries
Ernst & Young (EY) employs a comprehensive recruitment process designed to identify candidates who align with the firm's values and possess the requisite skills. While the process may vary slightly based on the role and location, the general stages are as follows:
Online Application: Candidates begin by submitting their applications through the EY Careers Portal.
Candidate Profile: The application involves creating a profile, uploading a resume, and answering role-specific questions.
Multiple Applications: To apply for more than one position or location, separate applications are required for each.
Assessment Components:
Aptitude Test: Evaluates numerical and logical reasoning skills.
Verbal Ability: Assesses comprehension and communication proficiency.
Coding Test (for technical roles): Includes programming questions to assess problem-solving abilities.
Purpose: These assessments gauge analytical thinking and technical competencies relevant to the role.
Overview Session: For campus recruitments, EY conducts sessions to provide insights into the company's culture, values, and expectations.
Interaction Opportunity: Candidates can engage with EY representatives to understand potential career paths and ask questions.
Evaluation Criteria:
Communication Skills: Clarity and articulation of thoughts.
Teamwork: Ability to collaborate and respect diverse viewpoints.
Problem-Solving: Approach to addressing the given topic or case study.
Note: This round is more common in campus placements and may not be part of all recruitment processes.
Discussion Points:
Academic Projects: In-depth discussion on projects undertaken during studies.
Technical Knowledge: Questions related to programming languages, data structures, algorithms, databases, and system design.
Problem-Solving: Scenario-based questions to assess analytical thinking.
Preparation Tip: Review core subjects and be ready to demonstrate coding proficiency.
Focus Areas:
Cultural Fit: Alignment with EY's values and work culture.
Behavioral Questions: Situational questions to understand past experiences and reactions.
Career Aspirations: Discussion on long-term goals and motivation for joining EY.
Common Questions:
"Why do you want to join EY?"
"Describe a challenging situation and how you handled it."
"What are your strengths and areas for improvement?"
Offer Letter: Successful candidates receive a formal offer detailing role, compensation, and other specifics.
Onboarding Process: Includes orientation sessions, documentation, and integration into EY's work environment.
Academic Performance:
Minimum 80% in 10th and 12th standards.
Minimum 7 CGPA in undergraduate and postgraduate studies.
Backlogs: No active backlogs at the time of application.
Technical Proficiency: Strengthen understanding of core subjects and practice coding problems.
Mock Interviews: Engage in practice interviews to build confidence and receive feedback.
Research: Understand EY's services, recent projects, and organizational culture.
Behavioral Questions: Prepare structured responses using the STAR (Situation, Task, Action, Result) method.
mysql> CREATE TABLE t_index
( column1 INT PRIMARY KEY, column2 INT NOT NULL, column3 INT NOT NULL, column4 VARCHAR(20), INDEX (column1,column2) );
Here, the table has an index that holds two columns – column 1 and column 2.
Now, to add the index to the table, use the following –
mysql>
CREATE INDEX [index] ON [table] (column)
Abstract Class | Interface |
---|---|
Abstract class can contain abstract as well as non-abstract methods. | An interface can contain abstract methods only. |
Abstract class doesn’t support multiple inheritances. | There is a way using which multiple inheritances are possible through an interface. |
An abstract class can provide the implementation of the interface. | An interface cannot provide the implementation of the abstract class. |
An abstract class can contain static and non-static, final and non-final members. | An interface can contain final and static variables. |
Primary Key | Foreign Key |
---|---|
Primary key ensures that data in the specific column is unique. | Foreign key is a column or group of columns used to link between data present in two tables. |
One primary key is possible for a table. | More than one foreign key is possible for a table. |
The primary key value cannot be null. | Primary key values can be null. |
It is used to uniquely identify a record in relation to or table. | It refers to the column in a table that is the primary key of that table. |
Unique and not-null constraints together make the primary key. | It can contain duplicate values. |
Shared lock | Exclusive lock |
---|---|
It allows read-only operation. | It allows ready and writing operations. |
Protect others from updating the data. | Protect others from reading as well as updating the data. |
There is no limitation on the number of transactions that can hold a shared lock on an item. | Exclusive lock can be held by only one transaction |
A shared lock is requested using a shared lock operation. | An exclusive lock is requested using exclusive lock operation. |
CREATE PROCEDURE name_of_the_procedure
AS
sql_statement
GO;
INSERT, SELECT, UPDATE, DELETE
, and so on.