20+ Big Bazaar Interview Questions and Answers

Interfaces define a contract for behavior, while abstract classes provide partial implementation.

• Interfaces only define method signatures, while abstract classes can have both abstract and concrete methods.

• A class can implement multiple interfaces, but can only inherit from one abstract class.

• Interfaces are used for loose coupling and flexibility in design.

• Abstract classes are used for code reuse and to enforce a common implementation among subclasses.

Stored procedures are used to perform a set of actions, while functions return a single value.

• Stored procedures are precompiled and stored in the database, while functions are compiled at runtime.

• Functions can be used in SQL statements, while stored procedures cannot be used in SQL statements.

• Functions can be called from within stored procedures, but stored procedures cannot be called from within functions.

Virtual keyword is used to declare a method in a base class that can be overridden in a derived class. Override keyword is used in the derived class to override the implementation of the virtual method.

• Virtual keyword is used in the base class to declare a method that can be overridden in the derived class

• Override keyword is used in the derived class to override the implementation of the virtual method

• Virtual methods provide a way for a base class to define a default implemen...read more

SOLID principles are a set of five design principles for writing maintainable and scalable code.

• Single Responsibility Principle (SRP) - a class should have only one reason to change

• Open-Closed Principle (OCP) - a class should be open for extension but closed for modification

• Liskov Substitution Principle (LSP) - subtypes should be substitutable for their base types

• Interface Segregation Principle (ISP) - clients should not be forced to depend on interfaces they do not use

• Depend...read more

Program to find the second largest element from a 4-digit number

• Convert the number to a string and split it into an array of characters

• Sort the array in descending order

• Return the second element of the array

Singleton design pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.

• Used when only one instance of a class is required throughout the system

• Provides a global point of access to the instance

• Implemented using a private constructor, static method, and static variable

• Example: Logger class, Database connection class

No, C# does not support multiple inheritance.

• C# only supports single inheritance, where a class can inherit from only one base class.

• However, C# does support multiple interface inheritance, where a class can implement multiple interfaces.

• This is achieved using the 'interface' keyword instead of 'class'.

Routing in MVC is done through the use of routes, which map URLs to controller actions.

• Routes are defined in the RouteConfig.cs file in the App_Start folder

• Routes consist of a URL pattern and a corresponding controller action

• Routes can also include optional parameters and constraints

• Routing is done through the use of the ASP.NET routing engine

• Routing can be customized by creating custom route handlers

Singleton design pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.

• Used when only one instance of a class is required throughout the system

• Provides a global point of access to the instance

• Implemented using a private constructor, static method, and static variable

• Example: Logger class in Java

Extension methods are static methods that allow adding new functionality to existing types without modifying the original type.

• Extension methods are defined in a static class.

• They must be declared with the 'this' keyword before the first parameter.

• They can be called as if they were instance methods of the extended type.

• Extension methods can be used to add functionality to built-in types or custom types.

• Example: adding a method to the string type to convert a string to title c...read more

Filters in MVC are used to intercept and modify HTTP requests and responses.

• Filters can be used to implement authentication and authorization.

• They can also be used for caching and logging.

• Examples of filters include AuthorizationFilter, ActionFilter, and ExceptionFilter.

Indexes in SQL are used to improve the performance of queries by allowing faster data retrieval.

• Indexes are created on one or more columns of a table.

• They work like a book index, allowing the database to quickly find the data.

• Indexes can be clustered or non-clustered.

• Clustered indexes determine the physical order of data in a table.

• Non-clustered indexes create a separate structure to store the index data.

• Indexes should be used carefully as they can slow down data modification...read more

Dependency injection is a design pattern used to remove hard-coded dependencies and make code more modular and testable.

• Dependency injection involves injecting dependencies into a class rather than having the class create them itself.

• This allows for easier testing and swapping out of dependencies.

• There are three types of dependency injection: constructor injection, setter injection, and interface injection.

• Examples of dependency injection frameworks include Spring and Guice.

Dependency injection is a design pattern that allows objects to receive dependencies from external sources rather than creating them internally.

• Dependency injection helps to decouple components and make them more reusable and testable.

• There are three types of dependency injection: constructor injection, setter injection, and interface injection.

• Example: Instead of creating a database connection object inside a class, we can inject it from outside.

• Dependency injection framewor...read more

The question covers various testing types, techniques, elements, window handling, frameworks, Cucumber options, hooks, and string manipulation using Java.

• Testing types include functional testing, regression testing, performance testing, etc.

• Testing techniques can involve manual testing, automated testing, black box testing, white box testing, etc.

• Find element is used to locate a single element on a web page, while find elements is used to locate multiple elements.

• Window handl...read more

Professional growth is the continuous development of skills, knowledge, and experience to enhance one's career prospects.

• Acquiring new skills and knowledge through training and education

• Taking on challenging projects and responsibilities

• Networking and building relationships with industry professionals

• Seeking feedback and constructive criticism to improve performance

• Staying up-to-date with industry trends and advancements

• Setting career goals and creating a plan to achieve them

Program to calculate diagonal and anti-diagonal sum of a matrix.

• Iterate through the matrix to calculate diagonal and anti-diagonal sums separately.

• For diagonal sum, add elements where row index equals column index.

• For anti-diagonal sum, add elements where row index + column index equals matrix size - 1.

• Example: For a 3x3 matrix, diagonal sum = matrix[0][0] + matrix[1][1] + matrix[2][2]

• Example: For a 3x3 matrix, anti-diagonal sum = matrix[0][2] + matrix[1][1] + matrix[2][0]

Program in C# demonstrating OOPs concepts

• Use classes and objects to demonstrate encapsulation

• Inheritance can be shown by creating a base class and derived classes

• Polymorphism can be illustrated through method overriding or interfaces

• Abstraction can be implemented by hiding internal details and showing only necessary information

Reverse items in array with highest values, skipping the lowest

• Sort the array in descending order

• Skip the lowest value(s)

• Reverse the remaining items

NCR Corporation is a global technology company that provides products and services that enable businesses to connect, interact, and transact with their customers.

• NCR Corporation is headquartered in Atlanta, Georgia.

• It was founded in 1884 as the National Cash Register Company.

• NCR provides software, hardware, and services for industries such as retail, financial services, hospitality, and telecommunications.

• The company is known for its self-service kiosks and ATMs.

• NCR has a pre...read more

TDD is Test Driven Development and BDD is Behavior Driven Development.

• TDD is a software development process where tests are written before the code.

• BDD is a software development process where tests are written in a natural language that describes the behavior of the system.

• TDD focuses on testing the functionality of individual units of code.

• BDD focuses on testing the behavior of the system as a whole.

• TDD is often associated with unit testing, while BDD is often associated wit...read more

Mobile phone usage can have both positive and negative impacts on children depending on how it is used.

• Excessive mobile phone usage can lead to addiction, sleep deprivation, and social isolation.

• However, mobile phones can also be used for educational purposes, staying connected with family and friends, and for emergency situations.

• It is important for parents to monitor their children's mobile phone usage and set limits to ensure a healthy balance.

• Overall, the impact of mobile...read more

Java interface defines a contract for classes to implement, while abstract class provides common functionality for subclasses.

• Interface can only have abstract methods, while abstract class can have both abstract and non-abstract methods.

• A class can implement multiple interfaces but can only extend one abstract class.

• Interfaces are used to achieve multiple inheritance in Java, while abstract classes are used to provide a common base for subclasses.

• Interfaces are implicitly abs...read more

Tata Nano project has both positive and negative impacts.

• Boon: Affordable car for middle-class families

• Curse: Poor safety features and negative perception

• Boon: Boosted Indian automobile industry

• Curse: Failed to meet sales expectations

• Boon or curse depends on perspective and context

Tackling complex situations requires breaking down the problem, seeking input from team members, prioritizing tasks, and staying calm under pressure.

• Break down the problem into smaller, manageable tasks

• Seek input and feedback from team members to gain different perspectives

• Prioritize tasks based on urgency and impact

• Stay calm under pressure and focus on finding solutions

Logistics involves the management of the flow of goods, information, and resources from the point of origin to the point of consumption.

• Logistics includes transportation, warehousing, inventory management, and distribution.

• It aims to ensure the timely delivery of products to customers while minimizing costs.

• Examples of logistics activities include route planning, order processing, and supply chain optimization.

MVVM is a design pattern used in Android development to separate the UI logic from the business logic.

• MVVM stands for Model-View-ViewModel

• Model represents the data and business logic

• View is the UI component that displays the data

• ViewModel acts as a mediator between the Model and View, handling the UI logic and data manipulation

• MVVM helps in maintaining a clean and organized codebase

NCR Corporation is a global technology company that provides products and services that enable businesses to connect, interact, and transact with their customers.

• NCR was founded in 1884 and is headquartered in Atlanta, Georgia.

• The company specializes in omni-channel solutions, ATM machines, point-of-sale systems, self-service kiosks, and more.

• NCR serves industries such as retail, hospitality, financial services, and telecommunications.

• NCR has a presence in over 180 countries ...read more