British Airways Advisor Interview Questions and Answers

Q1. Why are you leaving your current job
Add your answer
Q2. Are you willing to relocate
Add your answer

Q1. Explain the types of basic joins
Ans. 
Basic joins in SQL combine rows from two or more tables based on related columns, enabling data retrieval across multiple datasets.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all reco...read more
Answered by AI
Add your answer

Q1. Why United Airlines
Ans. 
United Airlines stands out for its commitment to customer service, innovation, and sustainability in the aviation industry.
• Strong focus on customer experience, evident in their MileagePlus loyalty program that rewards frequent flyers.

• Innovative use of technology, such as the United app for seamless check-in and flight updates.

• Commitment to sustainability, with initiatives like reducing carbon emissions and investing in...read more
Answered by AI
Add your answer
Q2. How do you identify outliers in a dataset
Add your answer

It was a SQL and Excel assignment

Q1. SQL , python questions
Add your answer

Discuss about the company to low level management to top level management and analysis the prior period statements

Study about the prior period statements of the company

Q1. Asked about the project
Add your answer

Q1. Questions based on previous work experience and projects
Add your answer

Q1. SQL questions based on joins and window functions, data visualization, and case study
Add your answer

Q1. General profile screening, basic information
Add your answer

Q1. 1. Walk me through your Resume 2. Technical questions related to SQL 3. Behavioural questions
Add your answer

Q1. Behavioural questions on time management, stress management, 1 puzzle question
Add your answer

Were very hard questions and all were related to basic arithmetic and analytics and statistics.

Q1. What is the expected salary and current work profile.
Add your answer
Q2. About my skills and expertise.
Add your answer