Club Oxygen Digital Marketing Executive Interview Questions and Answers

Round duration - 90 minutes
Round difficulty - Medium

Coding question of medium level difficulty, from DP. 
18 MCQs were core CSE related concepts e.g: OS, OOPs, DBMS, Networking
Time was 90 minutes.

Q1. 
Minimum Cost to Destination
You are given an NxM matrix consisting of '0's and '1's. A '1' signifies that the cell is accessible, whereas a '0' indicates that the cell is blocked. Your task is to compute ...read more
Ans. 
Find the minimum cost to reach a destination in a matrix with blocked cells.
• Use Breadth First Search (BFS) algorithm to explore all possible paths from the starting point to the destination.

• Keep track of the cost incurred at each cell and update it as you move through the matrix.

• Return the minimum cost to reach the destination or -1 if it is unreachable.
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

It was an one-to-one interview. It checks your problem solving ability and a few OOPs, OS, DBMS etc concepts. Coding questions were related to array, queue and DP.

Q1. 
Triangle Formation Using Array Elements
Given an integer array/list ARR of length 'N', determine if it is possible to form at least one non-degenerate triangle using the values of the array as the sides o...read more
Ans. 
Determine if it is possible to form a non-degenerate triangle using array elements as sides.
• Check if the sum of any two sides is greater than the third side for all combinations of sides.

• If the above condition is met for any combination, return true; otherwise, return false.
Answered by AI
Add your answer
Q2. 
Maximum Sum of Non-Adjacent Elements
You are given an array/list of integers. The task is to return the maximum sum of a subsequence such that no two elements in the subsequence are adjacent in the given ...read more
Ans. 
Find the maximum sum of non-adjacent elements in an array.
• Use dynamic programming to keep track of the maximum sum at each index, considering whether to include the current element or not.

• At each index, the maximum sum can be either the sum excluding the current element or the sum including the current element but excluding the previous element.

• Iterate through the array and update the maximum sum accordingly.

• Example: F...read more
Answered by AI
Add your answer

Round duration - 45 minutes
Round difficulty - Easy

It was also a problem solving round. However after coding questions, they also asked CSE conceptual questions.

Q1. 
Sum Tree Conversion
Convert a given binary tree into its sum tree. In a sum tree, every node's value is replaced with the sum of its immediate children's values. Leaf nodes are set to 0. Finally, return th...read more
Ans. 
Convert a binary tree into a sum tree by replacing each node's value with the sum of its children's values. Return preorder traversal.
• Traverse the tree in a bottom-up manner, starting from the leaf nodes.

• For each node, update its value to the sum of its children's values.

• Set leaf nodes to 0.

• Return the preorder traversal of the modified tree.
Answered by AI
Add your answer
Q2. What are the core concepts of indexing in Database Management Systems (DBMS)?
Ans. 
Core concepts of indexing in DBMS include types of indexes, benefits of indexing, and factors affecting index performance.
• Types of indexes: B-tree, Hash, Bitmap, etc.

• Benefits of indexing: Faster data retrieval, improved query performance, reduced disk I/O.

• Factors affecting index performance: Selectivity, clustering factor, index fragmentation.

• Examples: Creating an index on a column in a table to speed up search queries
Answered by AI
Add your answer

Q1. Difference between STR and Trip advisor rating
Ans. 
STR and Tripadvisor ratings are both used to evaluate the performance of hotels, but they differ in terms of data sources and methodology.
• STR (Smith Travel Research) rating is based on data collected from participating hotels, providing insights into key performance metrics such as occupancy rate, average daily rate, and revenue per available room.

• Tripadvisor rating, on the other hand, is based on guest reviews and rat...read more
Answered by AI
View 1 more answer
Q2. What is crypto currency
Ans. 
Crypto currency is a digital or virtual currency that uses cryptography for security and operates independently of a central bank.
• Crypto currency is decentralized and operates on a peer-to-peer network

• Transactions are recorded on a public ledger called a blockchain

• Crypto currency can be bought and sold on exchanges

• Examples of crypto currencies include Bitcoin, Ethereum, and Litecoin
Answered by AI
Add your answer
Q3. It is a virtual currency not governed by any bank. It should be regulated in order to avoid any scan and misleads
Add your answer

Q1. What did you learn in your internship
View 3 more answers
Q2. What's happening in the world , India or whats in the news
Add your answer
Q3. Share a situation when you handled guest
Add your answer
Q4. Tell us about the hotel where you trained
Add your answer
Q5. What do you know about the Oberoi
Add your answer

Q1. Technical Questions department specific
Add your answer

Coding Rond consisted of 3 questions

Q1. 1. Data structures and algorithms
Add your answer
Q2. 2. Computer fundamentals
Add your answer
Q3. Revise all cs fundamentals
Add your answer

3 data structure problem with medium to hard level leetcode type.

Q1. 1st question was on vertical order traversal in a tree. it was from gfg he also told me to optimise it
Add your answer
Q2. 2nd question was from leetcode ie meeting rooms ll , medium question
Add your answer