Question
How much money did Miss Mishra receive as retirement
fund? I. Out of the total money received, Miss Mishra gave 20% to her husband and 15% to her daughter. Out of the remaining, she invested 60% in Mutual Funds, 30% in Pension fund scheme and the remaining Rs. 3,90,000 she spent on miscellaneous items. II. Out of the total money received, Miss Mishra invested 62.5% in various schemes, gave 25% of the total money received to her husband and daughter and the remaining money she spent on miscellaneous items. Each of the questions below consists of a question and two statements numbered I and II given below it. You have to decide whether the data provided in the statements are sufficient to answer the question. Read both the statements and give answer –Solution
From I. Suppose Mishra receives Rs. 100x as retirement fund. Then, 100x - (20 + 15)x = 65% Again, 65x - (65x × 90)/100 = 6.5x So, 6.5x = 3,90,000 ∴x = (390000×10)/65 = Rs. 60,000 ∴ Mishra’s retirement fund = Rs. 60,000 Hence I alone is sufficient. In statement II, neither the total amount nor the remaining amount is given. Hence, with this statement we cannot answer the question.
Which type of schema normalizes dimension tables into multiple related tables?
What is meant by 'cardinality' in data modeling?
Which of the following best describes a fact constellation schema in a data warehouse?
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
ETL stands for:
Which of the following best describes the primary function of a database index?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which of the following best describes a Data Warehouse?
Which of the following is a real-time data warehouse application?