Question
Six persons H, I, J, K, L and M have different heights
and different weights. L, who is the tallest person, is heavier than only J and H. I, who is lighter than K, is taller than K, who is not the heaviest person. J is lighter and shorter than both H and M. J is taller than I. Heaviest person is not the third tallest person. How many persons are taller than H?Solution
L, who is the tallest person, is heavier than only J and H. We will get L is third lightest person. Ranking for Weight: __ > __ > __ > L > J/H > H/J Ranking for Height: L > __ > __ > __ > __ > __ I, who is lighter than K, is taller than K, who is not the heaviest person. J is lighter and shorter than both H and M. J is taller than I. Heaviest person is not the third tallest person. We will get I is the third heaviest person. J is the lightest person and third smallest person. M is the heaviest person and second tallest person. The final arrangement is as follows: Ranking for weight, M > K > I > L > H > J Ranking for height, L > M > H > J > I > K
A star schema in a data warehouse consists of:
A snowflake schema differs from a star schema mainly because:
Which of the following is used to maintain information about the structure of a data warehouse?
In a data warehouse, which type of table stores quantitative data for analysis?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
Which SQL function returns the total number of rows in a table?
Which SQL keyword is used to combine results from two queries and remove duplicates?
What is a data mart?