Question
An automobile agency launched a scheme that if a
customer purchased two Jabas Discover bikes, one extra Jabas Discover will be free and if he purchases 3 Jabas Pulsar, he will get one extra Jabas Pulsar free. If the cost price of three Jabas Discover and four Jabas Pulsar be Rupees 67,500 and rupees 232500 respectively. If a customer purchases 2 bikes of Jabas discovers three bikes of Jabas pulser as per scheme he availed 1 bike free of each category, then at what price this bike should be sold that agency can get overall profit of 17.5%.Solution
Sol.Ans. Rs. 352500 Cost price of 5 bikes = Rs. 67500+232500 = Rs. 300000 Now, since we require 17.5% profit, so SP = (300000*117.5)/100 Rs. 352500
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?
Relevant for Exams:
