Question
Monthly income of A is Rs. 6500 and he saves 36% of his
monthly income. If monthly expenditure of A is decreased by 35% while his monthly savings is increased by 35% then find the increase or decrease in his monthly income.Solution
Monthly savings and expenditure of A initially is Rs. 2340 and Rs. 4160, respectively. Monthly expenditure of A now = 0.65 × 4160 = Rs. 3159 Monthly savings of A now = 1.35 × 2340 = Rs. 2704 Monthly income of A now = 3159 + 2704 = Rs. 5863 Desired percentage decrease = [(6500 – 5863)/6500] × 100 = 9.8%
What is meant by 'cardinality' in data modeling?
Which of the following best defines the concept of the "Internet of Things" (IoT)?
In a star schema, what is the main advantage of using surrogate keys in fact tables?
In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?
A star schema in a data warehouse consists of:
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
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 is a real-time data warehouse application?
A Fact Constellation Schema is also called:
Relevant for Exams:
