Question
‘S’ has 20% fewer books than ‘T’. ‘T’ has 25%
more books than ‘U’. By how much percent are the books with ‘S’ less than those with ‘U’?Solution
ATQ,
Let, number of books with ‘T’ = 25b
Number of books with ‘S’ = 0.8 × 25b = 20b
Number of books with ‘U’ = (25b/1.25) = 20b
So, required percentage = {(20b – 20b)/20b} × 100 = 0%
A star schema in a data warehouse consists of:
A snowflake schema differs from a star schema mainly because:
Which of the following is used to maintain information about the structure of a data warehouse?
In a data warehouse, which type of table stores quantitative data for analysis?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
Which SQL function returns the total number of rows in a table?
Which SQL keyword is used to combine results from two queries and remove duplicates?
What is a data mart?