Question
A car running with a speed of 50 km/hr takes 8 hours to
go from 'A' to 'B'. If on the way back from 'B' to 'A', the car takes 20% less time than it takes while going from 'A' to 'B', then find the approximate average speed of the car during the whole journeySolution
Total distance covered by the car in 8 hours = 50 x 8 = 400 km Time taken by the car in the return journey = 0.80 x 8 = 6.4 hours Average speed = Total distance covered ÷ Total time taken Average speed of the car = (400 x 2) ÷ (8 + 6.4) ~ 55.5 km/h
Which of the following best describes the primary function of a database index?
Fact constellation schema is best described as:
In a data cube, what does "slice" operation do?
Which process loads data from multiple sources into a data warehouse?
A star schema in a data warehouse consists of:
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 clause is used to summarize data?
Which of the following best describes a fact constellation schema in a data warehouse?
Which OLAP operation allows users to view data at different levels of granularity?
Which of the following is a real-time data warehouse application?
