AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Tek Travels Interview Questions and Answers
Tek Travels Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in Feb 2021. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. It was all about sql queries. How do you fetch matching rows from given two tables?
- Ans.
Use SQL JOIN operations to fetch matching rows from two tables based on a common key.
Use INNER JOIN to fetch rows that have matching values in both tables. Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
Use LEFT JOIN to fetch all rows from the first table and matching rows from the second. Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;
Use RIGHT JOIN to fetch all rows ...
- Q2. Given a scenario where a table:project was given and need to fetch project details where project name starts with a.
- Ans.
Fetch project details where the project name starts with 'A' using SQL query.
Use SQL SELECT statement to retrieve data from the 'project' table.
Utilize the WHERE clause with the LIKE operator to filter results.
Example SQL query: SELECT * FROM project WHERE project_name LIKE 'A%';
The '%' wildcard allows for any characters to follow 'A'.
Ensure proper indexing on the project_name column for performance.
- Q3. Using like operator and write the query also.
- Ans.
The LIKE operator in SQL is used to search for a specified pattern in a column.
The LIKE operator is often used with wildcard characters: '%' and '_'.
Example: SELECT * FROM employees WHERE name LIKE 'A%'; // Finds names starting with 'A'.
Example: SELECT * FROM products WHERE code LIKE 'P__'; // Finds codes like 'P01', 'PAB', etc.
The '%' wildcard represents zero or more characters, while '_' represents a single character...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Interview Preparation Tips
Skills: Java, Data structures, Algorithm
College Name: na
Interview Preparation Tips
Experience: 1. Rotate a matrix by 90 degrees clockwise.( He asked me have you heard of question.I said Yes.Then he asked me to code)2. Find vertical sum of nodes present in same vertical line in binary tree. ( He again asked me have you heard of question. I have heard it but didn’t remember the approach. It took some time and then I started telling my approach.He aasked me to write code and question regarding get sums from left to right , for which I made use of linked hashmap)
Overall It was very cool for me
Total Questions: 2
Round: Test
Experience: 1.Reverse K blocks of nodes in linked list.There are two interviewers this time, probably, guy was senior he was asking me question.He was very particular in coding. Checked every edge case.and asked me evrything.Initially I told the approach and then started coding.2.Find min in stack in O(1)Pretty straightforward written code.Again he checked all edge cases with my code.3. Then asked about counting sort and its code.4. And a simple question on array sorting.
Round: HR Interview
Experience: I thought this was last round as they have said like.She asked me about my strengths and challenges I faced.How I overcame through it1.Basic question on oops concepts.(runtime polymorphism).
2.Design tables for getting all employees under manager. I screwed it little bit.But some how I got answer which I was not satisfied as well.I was expecting result either yes/no.But they called me for another round of interview may be because of my expected salary which was high compared to my previous.
Round: Technical Interview
Experience: 1.Given “aaabbbccc” it should return “a3b3c3″ in place. Initially I explained brute force approach then he said array has 2n space.I was able to remember approach for quicksort and started explaining after which I grew confident on it.He was satisfied.Questions on time complexity of algo and space complexity discussions.2.Again a question on OOPs.This time I was completely wrong in answering it.I thought interview with yatra was closing for me.He was not satisified much with this.Luckily, there was another round with manager.
Round: Other Interview
Experience: 1.He asked me to find words which are having particular pattern.Then I said it was KMP algo. Can I explain it ?? I started explaining approach, may be he was busy with something, he asked me to write pseudo code.He left the room for 15 mins then he came back I had almost completed the code, which he was satisified.Some basic questions on spring ( my previous work was related to it). Then my expected salary and my position If I got selected in yatra were discussed.
College Name: NA
I applied via Other and was interviewed in Sep 2018. There were 3 interview rounds.
Interview Questionnaire
5 Questions
- Q1. As position was for UI developer. So first round was majorly based on HTML and CSS. They were checking the basic concepts.
- Q2. Questions from JavaScript. Major JavaScript concepts and logical questions.
- Q3. Main focus was on data structure, travel domain knowledge and optimisation techniques.
- Q4. Main purpose of this round was to check how updated a person is with new technologies, his willingness to learn new things and attitude towards work.
- Q5. General discussion and salary negotiation.
Interview Preparation Tips
Skills: GIT, Css, HTML, JavaScript, Communication
Duration: <1 week
Business Analyst Interview Questions & Answers
Fragomen Immigration Services
Anonymous
posted on 5 Oct 2022
I applied via Referral
It was quite easy, written test,some multiple choice questions
(2 Questions)
- Q1. Previous work history, introduction,about fragomen What is your Salary expectations? How you able to manage pressure? What is your commitment to our company?
- Q2. What is your salary expectations? What is your commitment to company?
Interview Preparation Tips
Business Analyst Interview Questions & Answers
Fragomen Immigration Services
Shilpa Paul
posted on 7 Nov 2024
Selected
I applied via Referral and was interviewed before Nov 2023. There were 2 interview rounds.
(1 Question)
- Q1. Excel assignment was given
(1 Question)
- Q1. Create a dashboard using Power Bi or Tableau.
- Ans.
Create a dashboard using Power Bi or Tableau
Gather relevant data sources for analysis
Identify key performance indicators (KPIs) to track
Design visually appealing and user-friendly dashboard
Utilize interactive features for data exploration
Include filters and slicers for customization
Consider audience needs and tailor dashboard accordingly
Skills evaluated in this interview
Senior Software Engineer Interview Questions & Answers
FCm Travel Solutions
Anonymous
posted on 18 Nov 2021
I applied via Recruitment Consultant and was interviewed before Nov 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Core java question with coding skill
Interview Preparation Tips
I applied via Instahyre and was interviewed in Sep 2022. There were 2 interview rounds.
(2 Questions)
- Q1. FInd the max triplets such that i
- Ans.
Find the max triplets such that i
Sort the array in ascending order
Iterate over the array and keep track of the maximum triplet
Return the maximum triplet
- Q2. Find the duplicate record in MySQL table
- Ans.
Finding duplicate records in MySQL table
Use GROUP BY and HAVING clause to group and filter duplicate records
SELECT statement with COUNT(*) function can be used to count the number of occurrences
UNIQUE constraint can be added to the table to prevent duplicates
Interview Preparation Tips
- Data Structures
- Database
Skills evaluated in this interview
(2 Questions)
- Q1. Basics about data and marketing
- Q2. Basics about tech and new ideas of growth
(1 Question)
- Q1. How you manager villa owner
- Ans.
I manage villa owners by fostering strong relationships, ensuring clear communication, and addressing their needs promptly.
Establish regular communication: Schedule weekly check-ins to discuss updates and concerns.
Set clear expectations: Outline responsibilities and deliverables at the start of the partnership.
Provide personalized service: Tailor solutions based on individual owner preferences, such as maintenance sche...
Interview Preparation Tips
Tek Travels Interview FAQs
Some of the top questions asked at the Tek Travels interview -
Tell us how to improve this page.
Interview Questions for Popular Designations
- Executive Interview Questions
- Team Lead Interview Questions
- Software Developer Interview Questions
- Consultant Interview Questions
- Associate Software Engineer Interview Questions
- Java Developer Interview Questions
- Senior Software Engineer Interview Questions
- Deputy Manager Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Interview Questions from Similar Companies
Tek Travels Reviews and Ratings
based on 54 reviews
Rating in categories
|
Software Engineer
34
salaries
|  ₹3.2 L/yr - ₹12.6 L/yr |
|
Application Support Engineer
20
salaries
| ₹3 L/yr - ₹6.2 L/yr |
|
Software Developer
17
salaries
| ₹4.8 L/yr - ₹10 L/yr |
|
CAR Driver
16
salaries
| ₹0.8 L/yr - ₹4.2 L/yr |
|
Driver
16
salaries
| ₹1.3 L/yr - ₹4.2 L/yr |
BCD Travel
Yatra
Riya Travel
CWT
- Home >
- Interviews >
- Tek Travels Interview Questions
