Question
Which OLAP operation involves focusing on a subset of
dimensions (e.g., region=‘Asia’)?Solution
Slice reduces the cube by fixing one dimension value (like filtering rows in SQL). Dice filters multiple values, roll-up aggregates, drill-down goes deeper into hierarchy, pivot rotates.
The present ages of a father and son are in the ratio 7 : 2 . After 6 years , the father’s age will be 3 times  the son’s age. What is the fa...
Currently, the average age of individuals 'A' and 'B' is 27 years. If the present ages of 'B' and 'C' maintain a ratio of 10:11, determine the age of 'C...
Present ages of P and Q are in the ratio 3:7 respectively. If Q’s age, 10 years hence from now will be 5 times of P’s age, 6 years ago from now, the...
The current ages of P and Q are in the ratio of 8:5. The ratio of P's age seven years ago to Q's age ten years from now is 5:6. W...
The current age of Jerry is three times that of Kim. 4 years from now, Jerry's age will be 2.5 times the age of Leo at that time. If Kim is 4 years youn...
The present age of Preeti is twice Ruchi’s present age. Six years ago, their average age was 15 years. What will be the Preeti’s age after f...
The average age of the husband, wife, and their child 4 years ago was 24 years and that of the husband and the child 5 years ago was 19 years. The pres...
- At present, the total of ages of Arjun and Ravi is 60 years. Two years ago, the ratio of their ages was 3:4. What is the current age of Ravi?
The ratio of A’s age to B’s age is 2 : 3. If 6 years are subtracted from each of their ages, the new ratio becomes 3 : 5. Find B'spresent age.
The present age of Surjeet and Rakesh are in the ratio of 4:5. After 8 years the ratio of their ages will be 6:7. What is 70% of the sum of their presen...
