Fingent Interview Questions and Answers

SQL join queries are used to combine rows from two or more tables based on a related column between them.

• Join queries are used to retrieve data from multiple tables in a single query.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Join conditions are specified using the ON keyword, which defines the column(s) to join on.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column...read more

The ref and out keywords are used in C# to pass arguments by reference instead of by value.

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

• The out keyword is similar to ref, but it is used when the called method needs to assign a value to the variable being passed.

• The ref keyword requires the variable to be initialized before passing it to the...read more

Overloading is having multiple methods with the same name but different parameters. Overriding is implementing a method in a derived class with the same name and signature as in the base class.

• Overloading allows a class to have multiple methods with the same name but different parameters.

• Overriding allows a derived class to provide a different implementation of a method that is already defined in the base class.

• Ov...read more

ADO .NET database calling steps involve establishing a connection, creating a command object, executing the command, and handling the results.

• Establish a connection to the database using a connection string

• Create a command object to specify the SQL query or stored procedure to be executed

• Execute the command to retrieve or modify data in the database

• Handle the results by reading data from a DataReader or updating d...read more

IEnumerable is read-only and forward-only while IQueryable is queryable and can be used with LINQ to SQL.

• IEnumerable is used for in-memory collections while IQueryable is used for querying external data sources.

• IQueryable allows for deferred execution while IEnumerable does not.

• IQueryable can be used with LINQ to SQL to translate queries into SQL statements.

• IEnumerable is simpler and more lightweight than IQueryab...read more

useEffect is a hook in React that allows you to perform side effects in functional components.

• useEffect is used to manage component lifecycle in functional components.

• It takes two arguments: a function that performs the side effect and an array of dependencies.

• The function passed to useEffect is called after every render.

• The array of dependencies is used to determine when the effect should be re-run.

• If the array i...read more