Question
In a certain code language, ‘HAND’ is coded as 18 and
‘TREE’ is coded as 10. How will ‘COLD’ be coded in that language?Solution
The words are coded as the sum of the positional values of the 3rd and 4th letters from the left as per the English alphabetical series.
HAND → 18
3rd letter N = 14
4th letter D = 4
Code = 14 + 4 = 18
TREE → 10
3rd letter E = 5
4th letter E = 5
Code = 5 + 5 = 10
COLD → ?
3rd letter L = 12
4th letter D = 4
Code = 12 + 4 = 16
Which SQL function returns the total number of rows in a table?
Which OLAP operation allows drilling down into more detailed data?
A star schema in a data warehouse consists of:
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Which of the following is used to maintain information about the structure of a data warehouse?
A snowflake schema differs from a star schema mainly because:
Which SQL clause is used to summarize data?
A Fact Constellation Schema is also called:
In a data warehouse, a fact table typically contains:
Which schema uses multiple fact tables sharing dimension tables?
