You want to create an updatable view that joins employees and departments but still allows updates to employee names. Which approach is correct?

hard📝 Application Q8 of 15

PostgreSQL - Views and Materialized Views

ACreate a materialized view instead of a regular view.

BCreate a simple view on employees only and ignore departments.

CUse GROUP BY in the view to aggregate department data.

DCreate the view with JOIN and add INSTEAD OF triggers to handle updates.

Step-by-Step Solution

Solution:

Step 1: Understand join view limitations
Views with JOINs are not updatable by default in PostgreSQL.
Step 2: Use triggers to enable updates
Adding INSTEAD OF triggers allows custom update logic on join views.
Final Answer:
Create the view with JOIN and add INSTEAD OF triggers to handle updates. -> Option D
Quick Check:
JOIN + triggers = updatable view [OK]

Quick Trick: Use INSTEAD OF triggers to update join views [OK]

Common Mistakes:

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free