Supply Chain Associate Interview Questions and Answers

To disable automatic sorting in a Pivot table, go to the Pivot table options and uncheck the 'Sort automatically' option.

• Open the Pivot table in Excel.

• Go to the 'PivotTable Analyze' or 'Options' tab.

• Click on the 'Options' button in the 'PivotTable' group.

• In the 'PivotTable Options' dialog box, go to the 'Data' tab.

• Uncheck the 'Sort automatically' option.

• Click 'OK' to apply the changes.

Truncate is a DDL command that removes all rows from a table, while delete is a DML command that selectively removes rows.

• Truncate is faster than delete as it doesn't generate any log entries.

• Truncate cannot be rolled back, while delete can be.

• Truncate resets the identity of the table, delete does not.

• Truncate does not fire triggers, delete does.

• Truncate releases the storage space, delete does not.

To remove duplicates in Excel, use the Remove Duplicates feature under the Data tab.

• Select the range of cells or columns that contain the data.

• Go to the Data tab and click on the Remove Duplicates button.

• Choose the columns to check for duplicates and click OK.

• Excel will remove the duplicate values and keep only the unique values.

• You can also choose to highlight the duplicate values instead of removing them.

Mean, median, and mode are statistical measures used to describe the central tendency of a dataset.

• Mean is the average of a set of numbers, calculated by summing all the values and dividing by the total count.

• Median is the middle value in a dataset when arranged in ascending or descending order.

• Mode is the value that appears most frequently in a dataset.

• Mean is sensitive to outliers, while median is not.

• Mode can be used to identify the most common value or category in a datas...read more

Different joins in SQL include inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all rows from the left table and the matching rows from the right table.

• Right join returns all rows from the right table and the matching rows from the left table.

• Full outer join returns all rows from both tables, including unmatched rows.

A warranty is a guarantee provided by a manufacturer or seller regarding the condition of a product and its repair or replacement.

• Warranties can be either express (written) or implied (understood).

• For example, a one-year warranty on electronics covers defects in materials or workmanship.

• Extended warranties offer additional coverage beyond the standard period, often for a fee.

• Warranties typically do not cover damage from misuse or normal wear and tear.

• In the automotive industr...read more