Fitelo Interview Questions and Answers

To reduce air pollution in NCR, data on sources of pollution, weather patterns, and population density is needed.

• Sources of pollution such as industries, vehicles, and construction sites

• Weather patterns such as wind direction and speed, temperature, and humidity

• Population density and distribution to identify areas with high pollution levels

• Data on emissions from power plants and factories

• Information on the types of vehicles and their emissions

• Data on the use of alternative mo...read more

Dimensions are attributes used to group data while measures are numerical values used to perform calculations.

• Dimensions are qualitative data while measures are quantitative data.

• Dimensions are used for slicing and dicing data while measures are used for analysis and calculations.

• Examples of dimensions include date, location, and product while examples of measures include sales, profit, and quantity.

• Dimensions are often used as filters while measures are used in charts and gr...read more

Drop, delete and truncate are SQL commands used to remove data from a table.

• DROP command removes the entire table and its data

• DELETE command removes specific rows from the table

• TRUNCATE command removes all the data from the table