Question
A grocer purchased 15 kg of potatoes for Rs.900. He
spends some amount on transportation and then sells it for Rs.1,800. If the percentage of profit made by the grocer is 25%, what is the amount he spends on transportation? (Round off to the nearest integer)Solution
Let the amount he spends on transportation = x So total CP =900+x Profit = 25% and SP =1800 Total CP =(SP×100)/100+25 900+x = (1800×100)/125 900+x =1440 x =1440-900=540.
Fact constellation schema is best described as:
In a star schema, what is the primary characteristic of the fact table?
What is meant by 'cardinality' in data modeling?
Which of the following best describes the primary function of a database index?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which process ensures data in a data warehouse is consistent and clean?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which of the following is NOT a common OLAP operation?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which SQL clause is used to filter records after aggregation?
Relevant for Exams:
