Question
Instead of increasing the number
first by 20% and then by 25%, it is reduced by 10%. What percentage does the final value represent of the correct desired value?Solution
ATQ,
Let the number be '100a'. Increased number = 100a × 1.2 × 1.25 = 150a Decreased number = 100a × 0.9 = 90a Required percentage = (90a/150a)×100 = 60%
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?