Question
In which year was the Sagarmala Project launched by the
Government of India to enhance the performance of the country's logistics sector?Solution
Initiated in 2015, the Sagarmala Project aims to leverage India's coastline and waterways to improve the logistics sector, thus reducing costs and boosting efficiency.
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?
Relevant for Exams:
