Question
In an election between two candidates, winner got 40% of
total valid votes. If total number of votes cast were 1000 out of which 6% were invalid, then find the number of votes received by loser candidate.Solution
Total valid votes = 94% of 1000 = 940 Number of votes received by loser candidate = 0.5 × 940 = 564
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which type of schema normalizes dimension tables to reduce redundancy?
Surrogate keys are used in data warehouses because:
Which SQL clause is used to filter records after aggregation?
Which schema uses multiple fact tables sharing dimension tables?
Which process loads data from multiple sources into a data warehouse?
Which of the following is a real-time data warehouse application?
Which of the following is used to maintain information about the structure of a data warehouse?
In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?
A snowflake schema is different from a star schema because:
