Question
Select the most appropriate option to substitute the
highlighted segment in the given sentence. If there is no need to substitute it, select ‘No substitution required’. The hotels were heavy booked for the festival in Banaras.Solution
The word "heavily" is an adverb that describes the degree or intensity of the booking, indicating that the hotels were booked to a great extent. Therefore, the correct substitution for the underlined segment is "were heavily booked."
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?