Question
Which database operation is used to combine records from
two or more tables based on related columns?Solution
JOIN is used to combine the records from 2 or more than 2 tables.
Pipes P and Q can fill a tank in 12 hours and 15 hours respectively, while a third pipe C can empty the tank in 24 hours. If all three pipes are opened ...
Pipe ‘A’ and pipe ‘B’ can fill a cistern in 20 minutes and 18 minutes respectively. Pipe ‘C’ alone can empty the cistern in 12 minutes. If a...
An inlet pipe can fill an empty tank in 24 minutes whereas an outlet pipe can empty the fully filled tank in 36 minutes. Find the time taken by both the...
Pipe ‘A’ can fill a tank in 60 hours whereas leak ‘A’ can empty it in 70 hours. If they both operate along with pipe ‘B’, then the given tan...
Pipe ‘A’ can fill a tank in 20 hours while pipe ‘B’ takes 32 hours to empty it. Pipe ‘A’ is opened alone when the tank was empty and after 1...
The efficiencies of two inlet pipes, 'P' and 'Q', are in the ratio of 3:5, respectively. When both pipes are open together, the tank is filled in 16 hou...
Pipe ‘A’ and pipe ‘B’, together can fill 20% of a tank in 7 hours while pipe ‘C’ takes 40 hours to empty it. ...
The time taken by pipe B3 alone to fill an empty tank completely is half of the time taken by pipe B1 alone to fill the same tank completely. Pipe B2 al...
A tank is 3/4 full of water. After removing 30 litres of water, it becomes 3/8 full. Find the full capacity of the tank.
A tank is filled with three pipes A, B, and C. Pipe A takes 18 hr. to fill 60% of the tank and Pipe B takes 8 hr. to fill 40% of the tank. Pipe A and Pi...
Relevant for Exams:
