Question
Three persons A, B and C invested different amounts in a
business, which are in A.P. The amount invested by B is Rs. 3000 more than that of A. C invested the highest amount. Find the total profit received if all of them invested their sum for equal duration and A invested Rs. 15000 for 4 months and received Rs. 1800 as profit.Solution
Ratio of profits received by A, B and C= (15000 × 4):(18000 × 4):(21000 × 4) = 5:6:7 Therefore, total profit received = 1800 × (5 + 6 + 7)/5 = Rs. 6480
Which SQL function returns the total number of rows in a table?
Which clause is used to sort the results in SQL?
Which type of OLAP allows operations on pre-aggregated data cubes?
In a data warehouse, a fact table typically contains:
Which of the following is NOT a common OLAP operation?
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 star schema, what is the main advantage of using surrogate keys in fact tables?
Which process loads data from multiple sources into a data warehouse?
Which OLAP operation summarizes data along a dimension?
Which OLAP operation rotates the data axes to provide an alternative presentation?
