10+ Sahara India Pariwar Interview Questions and Answers

I have worked on Tableau for data visualization and analysis.

• Created interactive dashboards to visualize sales data

• Used Tableau to analyze customer behavior patterns

• Integrated Tableau with SQL databases for real-time reporting

HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows before grouping.

• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows before grouping

• HAVING is applied after the GROUP BY clause, WHERE is applied before

A palindrome program checks if a given string reads the same forwards and backwards.

• Create a function that takes a string as input

• Remove any spaces and punctuation from the string

• Reverse the string and compare it to the original string to check for palindrome

Market research is the process of gathering, analyzing, and interpreting information about a market, including customers, competitors, and industry trends.

• Involves collecting data on customer preferences, buying habits, and market trends

• Helps businesses make informed decisions about product development, pricing, and marketing strategies

• Can include surveys, focus groups, and data analysis

• Examples: conducting a survey to understand customer satisfaction levels, analyzing compet...read more

A class is a blueprint for creating objects in object-oriented programming. Self refers to the instance of the class.

• A class is a template for creating objects with similar properties and methods.

• It defines the attributes and behaviors of the objects that will be created from it.

• Self is a reference to the instance of the class that is currently being worked with.

• It allows access to the attributes and methods of the current object.

Use SQL query with ORDER BY and LIMIT to find 2nd highest salary.

• Use ORDER BY clause to sort salaries in descending order.

• Use LIMIT 1,1 to skip the highest salary and fetch the second highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1;

E-commerce has revolutionized the way we shop and do business.

• E-commerce has made shopping more convenient and accessible.

• It has opened up new markets and opportunities for businesses.

• E-commerce has also led to the rise of online payment systems and digital currencies.

• However, it has also raised concerns about privacy and security.

• Overall, e-commerce has had a significant impact on the global economy.

The greater number from a list is the highest number present in the list.

• Compare each number in the list to find the highest one

• If there are multiple highest numbers, all of them are considered as the greater number

• For example, in the list [5, 10, 3, 10], the greater number is 10

Code for a given pattern

• Create an array of strings

• Use loops to iterate over the rows and columns of the pattern

• Fill the array with the appropriate characters based on the pattern

• Return the array as the result

WHERE clause is used to filter data in SQL queries.

• WHERE clause is used after the FROM clause in a SQL query.

• It is used to specify a condition that must be met for the query to return data.

• Multiple conditions can be combined using logical operators such as AND and OR.

• Examples: SELECT * FROM customers WHERE age > 18;

• Examples: SELECT * FROM orders WHERE status = 'shipped' AND total_amount > 1000;

Code for recurring numbers

• Create an array to store the numbers

• Loop through the array and check if a number is already present

• If a number is found, add it to the recurring numbers array

• Return the recurring numbers array

Business promotions can be analyzed by evaluating the effectiveness of different marketing strategies and campaigns.

• Evaluate the return on investment (ROI) for each promotion

• Analyze customer engagement and response rates

• Track sales data before, during, and after promotions

• Compare the success of different promotion channels (e.g. social media, email marketing)

• Gather feedback from customers and employees on the promotions

Main aspects of an invoice include vendor information, invoice number, date, amount, and payment terms.

• Vendor information: Name, address, contact details

• Invoice number: Unique identifier for tracking and reference

• Date: Date of issuance or submission

• Amount: Total amount due for payment

• Payment terms: Terms and conditions for payment

Joins in SQL are used to combine data from two or more tables based on a related column.

• Joins are used to retrieve data from multiple tables in a single query

• There are different types of joins such as inner join, left join, right join, and full outer join

• Inner join returns only the matching rows from both tables

• Left join returns all the rows from the left table and matching rows from the right table

• Right join returns all the rows from the right table and matching rows from th...read more