Question
A sum of ₹400 amounts to ₹441 in 2 years at a
certain rate of interest per annum, compounded annually. The rate of interest per annum is:Solution
ATQ,
Given: Principal (P) = ₹400 Amount (A) = ₹441 Time (T) = 2 years Rate (R) = ? Compound Interest Formula = A = P × (1 + R/100)² Substitute values: 441 = 400 × (1 + R/100)² 441/400 = (1 + R/100)² 1.1025 = (1 + R/100)² Take square root: √1.1025 = 1 + R/100 1.05 = 1 + R/100 R/100 = 0.05 → R = 5
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?