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


    âš¡ Month End Offer - Flat 52% Off On All Courses! Enroll Now âš¡
    00:00:00 AM Left

    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
    ask-question