MCI Group Holding 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.

CSS Sprite is a technique used to combine multiple images into a single image to reduce the number of server requests.

• CSS Sprite helps in reducing loading time by reducing the number of HTTP requests.

• It involves combining multiple images into one larger image and then using CSS to display only the portion of the image needed.

• This technique is commonly used for icons, buttons, and other small images on websites.

• By using...read more