Sepio Products Interview Questions and Answers

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

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 level SQL question
Add your answer
Q2. Case study on Bigbasket/Instagram
Add your answer

Q1. Past experience
Add your answer
Q2. Numbers and profit
Add your answer

Q1. Question is related to Java, SingleTon, and sorting array and calculate the occurance of the item in array.
Add your answer

Q1. Brief explanation of the KRAs.
Ans. 
KRAs are Key Result Areas that define the main responsibilities and goals of a Zonal Sales Manager.
• KRAs are specific areas of focus that contribute to the overall success of the sales team.

• They help in setting clear expectations and measuring performance.

• Examples of KRAs for a Zonal Sales Manager may include achieving sales targets, expanding market share, building and managing a high-performing sales team, and develop...read more
Answered by AI
Add your answer
Q2. Unique / noticeable achievement
Add your answer

Q1. Nice formation edhi kisana andhanavathaga vunnthi dhine nammakuna kisanalu enthoo labhalu vuunaru
Add your answer
Q2. Edhi chala adhathavathachesa work
Add your answer

Kisana namakathara vunntadhi e company marapuvu dha vundhi

Ekkda eppuduya samaravathNaga cheayata dhini yukk work

Fert lezers individually insticide purchase

Work to work any otheiosoon from Village

Come to come work basically worthfully ga vunntdhi