Question
Two trains of same length are running in parallel tracks
in the same direction with speed 60 km/hr and 90 km/hr respectively. The latter completely crosses the former in 30 seconds. Find the length of each train (in m).Solution
When two trains cross each other, they cover distance equal to the sum of their lengths with relative speed.  Let's take length of each train = x So, total length of both trains = 2x Relative speed = (90 – 60) × (5/18) = 25/3 m/sec. ∴ Total length = Time × Relative speed ⇒  2x = (30 × 25)/3 ⇒  x = 125 m
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?