Difference between views and materialized views?
- 5 Answers
- 21227 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / rahul khanke
views : this are the vertiual table.. views dosent stores
the data.. if we update the table then updation is in
actual table..
M view : this are the tables based on one or more tables..
this stores the data.. updation is done then actual
updation is in M. view itself..
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is cursor explain with example?
Which software is used for pl sql programming?
What is difference between left and right outer join?
What is output spooling in sql*plus?
How do you optimize a stored procedure in sql?
What kind of join is join?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
how would concatenate strings in mysql? : Sql dba
Explain the working of primary key?
Which command is used to delete a trigger?
What is trigger in pl sql with examples?
What is sorting in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How can you fetch first 5 characters of the string?
How do I install microsoft sql?
