Gujarat Fluorochemicals Interview Questions and Answers

Address under performers by providing feedback, setting clear expectations, offering support, and implementing consequences if necessary.

• Provide constructive feedback on areas of improvement

• Set clear performance expectations and goals

• Offer support and resources to help under performers improve

• Implement consequences if performance does not improve

• Consider reassigning tasks or providing additional training

Attrition is the rate of employee turnover in an organization.

• Attrition is calculated by dividing the number of employees who left the organization by the average number of employees in the organization during a specific period of time.

• It is an important metric for HR and operations teams to track as high attrition rates can indicate issues with employee satisfaction, company culture, or management.

• For example, if a company had 100 employees at the beginning of the year and 2...read more

Cursors are used in databases to retrieve and manipulate data row by row.

• Cursors allow for sequential processing of query results.

• They can be used to update or delete specific rows in a result set.

• Cursors can be used in stored procedures to iterate through a result set.

• Example: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM table_name;

Shrinkage is calculated by dividing the total amount of time an employee is not available to work by the total scheduled work time.

• Calculate total scheduled work time for a specific period (e.g. a day, week, month).

• Determine the total amount of time employees are not available to work due to breaks, meetings, training, etc.

• Divide the total time employees are not available by the total scheduled work time to get the shrinkage percentage.

Attrition rate is calculated by dividing the number of employees who left the company during a certain period by the average number of employees during that same period.

• Calculate the number of employees who left the company during a specific time frame.

• Calculate the average number of employees during that same time frame.

• Divide the number of employees who left by the average number of employees to get the attrition rate.

• Multiply the result by 100 to get the attrition rate as ...read more

Trunc is a DDL command used to delete all rows from a table, while delete is a DML command used to remove specific rows.

• Trunc is faster than delete as it does not log individual row deletions.

• Trunc resets the identity seed of the table, while delete does not.

• Trunc cannot be rolled back, while delete can be rolled back using a transaction.

• Trunc is used to quickly remove all rows from a table, while delete is used to remove specific rows based on a condition.