Question
How is U related to
T? Answer the questions based on the information given below. There are eight members (R, S, T, U, V, W, X and Y) in a family, which consists of three generations. No single person in the family is a parent. V’s father-in-law’s mother’s daughter is Y. X is daughter of R, who doesn’t have son. R is not a male member. T is sister-in-law of V. S, who is not a male member, is not mother of U.Solution
-Scale-1/1710247213-GIC2024PYP18-20.jpg)
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?