Question
Calculate NNPfc from the following data: (in Rs
crores) PFCE 700 Profit 100 GFCE 400 Net indirect taxes 100 Gross domestic capital formation 250 Change in stock 50 NFIA -40 Consumption of fixed capital 20 Net imports 30Solution
NNPfc = PFCE + GFCE – Net imports + Gross Domestic Capital formation – Consumption of fixed capital – NIT + NFIA = 700 + 400 – 30 + 250 – 20 -100 + (-40) =1160
In ETL pipelines, which step is primarily responsible for resolving inconsistencies and correcting data quality issues (e.g., missing values, inconsiste...
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?
A snowflake schema differs from a star schema mainly because:
In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?
In OLAP, “Slice and Dice” means:
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
What is meant by 'cardinality' in data modeling?
