Question
An amount of Rs. 4,000 was borrowed at 18% p.a. and another
amount of Rs. 6,000 at 12% p.a. as simple interest. The total interest paid after ‘n’ years is Rs. 4,320. Find the value of ‘n’.Solution
ATQ,
4000 × (18/100) × n + 6000 × (12/100) × n = 4320
Or, 720n + 720n = 4320
So, n = (4320/1440) = 3 years
Which SQL clause is used to filter records after aggregation?
A data cube allows analysis by:
In OLAP, “Slice and Dice” means:
Which type of OLAP allows operations on pre-aggregated data cubes?
Which of the following best describes the primary function of a database index?
Which clause is used to sort the results in SQL?
Which type of schema normalizes dimension tables to reduce redundancy?
Metadata in data warehousing refers to:
A snowflake schema is different from a star schema because:
Which of the following is a real-time data warehouse application?