Question
The value of A’s car is depreciating by 33% every year
whereas the value of his house is appreciating by 11% each year as compared to the previous year. If in 2018, the value of his car and house was Rs. 660000 and Rs. 8000000, respectively then find the sum of the values of his car and house together in 2020.Solution
Total sum of values = 660000 × 0.67 × 0.67 + 8000000 × 1.11 × 1.11 = 296274 + 9856800 = Rs. 10153074
A surrogate key is:
Which analytics type is focused on predicting future outcomes?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
Which of the following best describes a fact constellation schema in a data warehouse?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which of these is NOT an ensemble method?
Which of the following best describes the primary function of a database index?
What is meant by 'cardinality' in data modeling?
In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?
