Cleartrip Applications Engineer Interview Questions and Answers

Q1. Tell me about yourself.
Add your answer

Q1. Calculate no of rows after join
Ans. 
Calculate the number of rows after joining two datasets.
• Count the number of rows in each dataset

• Perform the join operation

• Count the number of rows in the resulting dataset
Answered by AI
Add your answer
Q2. Split person name in excel
Ans. 
Use Excel's text to columns feature to split person names into separate columns.
• Select the column containing the full names

• Go to the Data tab and click on Text to Columns

• Choose 'Delimited' and select the delimiter that separates the names (e.g. space)

• Click Finish to split the names into separate columns
Answered by AI
Add your answer

Duration - 1hr, Mostly questions are from Excel and SQL ( But a little knowledge of R and Python is very useful) .For me, it's knowing the concepts and answering no codes were ask to write.

Q1. Basic 1-on-1 round with your manager/ or any senior from the company
Add your answer

Round duration - 65 minutes
Round difficulty - Easy

There were 2 sections – 
Aptitude and Logical Reasoning and MCQ based on Java question ,C++, coding for 20 min and 45 min respectively.
Section A- Not very difficult to clear this round although less time was a problem.
Section B- It contains 15 multiple choice question on c/c++,java and 4 simple coding questions

Q1. 
Cycle Detection in a Singly Linked List
Determine if a given singly linked list of integers forms a cycle or not.
A cycle in a linked list occurs when a node's next points back to a previous node in the ...read more
Ans. 
Detect if a singly linked list forms a cycle by checking if a node's next pointer points back to a previous node.
• Traverse the linked list using two pointers, one moving at double the speed of the other.

• If the two pointers meet at any point, there is a cycle in the linked list.

• Use Floyd's Cycle Detection Algorithm for O(N) time complexity and O(1) space complexity.
Answered by AI
Add your answer

Round duration - 75 minutes
Round difficulty - Medium

It was an online coding test in which 3 coding question were given.

Q1. 
Smallest Window Problem Statement
Given two strings, S and X, your task is to find the smallest substring in S that contains all the characters present in X.
Example:
Input:
S = "abdd", X = "bd"
Outpu...read more
Ans. 
Find the smallest substring in string S that contains all characters in string X.
• Iterate through string S and keep track of characters in X found in a window

• Use two pointers to maintain the window and slide it to find the smallest window

• Return the smallest window containing all characters in X
Answered by AI
Add your answer
Q2. 
Smallest Integer Not Representable as Subset Sum
Given a non-decreasing sorted array ARR of N positive numbers, determine the smallest positive integer that cannot be expressed as the sum of elements from...read more
Ans. 
Find the smallest positive integer that cannot be expressed as the sum of elements from any proper subset of a non-decreasing sorted array of positive numbers.
• Start with the smallest possible integer that cannot be represented, which is 1.

• Iterate through the array and update the smallest integer that cannot be represented.

• If the current element is greater than the smallest integer that cannot be represented, return tha...read more
Answered by AI
Add your answer
Q3. 
Minimum Steps for a Knight to Reach Target
Given a square chessboard of size 'N x N', determine the minimum number of moves a Knight requires to reach a specified target position from its initial position...read more
Ans. 
Calculate the minimum number of moves a Knight needs to reach a target position on a chessboard.
• Implement a function that takes knight's starting position, target position, and chessboard size as input

• Use breadth-first search algorithm to find the shortest path for the Knight

• Consider all possible 8 movements of the Knight on the chessboard

• Return the minimum number of moves required for the Knight to reach the target po
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

It started with a discussion on the programs given in coding round. They asked me about my interest field after that they directly jumped into Networking, Linux and Ethical Hacking part looking my interest domain. They asked me various question on networking and linux.
Then they asked me to code a simple c program

Q1. 
Reverse Linked List Problem Statement
Given a singly linked list of integers, return the head of the reversed linked list.
Example:
Initial linked list: 1 -> 2 -> 3 -> 4 -> NULL
Reversed link...read more
Ans. 
Reverse a singly linked list of integers and return the head of the reversed linked list.
• Iterate through the linked list and reverse the pointers to point to the previous node.

• Keep track of the current, previous, and next nodes while reversing the linked list.

• Update the head of the reversed linked list as the last node encountered during reversal.
Answered by AI
Add your answer
Q2. What are the port numbers of protocols such as FTP and SMTP?
Ans. 
FTP uses port number 21 and SMTP uses port number 25.
• FTP uses port 21 for data transfer and port 20 for control information.

• SMTP uses port 25 for email communication.

• Understanding port numbers is important for network communication.
Answered by AI
Add your answer
Q3. Can you explain the OSI Model?
Ans. 
The OSI Model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven layers.
• The OSI Model stands for Open Systems Interconnection Model.

• It consists of seven layers: Physical, Data Link, Network, Transport, Session, Presentation, and Application.

• Each layer has specific functions and communicates with the adjacent layers.

• Example: Layer 1 (Physical) deals with physi...read more
Answered by AI
Add your answer
Q4. How do you copy files in Linux?
Ans. 
To copy files in Linux, you can use the 'cp' command.
• Use the 'cp' command followed by the source file and destination directory to copy a file.

• To copy a directory and its contents, use the '-r' flag with the 'cp' command.

• You can also use wildcards like '*' to copy multiple files at once.
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical round with 3 problems based on DSA and Algorithms.

Q1. 
Smallest Integer Not Representable as Subset Sum
Given a non-decreasing sorted array ARR of N positive numbers, determine the smallest positive integer that cannot be expressed as the sum of elements from...read more
Ans. 
Find the smallest positive integer that cannot be expressed as the sum of elements from any proper subset of a given array.
• Sort the array in non-decreasing order.

• Iterate through the array and keep track of the smallest sum that can be formed.

• If the next element in the array is greater than the current sum + 1, then the answer is the current sum + 1.

• Return the answer as the smallest integer not representable as a subset
Answered by AI
Add your answer
Q2. 
Reverse Linked List Problem Statement
Given a singly linked list of integers, return the head of the reversed linked list.
Example:
Initial linked list: 1 -> 2 -> 3 -> 4 -> NULL
Reversed link...read more
Ans. 
Reverse a singly linked list of integers and return the head of the reversed linked list.
• Iterate through the linked list and reverse the pointers to point to the previous node instead of the next node.

• Use three pointers to keep track of the current, previous, and next nodes while reversing the linked list.

• Update the head of the reversed linked list to be the last node encountered during the reversal process.
Answered by AI
Add your answer
Q3. 
Smallest Window Problem Statement
Given two strings S and X containing random characters, the task is to find the smallest substring in S which contains all the characters present in X.
Input:
The first...read more
Ans. 
The task is to find the smallest substring in string S which contains all the characters present in string X.
• Iterate through string S and keep track of characters in X using a hashmap

• Use two pointers to maintain a sliding window and find the smallest window containing all characters in X

• Return the smallest window found
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions based on OOPS and Angular.

Q1. What are the different OOP concepts?
Ans. 
OOP concepts include inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance allows a class to inherit properties and behavior from another class.

• Encapsulation restricts access to certain components of an object, protecting its integrity.

• Polymorphism allows objects to be treated as instances of their parent class.

• Abstraction hides the complex implementation details of an object and only shows the necessar
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Questions based on System Design, ajax, jquery were asked.

Q1. How would you design a traffic light system?
Ans. 
Designing a traffic light system involves creating a system that controls the flow of traffic at intersections.
• Divide the traffic light system into three main lights: red, yellow, and green.

• Implement timers to control the duration of each light.

• Include sensors to detect the presence of vehicles and pedestrians.

• Consider implementing a pedestrian crossing signal.

• Integrate a central control system to coordinate the timing
Answered by AI
Add your answer
Q2. How does AJAX work?
Ans. 
AJAX allows for asynchronous communication between client and server without needing to reload the entire page.
• AJAX stands for Asynchronous JavaScript and XML.

• It allows for sending and receiving data from a server without reloading the entire page.

• AJAX uses XMLHttpRequest object to make requests to the server.

• It can update parts of a web page without requiring a full page reload.

• Commonly used in web applications to pro
Answered by AI
Add your answer
Q3. What is the difference between AngularJS and jQuery?
Ans. 
AngularJS is a full-fledged MVC framework for building dynamic web applications, while jQuery is a lightweight library for DOM manipulation and event handling.
• AngularJS is a full-fledged MVC framework, providing features like two-way data binding, dependency injection, and routing.

• jQuery is a lightweight library primarily used for DOM manipulation and event handling.

• AngularJS is suitable for building single-page applic...read more
Answered by AI
Add your answer

Round duration - 75 minutes
Round difficulty - Easy

This was the online round held at university. All students who met the eligibility criteria were called for the online test on hackerrank.

Q1. 
Anagram Difference Problem Statement
Given two strings, 'STR1' and 'STR2', of equal lengths, determine the minimum number of manipulations required to make the two strings anagrams of each other.
Input:
...read more
Ans. 
The problem involves finding the minimum number of manipulations required to make two strings anagrams of each other.
• Create frequency maps for both strings

• Find the absolute difference in frequencies of each character

• Sum up the absolute differences to get the total manipulations needed
Answered by AI
Add your answer

Round duration - 90 Minutes
Round difficulty - Medium

This round was technical round and the interview started with formal introduction and general questions.
After that We had a discussion on LRU Cache.
Followed by coding and set of data structure questions.

Q1. 
Gas Tank Problem Statement
You have a car with a gas tank of infinite capacity. There are 'N' gas stations located along a circular route, numbered from 0 to N-1. You begin your journey with an empty tank...read more
Ans. 
Find the starting gas station index to complete a circular route with gas and cost arrays.
• Iterate through gas stations, keeping track of total gas and total cost from each station

• If total gas is greater than or equal to total cost, update the starting station index

• Return the starting station index if a valid one is found, else return -1
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

This Round was DS and Algo round and it started with formal introduction, followed by 2 problems. We first dicussed the approach the time complexity and proper code covering all cases.

Q1. 
Boundary Traversal of Binary Tree
Given a binary tree of integers, your task is to print the boundary nodes of this binary tree in an anti-clockwise direction starting from the root node.
Input:
The fir...read more
Ans. 
Print the boundary nodes of a binary tree in an anti-clockwise direction starting from the root node.
• Traverse the left boundary nodes from the root to the leftmost leaf node.

• Traverse the leaf nodes from left to right.

• Traverse the right boundary nodes from the rightmost leaf node to the root.
Answered by AI
Add your answer
Q2. 
Maximum Sum of Two Non-Overlapping Subarrays
Given an integer array ARR and a positive integer K, your objective is to find two non-overlapping subarrays (contiguous) of length K each, such that their sum...read more
Ans. 
Find two non-overlapping subarrays of length K with maximum sum in an integer array.
• Iterate through the array to find all possible subarrays of length K.

• Calculate the sum of each pair of non-overlapping subarrays of length K.

• Keep track of the maximum sum obtained from the pairs of subarrays.
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was the Final Interview and it started with formal introduction and general HR questions. Then We discussed about the projects and the things written in my resume. The interviewer was very frank and this round was very interactive. He asked me about my college, my future plans, teachers, various subjects, why Expedia and questions like that.