Question
Pipes P and Q can fill a tank in 14 hours and 21 hours
respectively, while pipe R can empty the completely filled tank in 42 hours. If all the three pipes are opened together at 3 p.m., then at what time will 60% of the tank be filled?Solution
ATQ, Let the capacity of the tank be 420 units Efficiency of pipe P = 420/14 = 30 units/hour Efficiency of pipe Q = 420/21 = 20 units/hour Efficiency of pipe R = 420/42 = 10 units/hour Tank filled in 1 hour = 30 + 20 β 10 = 40 units 60% of the tank = 420 Γ 60/100 = 252 units Time taken to fill 60% of the tank = 252/40 = 6.3 hours = 6 hours + (0.3 Γ 60) minutes = 6 hours 18 minutes Therefore, tank will get filled at (3:00 p.m. + 6:18) = 9:18 p.m.
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Data cleansing is primarily concerned with:
In a data warehouse, which type of table stores quantitative data for analysis?
Which of the following is NOT a common OLAP operation?
Which of these is not a typical data warehouse characteristic?
Which of the following is used to maintain information about the structure of a data warehouse?
What is meant by 'cardinality' in data modeling?
Which of the following is a key process in ETL?
A star schema in a data warehouse consists of:
Which operation in OLAP allows selecting a single dimension from a cube?