Views Flashcards
1
Q
What is a View?
A
A virtual table that does not physically exist
2
Q
What is the syntax for creating a view?
A
CREATE VIEW view_name AS
SELECT columns
FROM tables
[WHERE conditions];
3
Q
What happens when you update the data in a view?
A
The records in the underlying tables are updated
4
Q
Does the Oracle View exist if the table is dropped from the database?
A
Yes, however youll get an error if you try to query the view when the table is dropped
5
Q
What is the type of trigger that can only be attached to views?
A
Instead of Triggers
6
Q
What is an Instead of Trigger
A
A trigger attached to views that is run instead of the DML statement that caused the trigger to fire
