Question
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 all three pipes are opened together then what is the time taken to fill 50% of the cistern?Solution
Let the capacity of the cistern = 180 units Then, efficiency of pipe ‘A’ = 180/20 = 9 units/minute Efficiency of pipe ‘B’ = 180/18 = 10 units/minute Efficiency of pipe ‘C’ = 180/12 = 15 units/minute So, combined efficiency of pipes ‘A’, ‘B’ and ‘C’ = 9 + 10 – 15 = 4 units/minute 50% of the cistern’s capacity = 90 units Therefore, time taken by all 3 pipes together to fill 50% of the cistern = 90/4 = 22.5 minutes
Which clause is used to sort the results in SQL?
Which of the following best describes a fact constellation schema in a data warehouse?
Which SQL function returns the total number of rows in a table?
ETL stands for:
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
In a star schema, what is the primary characteristic of the fact table?
Which process ensures data in a data warehouse is consistent and clean?
In OLAP, “Slice and Dice” means:
Which type of OLAP allows operations on pre-aggregated data cubes?
What is the primary function of ETL in a data warehouse environment?
Relevant for Exams:
