Question
BCDF is related to EFGI in a certain way based on the
English alphabetical order. In the same way, FGHJ is related to IJKM. To which of the following is NOPR related, following the same logic?Solution
Each letter is shifted forward by 3 places in the alphabet (B→E, C→F, D→G, F→I). N → Q Answer: QRSU .
Apply the same rule to NOPR :
O → R
P → S
R → U
Which SQL clause is used to filter records after aggregation?
A data cube allows analysis by:
In OLAP, “Slice and Dice” means:
Which type of OLAP allows operations on pre-aggregated data cubes?
Which of the following best describes the primary function of a database index?
Which clause is used to sort the results in SQL?
Which type of schema normalizes dimension tables to reduce redundancy?
Metadata in data warehousing refers to:
A snowflake schema is different from a star schema because:
Which of the following is a real-time data warehouse application?