Question
What survey has the National Sample Survey Office (NSSO)
conducted, and what is the aim of this survey?Solution
The Household Consumption Expenditure Survey (HCES) conducted by the NSSO aims to generate estimates of household Monthly Per Capita Consumption Expenditure (MPCE) and its distribution separately for rural and urban sectors, states, union territories, and different socio-economic groups.
Fact constellation schema is best described as:
In a star schema, what is the primary characteristic of the fact table?
What is meant by 'cardinality' in data modeling?
Which of the following best describes the primary function of a database index?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which process ensures data in a data warehouse is consistent and clean?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which of the following is NOT a common OLAP operation?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which SQL clause is used to filter records after aggregation?