Question
If the sum of runs scored by M and N is 88 and the sum
of runs scored by N and P is 66, then what is the probable number of runs scored by L? Answer the questions based on the information given below. Seven cricketers (J, K, L, M, N, O and P) scored different numbers of runs in a match. M scored more runs than N but less than K. J scored more runs than P but less than O. L doesn’t score lowest number of runs but less than N. N doesn’t scored 4th highest number of runs. O scored more runs than N but less than M. Cricketer, who scored 2nd highest number of runs, scored 65 runs.Solution
M + N = 88
52 + N = 88
N = 88 – 52 = 36.
N + P = 66
36 + P = 66
P = 66 – 36 = 30.
L will scored number of runs between 30 and 36.
M scored more runs than N but less than K. L doesn’t score lowest number of runs but less than N. N doesn’t scored 4th highest number of runs.
K > M > N > L
J scored more runs than P but less than O. O scored more runs than N but less than M. Cricketer, who scored 2nd highest number of runs, scored 52 runs.
K > M (65) > O > N > J > L > P
The final arrangement is as follow:
K > M (65) > O > J > N > L > P
Which SQL clause is used to filter records after aggregation?
A data cube allows analysis by:
In OLAP, “Slice and Dice” means:
Which type of OLAP allows operations on pre-aggregated data cubes?
Which of the following best describes the primary function of a database index?
Which clause is used to sort the results in SQL?
Which type of schema normalizes dimension tables to reduce redundancy?
Metadata in data warehousing refers to:
A snowflake schema is different from a star schema because:
Which of the following is a real-time data warehouse application?