Question
An Assertion (A) and a Reason (R) are given below.
Assertion (A): Clothes are not washed properly in hot water. Reason (R): Hard water contains many minerals. Choose the correct option.Solution
Clothes are not washed properly in hard water because it does not form lather with soap. However, it is true that hard water contains many minerals.
A star schema in a data warehouse consists of:
A snowflake schema differs from a star schema mainly because:
Which of the following is used to maintain information about the structure of a data warehouse?
In a data warehouse, which type of table stores quantitative data for analysis?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
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 function returns the total number of rows in a table?
Which SQL keyword is used to combine results from two queries and remove duplicates?
What is a data mart?
Relevant for Exams:
