Question
8 years ago from now, ratio of ages of ‘R’ and
‘L’ was 3:5, respectively. If ‘L’ is 7 years elder to ‘R’, then what will be the age of ‘L’, 2 years hence from now?Solution
8 years ago from now, let ages of ‘R’ and ‘L’ be ‘3x’ years and ‘5x’ years, respectively. So, 5x – 3x = 8 Or, 2x = 8 Or, x = 4 Present age of ‘L’ = 5x + 7 = 5 × 4 + 7 = 27 years Age of ‘L’, two years hence from now = 27 + 2 = 29 years
Surrogate keys are used in data warehouses because:
Which SQL clause is used to filter records after aggregation?
ETL stands for:
Which of these is not a typical data warehouse characteristic?
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Which analytics type is focused on predicting future outcomes?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which SQL clause is used to summarize data?
Which OLAP operation allows drilling down into more detailed data?
Which OLAP operation summarizes data along a dimension?
Relevant for Exams:
