Question
What is the result of SELECT COALESCE(NULL, NULL, 5,
10);?Solution
COALESCE returns the first non-NULL value among its arguments.
More Data Warehousing Questions
Which of the following best describes a fact constellation schema in a data warehouse?
Which of these is NOT an ensemble method?
A star schema in a data warehouse consists of:
Which of the following is a real-time data warehouse application?
A snowflake schema is different from a star schema because:
A surrogate key is:
Which schema uses multiple fact tables sharing dimension tables?
ETL stands for:
Which type of OLAP allows operations on pre-aggregated data cubes?
Which of the following best describes the primary function of a database index?
