Question: Consider a materialized view create materialized view Vas select name from Student where name in (select name from Registers where course = Database Systems-I') on

Consider a materialized view create materialized view Vas select name from Student where name in (select name from Registers where course = Database Systems-I') on the following tables: Student(name,regno,contactno) Registers(name,course, semester) For each of the following modifications, would it cause a change to V? i. update to Student.contactno ii. deletion from Registers iii. update to Registers.semester iv. insertion into Student v. update to Registers.course
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
