Supply Chain Associate
Supply Chain Associate Interview Questions and Answers
Q1. How to disable automatic sorting in the Pivot table .?
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.
Q2. Difference between truncate and delete command in SQL..?
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.
Q3. How do you remove duplicates in Excel. ?
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.
Q4. What are mean, median and mode.?
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
Q5. What are stored procedures in SQL.?
Stored procedures are precompiled SQL statements that are stored in a database and can be executed multiple times.
Stored procedures are used to encapsulate a set of SQL statements into a single unit.
They can be used to improve performance by reducing network traffic.
Stored procedures can be parameterized, allowing for dynamic execution.
They provide a level of security by controlling access to the underlying database objects.
Stored procedures can be called from other SQL state...read more
Q6. What are the different joins in SQL .?
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.
Share interview questions and help millions of jobseekers 🌟
Q7. What is RLS in Power BI .?
RLS in Power BI stands for Row-Level Security.
RLS is a feature in Power BI that allows you to restrict data access at the row level based on user roles.
It helps in ensuring that users only see the data that is relevant to them.
RLS can be implemented by defining roles and rules in Power BI Desktop or Power BI service.
For example, you can create a role that only allows access to sales data for a specific region.
RLS is useful in maintaining data privacy and security in organizat...read more
Supply Chain Associate Jobs
Interview Questions of Similar Designations
Interview experiences of popular companies
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Reviews
Interviews
Salaries
Users/Month
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
