MAYBRIGHT VENTURES PRIVATE LIMITED, Kolkata Interview Questions and Answers

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...read more

Creating an index in MySQL improves query performance by allowing faster data retrieval.

• Use the CREATE INDEX statement to create an index. Example: CREATE INDEX idx_name ON table_name(column_name);

• Indexes can be unique, ensuring no duplicate values. Example: CREATE UNIQUE INDEX idx_unique ON table_name(column_name);

• Composite indexes can be created on multiple columns. Example: CREATE INDEX idx_composite ON table_name(c...read more

Polymorphism in interfaces allows objects to be treated as instances of their parent type, enhancing flexibility and code reusability.

• Polymorphism enables methods to do different things based on the object it is acting upon.

• Example: An interface 'Animal' with a method 'makeSound()'. Classes 'Dog' and 'Cat' implement this interface with different sounds.

• It promotes code reusability and cleaner code by allowing the same ...read more

I recently watched 'Everything Everywhere All at Once,' a mind-bending film that explores multiverses and the power of choices.

• The film blends action, comedy, and drama, showcasing a unique storytelling style.

• It features a strong performance by Michelle Yeoh, who plays a laundromat owner navigating alternate realities.

• The visual effects are stunning, with creative representations of different universes.

• Themes of family...read more

To fill an 18L tub using a 1L jar, it will take 18 times to fill it completely.

• You can fill the 1L jar and pour it into the tub repeatedly.

• After filling the tub 18 times, it will be completely filled.

• This is a straightforward calculation: 18L / 1L = 18.

Our company is a leading provider of innovative solutions in the operations sector, focusing on efficiency and customer satisfaction.

• Founded in [Year], we have grown to serve clients across multiple industries.

• We prioritize sustainability, implementing eco-friendly practices in our operations.

• Our team consists of experts with diverse backgrounds, ensuring a well-rounded approach to problem-solving.

• We utilize cutting-ed...read more