Interested to Buy Any Domain ? << Click Here >> for more details...
What is the differnce between view and materialized view
- 4 Answers
- 9042 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / papia
view does not contain actual data but MV contains data.MV
needs to be refereshed after a particular interval.Bit when
a view is queried it actually queries the underlying tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain 3 basic parts of a trigger.
what is isam? : Sql dba
Why do we use sqlite?
What is function and procedure in pl sql?
What steps server process has to take to execute an update statement?
What is a column in a table?
how can you see all indexes defined for a table? : Sql dba
Why do we use %rowtype & %type in plsql?
Is nosql faster than sql?
what are local and global variables and their differences? : Sql dba
what is acid property in database? : Sql dba
what is the difference between where clause and having clause? : Sql dba
Show the cursor attributes of pl/sql.
What language is oracle sql developer?
What do you mean by dbms? What are its different types?
