Marketsmojo Interview Questions and Answers

Q1. You previous experiences
Add your answer
Q2. About the company
Add your answer
Q3. Why looking for a change
Add your answer

Q1. Previous experience
Add your answer
Q2. How you relate to tripfactory
Ans. 
I have experience working with tripfactory in my previous role as a Process Manager.
• I have successfully managed projects involving tripfactory's services

• I am familiar with tripfactory's processes and procedures

• I have collaborated with tripfactory team members to achieve project goals
Answered by AI
Add your answer
Q3. Short case study question
Add your answer

Q1. How Indexing works in DB
Ans. 
Indexing in DB is a technique to improve the speed of data retrieval by creating a data structure that allows for quick lookup of data.
• Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.

• Types of indexes include B-tree, hash, and bitmap indexes.

• Indexes can be unique or non-unique, clustered or non-clustered.

• Example: Creating an index on the 'email' column ...read more
Answered by AI
Add your answer
Q2. Spring Boot depenencies
Add your answer

Q1. System Design of Bookmyshow
Ans. 
Bookmyshow is a popular online ticketing platform for movies, events, and other entertainment.
• Bookmyshow allows users to browse and book tickets for movies, events, plays, sports, etc.

• The system should have features like seat selection, payment gateway integration, booking history, and notifications.

• Scalability is important to handle high traffic during popular movie releases or events.

• Integration with cinema partners ...read more
Answered by AI
Add your answer
Q2. Some SQL queries to write
Add your answer

Round 1 : Received Assessment with dataset and questions, within xlsx file format. question were on countifs, sumifs, conditional formatting, reports and dashboard, pivot chart.

Round 2: This round was on meet again dataset was provided and within 30 min i have to complete given task. and submit.

Q1. Round 3: Final Round with HR and Manager, Tasks were provided in google sheets, questions were like perform countifs, sumifs, vlookup, Nested IF, importrange, query, Pivot table, pivot chart.
Add your answer

Q1. General Question Tell me about yourself
Add your answer
Q2. How soon you can join
Add your answer

Read about MPIN that is used to access mobile banking apps

Many a times users end up setting an MPIN that is guessable because

1. It is a commonly used MPIN eg 1122

2. It is a combination of easily known demographics of the user. Eg: if the birthdate is 02- Jan-1998 then MPIN could be 0201 or 9802 or 0201 etc. Demographics such as these could be used alone or in a combination

a. DOB

b. Wedding Anniversary

c. Spouse birthday

Solutions Required

1. Part A: Assume that the MPIN is 4-digits. Write a program that suggests if the MPIN is a commonly used one. Ignore the demographics for this part

2. Part B: Enhance the above to take user's demographics as input and provides an output

a. Strength: WEAK or STRONG

3. Part C: Enhance the above to provide the following outputs

a. Strength: WEAK or STRONG

b. If weak then the reason why was it considered weak: It should give from the following the reasons as an array. Array should be empty if Strength is STRONG and non-empty if WEAK

i. COMMONLY_USED

ii. DEMOGRAPHIC_DOB_SELF

iii. DEMOGRAPHIC_DOB_SPOUSE

iv. DEMOGRAPHIC_ANNIVERSARY

4. Part E: Above with a 6-digit PIN

5. Write code that tests the above written code using a set of inputs. Write at least 20 test case in PYTHON

Q1. Medium leetcode
Add your answer

Q1. Regarding experience
Add your answer

Q1. General behavioural question
Add your answer

Q1. They will ask DSA
Add your answer
Q2. Their most work is about devops
Add your answer

MCQ questions, can be easily done.

A website testing. To find the bugs in the website and list them down.

Q1. Asked questions related to types of testing, some situation based questions and if you are applying for automation, then there were coding questions- easy level.
Add your answer

Q1. Lithium ion manufacturing process and what are the difficulties faced in your current role
Ans. 
The lithium ion manufacturing process involves mixing raw materials, coating electrodes, assembling cells, and testing for quality.
• Raw materials such as lithium, cobalt, and nickel are mixed together to create the cathode and anode materials.

• The electrodes are coated with a thin layer of active material to improve performance.

• Cells are assembled by stacking electrodes and separators, then sealing them in a casing.

• Quali...read more
Answered by AI
Add your answer