Question
Which of the following shelf does the box with Tie
kept? Study the following information carefully and answer the below questions Eight accessories item boxes are kept one above another in a single stack of different shelves such that the lowermost shelf is numbered as 1 and the topmost shelf is numbered as 8. Tie box is kept three shelves above Gloves box. Gloves box is kept on an odd numbered shelf. The number of boxes kept above Gloves box is the same as below Jacket box. Boots box is kept two shelves above the Cravats box. Either the Cravats box or Boots box is kept adjacent to Jacket box. Hat box is kept above Belt box but below Shoes box. The number of shelves above the Shoes box is one more than the number of shelves below the Belt box.Solution
We have, Tie box is kept three shelves above Gloves box. Gloves box is kept on an odd numbered shelf. From the above condition, there are three possibilities. Again we have, Boots box is kept two shelves above the Cravats box. Either the Cravats box or Boots box is kept adjacent to Jacket box.
Again we have, The number of shelves above the Shoes box is one more than the number of shelves below the Belt box. Hat box is kept above Belt box but below Shoes box. From the above condition, case1 gets eliminated. Case3 shows the final arrangement.
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?