GlowTouch Technologies Interview Questions and Answers

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

• Types of joins include 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 tabl...read more

Use SQL query with ORDER BY and LIMIT to find second highest salary from employee table.

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 1,1 to get the second highest salary

• Example: SELECT salary FROM employee ORDER BY salary DESC LIMIT 1,1

Handle runtime exceptions by using try-catch blocks and logging the exception details.

• Use try-catch blocks to catch exceptions at runtime.

• Handle specific exceptions separately for better error handling.

• Log the exception details for debugging purposes.

• Use finally block to clean up resources after exception handling.

You can give a null value to an int variable by using nullable types in C#.

• Use nullable types like int? to declare an int variable that can hold null values.

• Initialize the int variable with null by assigning 'null' to it.

• Example: int? nullableInt = null;

DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.

• DDL is used to create, modify, and delete database objects such as tables, indexes, and views.

• DML is used to insert, update, delete, and retrieve data from database tables.

• Examples of DDL statements include CREATE TABLE, ALTER TABLE, and DROP TABLE.

• Examples of DML statements include INSERT...read more

Delegate in C# is a type that represents references to methods with a specific parameter list and return type.

• Delegates allow methods to be passed as parameters.

• Delegates can be used to define callback methods.

• Delegates can be used to implement events and event handling in C#.

• Delegates are type-safe function pointers.

Work process refers to the series of steps or tasks that need to be completed in order to achieve a specific goal or outcome.

• Work process involves defining the objectives and goals of a project

• Breaking down the tasks into smaller, manageable steps

• Assigning responsibilities to team members

• Monitoring progress and making adjustments as needed

• Evaluating the results and outcomes of the work process