Airworks Store Inspector Interview Questions and Answers

Union combines and removes duplicates, Union All combines without removing duplicates.

• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;

To show top 5 in pandas, use the nlargest() function.

• Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.

• For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.

A scatter plot is a better representation for 3 numerical columns.

• Use a scatter plot to show the relationship between the numerical columns.

• Scatter plots are effective for visualizing correlations and patterns in data.

• Each point on the plot represents a data point with values from all 3 columns.

Synthetic Events are events that are created by the browser to mimic real user events.

• Synthetic Events are used in React to handle events in a consistent manner across different browsers.

• They are created by React to wrap native browser events and provide additional functionality.

• Examples include onClick, onChange, and onSubmit events in React.

Event bubbling is the process where an event triggered on a child element is propagated up through its parent elements.

• Event bubbling allows a single event handler to be attached to a parent element, which will be triggered for all its children.

• When an event occurs on a child element, it first runs the event handlers on the child, then on its parent, and so on up the DOM tree.

• Event bubbling can be stopped using event.s

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

• SQL Joins are used to retrieve data from multiple tables based on a related column between them.

• Common types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Python numpy provides various functions for numerical operations on arrays.

• numpy.sum() - calculates the sum of array elements

• numpy.mean() - calculates the mean of array elements

• numpy.max() - returns the maximum value in an array

• numpy.min() - returns the minimum value in an array

• numpy.std() - calculates the standard deviation of array elements

I have over 5 years of experience managing projects in various industries, including IT, construction, and healthcare.

• Managed cross-functional teams to successfully deliver projects on time and within budget

• Developed project plans, timelines, and budgets to ensure project success

• Implemented project management tools and methodologies to improve efficiency and communication

• Led stakeholder meetings and provided regular pr...read more