Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 396
|
Emp (eid: integer, ename; string, age; integer, salary; real)
Works (eid; integer, did; integer, pct time; integer)
Dept (did; integer, budget; real, managerid; integer)
CREATE VIEW AvegSalaryByAge (age, avgSalary) AS SELECT E.eid, AVG (E.salary) FROM Emp E GROUP By E age.
|
The above view cannot be updated automatically.
|
|
|
The above view on Emp can be updated automatically by updating Emp
|
|
|
The above view cannot be created automatically.
|
|
|
None of the given options
|
Correct Answer: D