Question
What approximate value will come in place of the question
mark (?) in the following question? (Note: You are not expected to calculate the exact value.) 18.92 Γ β? = 2903.7 Γ· 9.03Solution
ATQ,
18.92 Γ β? = 2903.7 Γ· 9.03
19 Γ β? ~ 2904 Γ· 9
19 Γ β? ~ 323
β? ~ 17
? ~ 289
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 schema uses multiple fact tables sharing dimension tables?
Which of the following is used to maintain information about the structure of a data warehouse?
Which type of data warehouse is focused on specific business lines or departments?
Which type of slowly changing dimension (SCD) preserves full history by adding a new row for each change and using effective date ranges?
A Fact Constellation Schema is also called:
A surrogate key is:
Which OLAP operation allows users to view data at different levels of granularity?
A star schema in a data warehouse consists of:
Which operation in OLAP allows selecting a single dimension from a cube?