SQL Server Architecture Question:
Download Job Interview Questions and Answers PDF
What is the difference between CUBE operator and ROLLUP operator?
Answer:
CUBE generates a result set that represents aggregates for all combinations of values in the selected columns.
ROLLUP generates a result set that represents aggregates for a hierarchy of values in the selected columns.
ROLLUP generates a result set that represents aggregates for a hierarchy of values in the selected columns.
Download MS SQL Server Architecture Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Please illustrate physical database architecture? | Do you know what are the restrictions applicable while creating views? |