RuhRPumpen India Interview Questions and Answers

Single mode and multiple mode are different types of fiber optic cables used for transmitting data.

• Single mode fiber optic cables have a smaller core diameter and allow for the transmission of a single mode of light, resulting in higher bandwidth and longer transmission distances.

• Multiple mode fiber optic cables have a larger core diameter and allow for the transmission of multiple modes of light, resulting in lower ba...read more

A Business Analyst (BA) will analyze business processes, identify areas for improvement, and recommend solutions to enhance efficiency and productivity.

• Analyze business processes

• Identify areas for improvement

• Recommend solutions to enhance efficiency and productivity

• Collaborate with stakeholders to gather requirements

• Create and maintain project documentation

• Facilitate communication between technical and non-technical te

Analytics is the process of analyzing data to gain insights and make informed decisions.

• Analytics involves collecting, processing, and interpreting data

• It can be used in various fields such as business, healthcare, and sports

• Examples of analytics tools include Google Analytics, Tableau, and SAS

• Analytics can help identify patterns, trends, and opportunities for improvement

• It can also be used for predictive modeling and

Write a query

• Specify the database and table name

• List the columns to be selected

• Add any conditions or filters

• Specify the order of results

Complex SQL scenarios and their results

• Using subqueries to filter data

• Joining multiple tables with complex conditions

• Using window functions to calculate running totals

• Pivoting data to transform rows into columns

• Using recursive queries to traverse hierarchical data