Prince Pipes & Fittings Interview Questions and Answers

Q would take 5 hours to cover the distance from C to A.

• Calculate the distance between A and B using the given information.

• Use the ratio of speeds of P and Q to find their individual speeds.

• Calculate the time taken by P to cover the distance from A to B.

• Use the time taken by P to find the time taken by Q to cover the distance from C to A.

To change the ratio of milk and water from 3:2 to 2:3, water needs to be added to the mixture.

• Calculate the current quantities of milk and water in the mixture based on the given ratio.

• Determine the total quantity of the mixture before adding water.

• Set up an equation to find the amount of water needed to achieve the desired ratio.

• Solve the equation to find the amount of water to be added.

The number of tennis balls that can fit in a plane depends on the size of the plane and the size of the tennis balls.

• Calculate the volume of the plane's cargo hold and the volume of a tennis ball to determine how many can fit.

• Consider the shape and size of the tennis balls and how efficiently they can be packed in the space.

• Take into account any other items or cargo that may also need to be stored in the plane.

Answering questions related to SQL queries, joins, guesstimates, and shortest distance along a cuboid.

• Case study involves analyzing a specific scenario or problem to make data-driven decisions.

• WHERE clause filters rows based on a specified condition, while HAVING clause filters groups based on a specified condition.

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN, each combining rows from two or more tables based on a related column.

• Guesstimates involve...read more

Distinct count is used to count unique values in a column, while joins are used to combine data from multiple tables in SQL.

• Distinct count is achieved using the COUNT(DISTINCT column_name) function.

• Joins are used to combine data from two or more tables based on a related column between them.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.