BT Group Interview Questions, Process, and Tips

Q1. Diff between Union and Union All
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates.
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Union All is faster than Union as it does not remove duplicates
Answered by AI
Add your answer
Q2. Sets and their uses in Tableau
Ans. 
Sets in Tableau are custom fields that define a subset of data based on certain conditions.
• Sets can be used to group related data together for analysis

• Sets can be created based on dimensions or measures

• Sets can be used in calculations, filters, and visualizations

• Examples: creating a set of top customers, creating a set of high-value products
Answered by AI
Add your answer
Q3. Query to find 2nd highest salary
Ans. 
Query to find 2nd highest salary in a database table
• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to retrieve the second row
Answered by AI
Add your answer
Q4. Some more basic questions
Add your answer

Given some pointers, how will I manage the stakeholders and plan.

Common test related to JD

Q1. Projects you have worked in your previous roles
Add your answer
Q2. Technical question relating to role
Add your answer

Hogan Test for Aptitude

Q1. What would you want to change about HR
Add your answer

Q1. What are your salary expectations
Ans. 
I am open to discussing salary based on the responsibilities and expectations of the role.
• I believe that compensation should be commensurate with the level of responsibility and the value I can bring to the organization.

• I am open to negotiating a fair and competitive salary package.

• I would like to understand the full scope of the role and the company's compensation structure before discussing specific numbers.

• I am conf...read more
Answered by AI
Add your answer
Q2. What is your total work experience?
Ans. 
I have over 20 years of work experience in various senior executive roles.
• Over 20 years of work experience

• Extensive experience in senior executive roles

• Proven track record of leadership and strategic decision-making

• Successfully managed large teams and implemented organizational initiatives

• Strong understanding of industry trends and market dynamics

• Implemented cost-saving measures resulting in significant financial gains

• ...read more
Answered by AI
Add your answer
Q3. Why did you leave previous oraganisatuon?
Ans. 
I left my previous organization to pursue new challenges and opportunities for growth.
• Seeking new challenges and opportunities for growth

• Looking for a more fulfilling role

• Desire for career advancement

• Change in personal circumstances

• Company restructuring or downsizing

• Incompatibility with company culture or values
Answered by AI
Add your answer
Q4. What do you expect from this organisation?
Ans. 
I expect this organization to provide a challenging and supportive environment where I can contribute my expertise and make a meaningful impact.
• Opportunities for professional growth and advancement

• Clear communication and transparency

• Collaborative and inclusive work culture

• Recognition and appreciation for achievements

• Adequate resources and support to fulfill responsibilities

• Alignment with the organization's mission and
Answered by AI
Add your answer
Q5. Why do we hire you ?
Ans. 
You should hire me because of my extensive experience, proven leadership skills, and ability to drive results.
• Extensive experience in the industry

• Proven track record of successful leadership

• Ability to drive results and achieve goals

• Strong strategic thinking and problem-solving skills

• Excellent communication and interpersonal skills

• Passion for the company's mission and vision

• Ability to inspire and motivate teams

• Adaptabil
Answered by AI
Add your answer