Question
An article has a cost price of Rs. 8,500. It is marked
up by 45% above its cost price and is sold after a discount of Rs. 1,700. What is the percentage profit earned on the sale of the article?Solution
Marked price of article = 1.45 X 8,500 = Rs. 12,325 Selling price of article = 12,325 - 1,700 = Rs. 10,625 So, profit earned = [(10,625 - 8,500) ÷ 8,500] X 100 = (2,125/8,500) X 100 = 25%
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:
