Question
Which of the following contains
Grapes? Study the given information and answer the questions:      Eight boxes G, H, I, J, K, L, M, N are placed one above the other but not necessarily in the same order. These boxes contain different fruits Apple, Banana, Mango, Guava, Pear, Grapes, Dates and Peach but not necessarily in the same order. There are two boxes between Box G and the box which contains Dates. Box J is just above the box which contain Banana. Two boxes are between boxes I and H, which is below box I. Neither box I nor the box which contains Apple in bottom four. Box K contains Pear but is not the bottommost. Box H does not contain Mango or Peach. Box I is just above the box which contains Guava. The bottommost box does not contain Mango or Banana. Three boxes are between the boxes which contains Apple and Dates. Box J is below Box H but not just below. Box H does not contain Dates. Three boxes are kept between box L and the box which contains Apple. Not more than two boxes are kept between M and N, which is below box M.ÂSolution
Explanation : (i)- There are two boxes between Box G and the box which contains Dates. Three boxes are between the boxes which contains Apple and Dates. The box which contains Apple is not in bottom four. Case1- box G is above box which contains Dates and Case2- box G is below box which contains Dates. Â (ii)- Two boxes are between boxes I and H, which is below box I. Neither box I nor the box which contains Apple in bottom four. Box H does not contain Dates. Box I is just above the box which contains Guava. We get further 2 possibilities in both the cases. Â Â Â
(iii)- Box J is just above the box which contains Banana. Box J is below Box H but not just below. Case1 (b) and Case2 (b) gets eliminated. The bottommost box does not contain Banana. Box K contains Pear but is not the bottommost. Box H does not contain Mango or Peach. The bottommost box does not contain Mango. Three boxes are kept between box L and the box which contains Apple. Â Case 1(a) -
Â
A Fact Constellation Schema is also called:
In a data cube, what does "slice" operation do?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which type of OLAP allows analysis of multidimensional data stored in relational databases?
A surrogate key is:
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
What is the primary function of ETL in a data warehouse environment?
Which OLAP operation summarizes data along a dimension?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?