i
Accion Labs
Filter interviews by
MVC is a software design pattern that separates an application into three main components: Model, View, and Controller.
Model represents the data and business logic of the application.
View is responsible for displaying the data to the user.
Controller acts as an intermediary between Model and View, handling user input and updating the Model accordingly.
MVC helps in organizing code, improving maintainability, and promotin...
InnoDB is a transaction-safe storage engine for MySQL, while MyISAM is not transaction-safe.
InnoDB supports transactions with ACID properties, while MyISAM does not.
InnoDB supports foreign keys, while MyISAM does not.
InnoDB is more reliable and crash-safe compared to MyISAM.
InnoDB is the default storage engine for MySQL 5.5 and higher versions.
MyISAM is faster for read-heavy operations, while InnoDB is better for write
Interface defines only method signatures while abstract class can have both method signatures and implementations.
Interface cannot have method implementations, only method signatures.
Abstract class can have both method signatures and implementations.
A class can implement multiple interfaces but can only inherit from one abstract class.
Interfaces are used to define a contract for classes to implement, while abstract cla...
A static method is a method that belongs to the class itself, rather than to instances of the class.
Static methods can be called directly on the class without needing to create an instance of the class.
Static methods are commonly used for utility functions that do not require access to instance-specific data.
Static methods are declared using the 'static' keyword in PHP.
Optimizing SQL queries involves analyzing query performance, indexing, minimizing data retrieval, and using appropriate joins.
Analyze query performance using tools like EXPLAIN to identify bottlenecks
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid using SELECT * and instead specify required columns
Use appropriate joins like INNER JOIN, LEFT JOIN, e
array_map in PHP is used to apply a callback function to each element of an array.
array_map() returns an array containing all the elements of the input array after applying the callback function to each one.
It is useful for applying a function to all elements of an array without using a loop.
Example: array_map('strtoupper', ['apple', 'banana', 'cherry']) will return ['APPLE', 'BANANA', 'CHERRY'].
A callback function in PHP is a function that is passed as an argument to another function and is executed at a later time.
Callback functions are commonly used in PHP for event handling, asynchronous processing, and custom sorting.
Example: array_map() function in PHP takes a callback function as an argument to apply a user-defined function to each element of an array.
Another example: usort() function in PHP uses a call...
PHPUnit workflow involves writing test cases, running tests, and analyzing results.
Write test cases using PHPUnit framework
Run tests using PHPUnit command line interface or IDE integration
Analyze test results to identify failures and errors
Make necessary code changes to fix failing tests
Repeat the process until all tests pass successfully
I applied via Approached by Company and was interviewed in Nov 2024. There were 2 interview rounds.
Coding test is related to my tech skills only.
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 3 interview rounds.
I applied via LinkedIn and was interviewed in Nov 2024. There were 2 interview rounds.
I applied via Job Portal and was interviewed in Nov 2024. There were 2 interview rounds.
My approach to building basic logic skills involves practicing problem-solving exercises, breaking down complex problems into smaller parts, and seeking feedback to improve.
Practice problem-solving exercises regularly to strengthen logical thinking abilities.
Break down complex problems into smaller, more manageable parts to better understand the problem and find solutions.
Seek feedback from peers or mentors to identify...
Using a crypto price API to fetch and display real-time cryptocurrency prices in a machine coding project.
Utilize a crypto price API to fetch real-time cryptocurrency prices
Implement error handling for API requests
Display the fetched prices in a user-friendly format
A github repo was shared and had to code on top of it. No DSA
System design in tech involves creating scalable and efficient solutions to complex problems.
Understanding the requirements and constraints of the system
Breaking down the system into smaller components
Choosing the appropriate technologies and architecture
Considering scalability, reliability, and performance
Collaborating with stakeholders to ensure alignment
Solid principles are a set of design principles that help make software more maintainable, flexible, and scalable.
Single Responsibility Principle (SRP) - A class should have only one reason to change.
Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.
Liskov Substitution Principle (LSP) - Objects of a superclass should be replaceable with objects of its subclasses wi...
Code snippet for Entity Framework DB connection
Install Entity Framework NuGet package
Create a DbContext class
Define DbSet properties for each entity
Configure connection string in app.config/web.config
Use DbContext to interact with the database
To get the 3rd highest salary, we can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
Use a SQL query with 'ORDER BY salary DESC' to sort salaries in descending order.
Use 'LIMIT 1 OFFSET 2' to skip the first two highest salaries and get the 3rd highest salary.
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
Interfaces in C# provide a way to define a contract for classes to implement, promoting code reusability and flexibility.
Interfaces allow for multiple inheritance in C# by allowing a class to implement multiple interfaces.
Interfaces help in achieving loose coupling between classes, making the code more maintainable and testable.
Interfaces are used to define common behavior that multiple classes can share, promoting cod...
I applied via Approached by Company and was interviewed in Nov 2023. There were 4 interview rounds.
Hackerrank test with combination of MCQ and java program coding.
Senior Software Engineer
750
salaries
| ₹8.2 L/yr - ₹29.7 L/yr |
Principal Software Engineer
412
salaries
| ₹11 L/yr - ₹40 L/yr |
Software Engineer
301
salaries
| ₹4.1 L/yr - ₹17.5 L/yr |
Senior Principal Software Engineer
147
salaries
| ₹13.5 L/yr - ₹36.1 L/yr |
Technical Lead
143
salaries
| ₹13.2 L/yr - ₹40 L/yr |
TCS
Infosys
Wipro
HCLTech