Question
The table provided displays the total no of shirts made
from two distinct materials (silk and cotton) and the ratio of shirts produced using these materials for five different shops. Determine the 40% of the number of cotton Shirts produced by Shop 'E'.Solution
ATQ, Required number of sarees = 0.4 x 975 = 390
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?