Schlumberger Interview Questions and Answers

Union All in SQL is used to combine the result sets of two or more SELECT statements, including duplicate rows.

• Union All is used to combine the results of multiple SELECT statements into a single result set.

• It includes all rows from each SELECT statement, even if there are duplicate rows.

• The number of columns and data types must be the same in all SELECT statements being combined.

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

Union all combines the results of two or more SELECT statements into a single result set.

• Union all is used to combine the results of multiple SELECT statements into a single result set.

• It includes all rows from each SELECT statement, even if there are duplicates.

• The number of columns and data types must be the same in all SELECT statements.

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

• Example: SELECT name, age FROM employees UNION ALL SELECT name, a...read more

As a Data Analyst, my roles and responsibilities include analyzing data, creating reports, identifying trends, and providing insights to support decision-making.

• Analyzing data to identify trends and patterns

• Creating reports and visualizations to communicate findings

• Providing insights and recommendations based on data analysis

• Collaborating with stakeholders to understand business needs

• Cleaning and organizing data for analysis

• Using statistical tools and techniques to interpret ...read more

Python code to merge 3 columns and rows in a dataframe.

• Use the pandas library in Python to work with dataframes.

• Use the concat() function to merge columns and rows.

• Specify the axis parameter as 1 to merge columns.

My expected CTC is based on my experience, skills, and the market rate for data analysts.

• Expected CTC is based on my years of experience in data analysis

• Consideration of my skills in data visualization, statistical analysis, and programming languages like Python and SQL

• Research on the current market rate for data analysts in the industry

• Open to negotiation based on the overall compensation package offered by the company