Paisabazaar.com Interview Questions, Process, and Tips

Q1. Write an SQL query to find the 2nd largest salary
Ans. 
SQL query to find the 2nd largest salary
• Use the ORDER BY clause to sort salaries in descending order

• Use the LIMIT clause to get the second row
Answered by AI
Add your answer
Q2. Write test cases of Login API
Ans. 
Test cases for Login API
• Verify valid credentials login successfully

• Verify invalid credentials show error message

• Verify login with empty username or password

• Verify login with special characters in username or password

• Verify login with long username or password
Answered by AI
Add your answer
Q3. In Jmeter, what is Rampup period
Ans. 
Rampup period in JMeter is the time taken for all virtual users to start executing the test plan.
• Rampup period is specified in seconds in JMeter test plan settings.

• During the rampup period, JMeter gradually starts all virtual users to avoid overwhelming the server.

• For example, if rampup period is set to 60 seconds and number of threads is 100, JMeter will start 1 thread every 0.6 seconds.
Answered by AI
Add your answer
Q4. Difference between cookie and cache
Ans. 
Cookies are small pieces of data stored on the client side, while cache is temporary storage of web documents on the server or client side.
• Cookies are used to store user-specific information like login credentials, preferences, etc.

• Cache is used to store frequently accessed web documents to reduce loading times.

• Cookies are sent with every HTTP request, while cache is used to store resources locally to reduce server loa...read more
Answered by AI
Add your answer
Q5. API vs Webservice
Ans. 
API is a general term for any set of rules that allow different software applications to communicate with each other. A web service is a type of API that is accessed over a network.
• API is a set of rules and protocols that allow different software applications to communicate with each other.

• Web service is a type of API that is accessed over a network, typically using HTTP.

• API can be used for various purposes like access...read more
Answered by AI
Add your answer
Q6. Write a program to find a prime number
Ans. 
Program to find a prime number
• Iterate through numbers starting from 2 up to the given number

• Check if the number is divisible by any number other than 1 and itself

• If not divisible, then it is a prime number
Answered by AI
Add your answer
Q7. Write a program to find the factorial
Ans. 
Program to find the factorial of a number
• Use a loop to multiply numbers from 1 to the given number

• Handle edge cases like 0 and negative numbers

• Example: For input 5, factorial is 5*4*3*2*1 = 120
Answered by AI
Add your answer

Q1. What is credit card .
Ans. 
A credit card is a payment card issued by a financial institution that allows the cardholder to borrow funds to pay for goods and services.
• Credit cards allow users to make purchases on credit, with the promise to repay the borrowed amount at a later date.

• They often come with a credit limit, which is the maximum amount the cardholder can borrow.

• Interest is charged on the outstanding balance if not paid in full by the du...read more
Answered by AI
Add your answer
Q2. Tell me about yourself and experience
Add your answer
Q3. What is Paisa bazaar.
Ans. 
PaisaBazaar is a financial marketplace in India that offers comparison and application services for loans, credit cards, and insurance.
• Provides comparison services for various financial products like loans, credit cards, and insurance

• Allows users to apply for financial products through their platform

• Offers personalized recommendations based on user's financial profile

• Helps users make informed decisions by providing det...read more
Answered by AI
Add your answer
Q4. What your previous company roll and how to manage your team.
Add your answer

Some basic Maths questions and Logical reasoning sets

Q1. About yourself, Skills and How you are seeing yourself in next 5 year
Add your answer

Q1. About yourself, bit friendly questioning and skills assessment question
Add your answer

Q1. Tell me about your self
Add your answer
Q2. What is experience of Mathematical Knowledge
Ans. 
I have a strong foundation in mathematical knowledge, including algebra, calculus, and statistics.
• I have completed coursework in advanced mathematics during my education.

• I have applied mathematical concepts in real-world scenarios, such as analyzing sales data and forecasting trends.

• I am proficient in using mathematical tools and software to solve complex problems.

• I have a keen eye for detail and accuracy when working
Answered by AI
Add your answer

Q1. How to Convince the customer
Ans. 
To convince the customer, focus on understanding their needs, building trust, providing solutions, and demonstrating value.
• Listen actively to the customer's needs and concerns

• Build trust by being honest, transparent, and reliable

• Provide tailored solutions that address the customer's specific needs

• Demonstrate the value of your product or service through examples and testimonials
Answered by AI
Add your answer
Q2. How to elaborate of loan policy to the Customer
Ans. 
Elaborate on loan policy by explaining terms, interest rates, eligibility criteria, and repayment options to the customer.
• Start by explaining the different types of loans available

• Discuss the interest rates and how they are calculated

• Explain the eligibility criteria including credit score, income requirements, and employment status

• Detail the repayment options such as monthly installments, interest-only payments, or bal...read more
Answered by AI
Add your answer