Your Space Interview Questions and Answers

5 SQL questions within 1 hour

Q1. Discuss more on my past experience and sql joins and basic questions
Add your answer
Q2. NA
Add your answer

Build a system to efficiently process image data from CSV.

Q1. Explain the assignment which you have submitted.
Add your answer
Q2. Given an integer array. Tell me it is palindrome or not. If not can we make it by removing only one element.
Add your answer

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

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. Question is related to Java, SingleTon, and sorting array and calculate the occurance of the item in array.
Add your answer