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
Which command is used to call a stored procedure?
What is primary and foreign key?
Why sql query is slow?
What are the different types of joins in sql?
How to place comments in pl/sql?
how many ways to get the current time? : Sql dba
How to start the command-line sql*plus?
What are the advantages of indexing?
How do you take the union of two tables in sql?
What do you mean by rowid?
What is a rank in sql?
What are variables in pl sql?
Is keyword pl sql?
what is the syntax for using sql_variant_property? : Transact sql
What do you understand by pl/sql cursors?
