Question
In an exam, Rina scored 54% marks and failed by 80 marks
whereas Tina scored 74% marks in the same exam and scored 60 marks more than the passing marks. Find the maximum marks of the exam.Solution
ATQ; Let the maximum marks of the exam be ‘100x’ Marks scored by Rina = 100x × 0.54 = ‘54x’ Marks scored by Tina = 100x × 0.74 = ‘74x’ According to question: 54x + 80 = 74x – 60 Or, 74x – 54x = 80 + 60 Or, 20x = 140 Or, x = 7 Therefore, maximum marks of the exam = 100x = 100 × 7 = 700
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?
