Question
What was the ratio of the total number of students
passed and failed in college C (during all the given years? Study the table carefully to answer the questions that follow: Number of students (in hundreds) passed (P) and failed (F) by four colleges over the years. ÂSolution
The total number of students passed in C during all the given year = (6800 + 4000 + 6600 + 4400 + 2500 + 4500) = 28800 The total number of students failed in C during all the given year = (3100 + 3000 + 5200 + 7200 + 4200 + 3000) = 25700 `:.` Â Reqd. Ratio = 28800 : 25700 = 288 : 257
Which SQL function returns the total number of rows in a table?
Which clause is used to sort the results in SQL?
Which type of OLAP allows operations on pre-aggregated data cubes?
In a data warehouse, a fact table typically contains:
Which of the following is NOT a common OLAP operation?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Which process loads data from multiple sources into a data warehouse?
Which OLAP operation summarizes data along a dimension?
Which OLAP operation rotates the data axes to provide an alternative presentation?
Relevant for Exams:
