Question
An integer 'p' is added to each of 12, 20, 36 and 48 so
that the resulting numbers will be in proportion in given order only. Find the value of '(p + 4)'.Solution
Let 'p' be the number that must be added to each of the given numbers so that they become proportional. i.e. (12 + p) :(20 + p) ::(36 + p) :(48 + p) So, (12 + p) ÷ (20 + p) = (36 + p) ÷ (48 + p) Or, (12 + p) (48 + p) = (36 + p) (20 + p) Or, 576 + 12p + 48p + p2 = 720 + 36p + 20p + p2 Or, 576 + 60p = 720 + 56p Or, 4p = 144 Or, 'p' = 36 Required value = p + 4 = 36 + 4 = 40
Which of the following best describes the primary function of a database index?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
In a data warehouse, a fact table typically contains:
Which OLAP operation rotates the data axes to provide an alternative presentation?
Which of the following is NOT a characteristic of OLAP systems?
A surrogate key is:
Which OLAP operation summarizes data along a dimension?
Which type of OLAP allows operations on pre-aggregated data cubes?
Which of the following best describes a Data Warehouse?
Which type of OLAP allows analysis of multidimensional data stored in relational databases?
