Sauradip chemicals Industries Interview Questions and Answers

Different types of joins in database management, null values in primary and unique key columns, and right join in SQL.

• Types of joins: inner join, outer join (left, right, full), cross join, self join

• Primary key column cannot contain null values

• Unique key column can contain null values, but only one null value is allowed

• Right join in SQL: returns all rows from the right table and the matched rows from the left table

A line chart showing continuous sales data from January 2021 to December 2024.

• Use a line chart to display the trend of sales over time

• Include a time axis with months from January 2021 to December 2024

• Label the axes clearly and provide a legend if necessary

Sales comparison between last year and current year with relevant filters

• Calculate total sales for last year and current year

• Apply any relevant filters such as product category or region

• Compare sales figures to identify trends or changes

• Visualize the comparison using charts or graphs for better understanding

Calculate a three-month running total using DAX and Excel

• In DAX, use the CALCULATE function with a FILTER for the three-month period

• In Excel, use a combination of SUM and OFFSET functions to calculate the running total

• For example, in DAX: CALCULATE(SUM([Value]), FILTER(ALL('Date'[Month]), 'Date'[Month] >= 'November' && 'Date'[Month] <= 'January'))

• For Excel: =SUM(OFFSET($A$2, MAX(ROW($A$2:$A$10)-2, 1), 0, 3, 1))

The man will fall into the pit after 3 steps.

• The man moves 2 steps forward and 1 step backward in each cycle.

• After the first cycle, the man will be 1 step ahead.

• After the second cycle, the man will be 2 steps ahead and fall into the pit on the third cycle.

Compare last year sales for budget with the forecast and visualize the sales comparison between budget and forecast.

• Calculate the difference between last year sales, budget, and forecast.

• Create a bar chart showing the comparison of last year sales, budget, and forecast.

• Highlight any significant deviations between budget and forecast.

• Provide a narrative explaining the reasons for any discrepancies.

Yes, the target molecule can be synthesized using different routes.

• One possible route is through a series of chemical reactions starting from readily available starting materials.

• Another route could involve using a different catalyst or reagent to achieve the desired transformation.

• Alternatively, a multi-step synthesis approach can be employed to access the target molecule.

• Different protecting groups or functional group transformations can also be explored to arrive at the ta...read more

The region with the highest sales is North America.

• Check sales data for each region or country

• Look for the region or country with the highest total sales

• Create a bar chart or pie chart to visualize the data