📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • ✖

      Question

      A materialized view differs from a normal view because

      it:
      A Executes only in-memory Correct Answer Incorrect Answer
      B Stores results physically for faster access Correct Answer Incorrect Answer
      C Cannot be refreshed Correct Answer Incorrect Answer
      D Does not support joins Correct Answer Incorrect Answer
      E Ignores indexes Correct Answer Incorrect Answer

      Solution

      Materialized views store precomputed results physically and can be refreshed, unlike logical views.

      Practice Next
      More SQL Questions
      ask-question