TSI-YATRA.COM Interview Questions and Answers

Q1. Tell me about yourself?
Add your answer
Q2. Why should we hire you?
Add your answer

Q1. VLOOKUP, HLOOKUP, XLOOKUP, SUMIF(S), COUNTIF(S), PIVOT TABLES, CONDITIONAL FORMATTING. Other basic excel questions
Add your answer
Q2. Journal Entries for GL adjustment, intercompany transfer, Revenue recognition, deffered and accrual concepts.
Add your answer

Q1. GDS Commands
Add your answer
Q2. Airline Terminals and Airport Codes
Add your answer

Sabre Commands to Check Availability

Blocking and Booking Tickets

Commands to Check Fare rules

Checking Availability

Infant and Child title

Q1. About Airport Terminals
Add your answer
Q2. About Encode and Decode in GDS
Add your answer

Utilizing scenarios to assess English language proficiency.

Q1. How does your understanding of the job description align with your experience and resume?
Add your answer
Q2. What are your expectations regarding Fragomen?
Add your answer

Question are based on excel

Q1. Scenario based question
Add your answer
Q2. Excel based questions ( v look up )
Add your answer

Q1. Resume based question
Add your answer
Q2. About skills mentioned in resume
Add your answer

Q1. What do you know about travelling
Ans. 
Travelling involves moving from one place to another for various purposes such as leisure, business, or exploration.
• Travelling can be for leisure, business, exploration, or visiting family and friends.

• It allows individuals to experience new cultures, cuisines, and landscapes.

• Travelling can be domestic or international, by various modes of transportation like planes, trains, cars, or ships.

• It can involve staying in hote...read more
Answered by AI
Add your answer
Q2. What do you know about kesari travels
Add your answer

Great xdcx xdvcx sc s cd vd v d bfd bfd b

Q1. Array is goog aor nadmsc
Add your answer
Q2. Graph is best or not
Add your answer

Q1. What are the mother sauces in classical cuisine, and how are they characterized?
Add your answer
Q2. Can you tell me about yourself?
Add your answer

Q1. What is your name?
Ans. 
My name is John Smith.
• My first name is John.

• My last name is Smith.

• I go by the name John Smith.
Answered by AI
Add your answer
Q2. Your branch in college?
Ans. 
I majored in Business Administration with a focus on Operations Management.
• Studied courses like Supply Chain Management, Production Planning, and Inventory Control

• Participated in case competitions related to optimizing production processes

• Completed internships at manufacturing companies to gain hands-on experience
Answered by AI
Add your answer
Q3. What is your fathers name?
Ans. 
My father's name is John Smith.
• His first name is John.

• His last name is Smith.

• He goes by the name John Smith.

• He is known as Mr. Smith in his workplace.
Answered by AI
Add your answer
Q4. Write a sql code for having
Ans. 
SQL code for having clause
• Use the HAVING clause to filter groups based on aggregate functions

• It is used with the GROUP BY clause

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;
Answered by AI
Add your answer
Q5. What is the difference between where and having
Ans. 
WHERE is used to filter rows before grouping or aggregating, while HAVING is used to filter groups after grouping or aggregating.
• WHERE is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

• HAVING is used with GROUP BY clause to filter groups based on a condition

• WHERE is applied before the grouping operation, while HAVING is applied after the grouping operation
Answered by AI
Add your answer

Q1. What is your previous role
Add your answer