Groom Shoom Interview Questions and Answers

Authentication verifies the identity of a user, while authorization determines what actions a user is allowed to perform.

• Authentication confirms the user's identity through credentials like passwords or biometrics.

• Authorization controls access to resources based on the authenticated user's permissions.

• Example: Logging into a system with a username and password is authentication, while being able to view or edit specific files based on user roles is authorization.

There are four types of joins in SQL Server: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN: Returns rows when there is at least one match in both tables.

• LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table.

• FULL JOIN: Returns rows when there is a match in one of the tables.

OOPs components in C# are the building blocks of object-oriented programming, including classes, objects, inheritance, polymorphism, and encapsulation.

• Classes: Blueprint for creating objects with properties and methods.

• Objects: Instances of classes that hold data and behavior.

• Inheritance: Ability to create new classes based on existing ones, inheriting their properties and methods.

• Polymorphism: Ability to use a single interface to represent different data types or objects.

• Enc...read more

MVC stands for Model-View-Controller, a software design pattern for organizing code in a way that separates concerns.

• 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.

• Example: In a web application, the Model could be a database, the View could be the HTML/CSS for the user interface, and the Cont...read more

ref is used for passing a variable by reference, while out is used for passing a variable by reference and also requires the variable to be initialized before passing.

• ref keyword is used to pass a variable by reference, allowing the called method to modify the value of the variable.

• out keyword is similar to ref, but it requires the variable to be initialized before passing to the method.

• Example: int x = 10; Method(ref x); // x can be modified inside the method. Method(out x);...read more

Real time project implementation involves developing software that processes and responds to data in real time.

• Understand the requirements and constraints of the project

• Choose appropriate technologies for real-time processing (e.g. Kafka, Spark)

• Implement data pipelines for continuous data ingestion and processing

• Ensure scalability and fault tolerance of the system

• Test the system thoroughly to handle real-time data streams effectively