Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2021. There were 3 interview rounds.
Create a Rest API for coding assessment
Choose a programming language and framework
Define endpoints and HTTP methods
Implement CRUD operations
Use authentication and authorization
Test API using tools like Postman
Pagination can be achieved by limiting the number of records displayed per page and using page numbers.
Limit the number of records displayed per page to improve performance
Use page numbers to navigate through the records
Implement caching to reduce database queries
Consider using lazy loading to improve performance
Use a server-side framework that supports pagination
Consider using a search feature to filter records
HAVING is used to filter results after grouping, WHERE is used to filter results before grouping.
HAVING is used with GROUP BY clause, WHERE is used with SELECT clause
HAVING filters groups based on aggregate functions, WHERE filters rows based on column values
HAVING is slower than WHERE as it operates on grouped data
Example: SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 5;
Example: SELE
I applied via Recruitment Consulltant and was interviewed in Apr 2022. There were 3 interview rounds.
The founder of mpokket is Gaurav Jalan.
Gaurav Jalan founded mpokket in 2016.
mpokket is a digital lending platform that provides instant loans to college students and young professionals.
The company has raised funding from various investors including Sequoia Capital and RTP Global.
I applied via Recruitment Consultant and was interviewed in Jul 2021. There were 3 interview rounds.
English grammar, math
MAYBRIGHT VENTURES PRIVATE LIMITED, Kolkata interview questions for popular designations
I applied via Recruitment Consulltant and was interviewed before Feb 2022. There were 2 interview rounds.
My school life was a mix of academic challenges, extracurricular activities, and lifelong friendships.
I excelled in subjects like mathematics and science, often participating in competitions and winning prizes.
I was actively involved in various clubs and societies, such as the debate club and the school choir.
I formed strong bonds with my classmates and teachers, creating a supportive and enjoyable learning environment...
I have 3 years of experience in customer service roles.
Worked as a Customer Service Representative at XYZ Company for 2 years
Handled customer inquiries, complaints, and provided solutions
Received positive feedback from customers for excellent service
Trained new team members on customer service best practices
Implemented a new customer feedback system to improve service quality
The last movie I watched was 'The Shawshank Redemption'.
The movie is based on a Stephen King novella and is set in a prison.
It tells the story of Andy Dufresne, a banker who is wrongly convicted of murder and sentenced to life in Shawshank State Penitentiary.
Andy forms a friendship with Red, an inmate who helps him navigate prison life.
Throughout the movie, Andy works towards his ultimate goal of escaping from Shawshan...
I applied via Naukri.com and was interviewed in Mar 2021. There were 4 interview rounds.
I applied via Naukri.com and was interviewed before Dec 2020. There were 3 interview rounds.
I applied via Walk-in and was interviewed in Jul 2020. There was 1 interview round.
I would exhaust all possible resources and strategies to meet the target.
I would analyze the reasons for not meeting the target and identify areas for improvement.
I would consult with colleagues and superiors for advice and guidance.
I would explore alternative approaches and solutions.
I would work longer hours and put in extra effort to achieve the target.
I would remain focused and determined to succeed.
I applied via Referral and was interviewed in Dec 2019. There was 1 interview round.
Top trending discussions
I applied via Approached by Company and was interviewed in Oct 2024. There were 4 interview rounds.
Codility Test General C# and SQL
Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.
Create a class Employees with fields FirstName, LastName, DoB, and Gender
Calculate the average age of all employees
Calculate the average age by genders
I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Factory pattern creates objects without specifying the exact class of object that will be created.
Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and up...
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate joins and subqueries
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
Clustered index: Physically reorders the data in the table based on the index key.
Non-clustered index: Contains a sorted list of references to the table data rows.
Unique index: Ensures that no two rows have the same values in the indexed columns.
Composite index: Index that is created on multiple columns.
Filtered index: Index that...
Yes, I have read SQL Execution Plans to optimize query performance.
I have analyzed SQL Execution Plans to identify bottlenecks in queries.
I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.
I have made query optimization recommendations based on SQL Execution Plans.
I have experience with tools like SQL Server Management Studio to view and analyze Execu
based on 109 reviews
Rating in categories
Operations Executive
189
salaries
| ₹1 L/yr - ₹3 L/yr |
Quality Analyst
19
salaries
| ₹1.8 L/yr - ₹3.8 L/yr |
Senior Software Engineer
13
salaries
| ₹7 L/yr - ₹19.2 L/yr |
Team Lead
12
salaries
| ₹2 L/yr - ₹3.4 L/yr |
Assistant Manager
8
salaries
| ₹3.2 L/yr - ₹6 L/yr |
Reliance Industries
TCS
Hindustan Unilever
Infosys