Question
In a row of boys facing the north, Amit is fifteenth
from the left end and Dev is fifteenth from the right end. Subham, who is fifth to the right of Amit, is fourth to the left of Dev in the row. How many girls are there in the row?Solution
Amit’s rank from the left end = 15th. Dev’s rank from the right end = 15th. Subham, who is fifth to the right of Amit, is fourth to the left of Dev in the row So, total no. of boys in the row = (Subham’s Rank from the left end + Subham’s Rank from the right end) – 1 = [(15 + 5) + (15 + 4)] – 1 = 49 – 1 = 48
A Fact Constellation Schema is also called:
In a data cube, what does "slice" operation do?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which type of OLAP allows analysis of multidimensional data stored in relational databases?
A surrogate key is:
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
What is the primary function of ETL in a data warehouse environment?
Which OLAP operation summarizes data along a dimension?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?