10+ Makcur Laboratories Interview Questions and Answers

MySQL query to find 2 highest salaries and explanation of abstract and interfaces

• Use ORDER BY and LIMIT to get the top 2 salaries

• Abstract classes cannot be instantiated and can have both abstract and non-abstract methods

• Interfaces define a set of methods that a class must implement

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 2

• Example: abstract class Animal { abstract void makeSound(); }

• Example: interface Vehicle { void start(); void stop(); }

LLD Design for Movie Ticket Booking System(BookMyShow.com)

• Use case diagram to identify actors and their interactions

• Class diagram to represent entities like User, Movie, Theater, Booking

• Sequence diagram to show the flow of events during ticket booking process

OOPs is Object-Oriented Programming, polymorphism allows objects to be treated as instances of their parent class, abstract class cannot be instantiated.

• OOPs is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.

• Polymorphism allows objects to be treated as instances of their parent class, enabling different classes to be treated as instances of a common superclass.

• Abstract class is a class th...read more

To reduce bundle size of an Angular application, you can use lazy loading, tree shaking, code splitting, and optimizing assets.

• Use lazy loading to load modules only when needed

• Implement tree shaking to remove unused code

• Utilize code splitting to divide code into smaller chunks

• Optimize assets by compressing images and minifying CSS/JS files

Optimisation techniques for software engineering

• Use efficient algorithms and data structures

• Minimize I/O operations and network calls

• Optimize database queries

• Use caching and memoization

• Parallelize computations

• Profile and analyze code for bottlenecks

• Eliminate unnecessary code and dependencies

Design patterns are reusable solutions to common software problems.

• Design patterns provide a common language for developers to communicate solutions.

• They help improve code quality, maintainability, and scalability.

• Examples include Singleton, Factory, Observer, and Decorator patterns.

Pure pipes do not have any side effects and always return the same output for the same input, while impure pipes can have side effects and may not return the same output for the same input.

• Pure pipes are stateless and deterministic.

• Impure pipes can have side effects like modifying global variables or making network requests.

• Examples of pure pipes include filters in Angular, while examples of impure pipes include async pipes in Angular.

Iterate through the table to find the second largest value.

• Iterate through the table and keep track of the largest and second largest values.

• Compare each value with the current largest and second largest values.

• Update the second largest value if a new value is found that is greater than the current second largest value.

Remove duplicates from list of strings

• Create a Set to store unique strings

• Iterate through the array and add each string to the Set

• Convert the Set back to an array to get the list of unique strings