olap and sql queries

MCQsQuestion.com has 2 Question/Answers about Topic olap and sql queries

Recursive SQL queries are used to express transitive closure which uses

Recursive SQL queries are used to express transitive closure which uses
  • A. Recursive views
  • B. Nonrecursive views
  • C. Domain views
  • D. General views
  • Correct Answer: Option A

For formation of grouping needed for OLAP, SQL includes

For formation of grouping needed for OLAP, SQL includes
  • A. Routines
  • B. Functions
  • C. Subtotals
  • D. Modules
  • Correct Answer: Option B