📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

  • google app store apple app store
  • âś–

      Question

      Which SQL feature allows hierarchical queries (e.g., org

      chart traversal)?
      A Window functions Correct Answer Incorrect Answer
      B Recursive CTEs Correct Answer Incorrect Answer
      C Views Correct Answer Incorrect Answer
      D Nested subqueries Correct Answer Incorrect Answer
      E Triggers Correct Answer Incorrect Answer

      Solution

      Recursive Common Table Expressions (WITH RECURSIVE) enable hierarchical traversal.

      Practice Next
      ask-question