Question
Two friends received a bonus of ₹3,000 each in their
bank accounts. They already have ₹47,000 and ₹57,000 in their respective bank accounts. The ratio of the amounts in their respective accounts will be:Solution
Two friends already have money =47000 and 57000 After receiving a 3000 bonus= 50000 and 60000. The ratio of the amounts in the ir respective accounts=50000:60000 =5:6
Surrogate keys are used in data warehouses because:
Which SQL clause is used to filter records after aggregation?
ETL stands for:
Which of these is not a typical data warehouse characteristic?
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Which analytics type is focused on predicting future outcomes?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which SQL clause is used to summarize data?
Which OLAP operation allows drilling down into more detailed data?
Which OLAP operation summarizes data along a dimension?