Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / satish asnani
Simple and complex views do not occupy HD space. The data
remains with the base table and views are just stored
queries which fetch data from base tables. But Materialized
Views maintain a copy of the records in their own space.
That is Materialized views as name suggests store a local
copy of the records from base tables and definitely occupy
HD space.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define union, minus, union all, intersect ?
What is primary key and foreign key with example?
Is keyword pl sql?
What is composite primary key in sql?
Can we call a function containing dml statements in a select query?
What is the use of non clustered index?
What is the syntax to add a record to a table?
Explain what is sql?
What are the triggers associated with image items?
What is the use of double ampersand (&&) in sql queries? Give an example
How can triggers be used for the table auditing?
What does (+) mean in sql joins?
What is record data type?
Is mariadb nosql?
Why use truncate instead of delete?
