Implementing Views: Query Modification vs. Base Tables

Difficulty in understanding the modified query

Increased security vulnerabilities

Incompatibility with certain types of databases

Inefficiency for views defined via complex queries (correct)

It is replaced with a new query

It is converted into a stored procedure

It is modified into a query on the underlying base tables (correct)

It is executed directly without modification

UPDATE Manager SET Salary = Salary + 10000

DELETE FROM Employee WHERE Salary < 50000

INSERT INTO Department (Dnumber, Dname) VALUES (5, 'Sales')

SELECT Fname, Lname, Dname, Dnumber, Salary FROM EMPLOYEE, DEPARTMENT WHERE SSN=MgrSSN AND Salary > 100000 (correct)

<p>Modifying the view query into a query on the underlying base tables</p> Signup and view all the answers