10+ Rohit & Company Interview Questions and Answers

State management is the process of maintaining the state of controls and variables across postbacks. Page life cycle is the sequence of events that occur during the processing of a page.

• ASP .Net provides various techniques for state management such as view state, session state, application state, and cookies.

• View state is used to maintain the state of controls between postbacks.

• Session state is used to maintain the state of variables across multiple requests from the same use...read more

It depends on the complexity of the authentication process and the technology stack used.

• I would need to understand the requirements and design of the login page.

• I would need to know the technology stack being used.

• If there are any existing authentication systems that can be integrated.

• If there are any security requirements that need to be considered.

• On average, it could take anywhere from a few hours to a few days to develop and test a login page.

Abstract class is a class that cannot be instantiated and Interface is a blueprint of a class. Static classes are used for utility functions.

• Abstract class is used to provide a common base for its subclasses.

• Interface is used to define a set of methods that a class must implement.

• Static classes are used for utility functions that do not require an instance of the class.

• Static classes cannot be instantiated and all members must be static.

Temporary table and table variable are used to store data temporarily in SQL.

• Temporary tables are created in tempdb and are automatically dropped when the session ends.

• Table variables are created in memory and have a limited scope.

• Temporary tables can be used to store large amounts of data and perform complex operations.

• Table variables are useful for storing small amounts of data and can improve performance.

• Both can be used in stored procedures, functions, and dynamic SQL.

Stored Procedure is a precompiled SQL code that can be reused and executed multiple times.

• Improves performance by reducing network traffic and server load

• Enhances security by allowing access to only specific procedures

• Simplifies maintenance and debugging

• Examples: sp_insert_employee, sp_update_customer_details

View state is a feature in ASP .NET that allows the state of a web page to be saved and restored between postbacks.

• View state is used to maintain the state of server-side controls between postbacks

• It is stored in a hidden field on the page

• View state can be disabled to improve performance

• View state can also be encrypted for security purposes

Overloading is having multiple methods with the same name but different parameters. Overriding is having a method in a subclass with the same name and parameters as in the superclass.

• Overloading is compile-time polymorphism while overriding is runtime polymorphism.

• Overloading is used to provide different ways of calling the same method while overriding is used to provide a specific implementation of a method in a subclass.

• Overloading is done in the same class while overriding...read more

Polymorphism is the ability of an object to take on many forms.

• It allows objects of different classes to be treated as if they were objects of the same class.

• It is achieved through method overriding and method overloading.

• Example: A parent class Animal can have child classes like Dog, Cat, and Bird, each with their own unique implementation of the method 'makeSound'.

• Polymorphism makes code more flexible and reusable.

Operator overloading is the ability to redefine operators for custom classes.

• Allows operators to be used with user-defined types

• Enables the use of familiar operators with custom classes

• Can improve code readability and reduce complexity

• Example: '+' operator can be overloaded to concatenate strings

Out is used to return multiple values from a method while ref is used to pass a reference of a variable to a method.

• Out parameters must be initialized inside the method before returning.

• Ref parameters can be initialized before passing to the method.

• Out parameters are used when a method needs to return multiple values.

• Ref parameters are used when a method needs to modify the value of a variable passed to it.

Answering questions related to joins, group by, responsive term in bootstrap, and inserting data using XML.

• Types of joins include inner join, left join, right join, and full outer join.

• Group by is used to group data based on a specific column in a table.

• Responsive term in bootstrap refers to the ability of a website to adjust its layout based on the screen size of the device.

• To insert data using XML, one can use the INSERT INTO statement with the OPENROWSET function.

Primary key uniquely identifies a record in a table, while unique key ensures that all values in a column are distinct.

• Primary key can't have null values, while unique key can have one null value.

• A table can have only one primary key, but multiple unique keys.

• Primary key is used as a foreign key in other tables, while unique key is not.

• Example: Employee ID can be a primary key, while email address can be a unique key.

Data loss in Salesforce can be caused by human error, system integrations, data migrations, and malicious activities.

• Human error such as accidental deletion or overwriting of data

• Issues with system integrations leading to data corruption or loss

• Data migrations that are not properly planned or executed

• Malicious activities like hacking or unauthorized access

Stored procedure is a precompiled SQL code that can be reused and executed multiple times.

• Stored procedures are used to improve performance and security of database operations.

• They can accept input parameters and return output parameters or result sets.

• Stored procedures can be called from within other SQL statements or from application code.

• Examples of stored procedures include inserting data into a table, updating records, and retrieving data based on certain criteria.

Roll up summary field is a field in Salesforce that calculates values from related records and displays the result on a master record.

• It is used to perform calculations on child records and display the result on a parent record.

• Commonly used for calculating totals, averages, counts, etc.

• Examples include summing up the total amount of all related opportunities on an account record.