Sava International 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.

I worked as a content writer at XYZ Company.

• Proficient in writing engaging and informative articles

• Skilled in conducting research and gathering information

• Experience in proofreading and editing content

• Familiarity with SEO techniques for optimizing content

• Ability to meet deadlines and work under pressure

I have a diverse range of skills including communication, problem-solving, and technical proficiency.

• Excellent communication skills, both written and verbal

• Strong problem-solving abilities

• Proficient in various technical skills such as programming languages (e.g. Python, Java), data analysis, and software development

• Ability to work well in a team and collaborate effectively

• Adaptability and willingness to learn new skill