10+ QatarEnergy Interview Questions and Answers

The minimum number of times you need to weigh the coins is 4.

• Divide the 100 coins into 3 groups of 33, 33, and 34 coins.

• Weigh the first two groups against each other.

• If they balance, the defective coin is in the third group.

• If they don't balance, the defective coin is in the lighter group.

• Divide the lighter group into 11 coins and weigh any 2 groups of 3 coins against each other.

• If they balance, the defective coin is one of the remaining 5 coins.

• If they don't balance, the def...read more

Possible reasons for a car manufacturer's decline in profits by 40% year over year

• Decreased demand for cars due to economic downturn

• Increased competition from other car manufacturers

• Rising production costs and expenses

• Decline in consumer confidence and spending

• Changes in government regulations impacting the automotive industry

SQL query to get top 100 Uber drivers by city

• Join drivers and users tables on city

• Aggregate driver ratings and count of rides

• Order by rating and count of rides

• Limit to top 100

Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.

• Analyze user behavior and preferences to understand their needs and preferences

• Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time

• Optimize search functionality to ensure accurate and relevant results

• Collaborate with restaurants to improve their online presence and menu offerings

• Leverage cust...read more

Linear Regression is used for continuous data while Logistic Regression is used for categorical data.

• Linear Regression predicts continuous values while Logistic Regression predicts probabilities.

• Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.

• Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.

• Linear Regression is sensitive to outliers while Logistic Regression is robust...read more

Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.

• Bias-Variance trade-off is a fundamental concept in machine learning.

• High bias models are simple and have low variance, but are inaccurate.

• Low bias models are complex and have high variance, but can overfit the data.

• Examples of high bias models are linear regression and decision trees with few nodes.

• Examples of lo...read more

Use Excel functions like VLOOKUP or INDEX/MATCH to derive results from SQL queries in Excel.

• Use VLOOKUP function to search for a value in a table and return a corresponding value from another column.

• Use INDEX/MATCH function to perform a two-way lookup by matching values in two different ranges.

• Import SQL query results into Excel using data connection or copy-paste method.

Joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.

• Joins are used in SQL to combine data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Window functions are used to perform calculations on a set of rows related to the current row

• Examples of window functions include...read more

The weight of an aircraft is crucial for its performance and safety.

• The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.

• The weight of an aircraft is measured in pounds or kilograms.

• The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.

• Aircraft manufacturers provide maximum takeoff and landing weights for each model of aircraft.

• Pilots must calcu...read more