Which of the following statements is not true about views?
A. You can create an index on views B. Views do not have permanent data C. Views can be based on one or more tables D. Views can be dropped without dropping tables
RE: Which of the following statements is not true abou...
The answer is correct.
Views are different from Materialized views.
A view is a stored query or a virtual table. Unlike a table a view is not allocated any storage space nor does a view actually contain data. A view requires no storage other than storage for the definition of the view (the stored query) in the data dictionary.
Materialized views are schema objects that can be used to summarize compute replicate and distribute data. A materialized view creates a real table requires storage space and this 'table' may be indexed analyzed and so on.
RE: Which of the following statements is not true abou...
hi this is siva ram(OCP).the correct answer is b and rest of them are wrong(accordind to the question(which is not true))........................bye............than q
RE: Which of the following statements is not true about views?A. You can create an index on viewsB. Views do not have permanent dataC. Views can be based on one or more tablesD. Views can be dropped without dropping tables
All the answers mentioned above are true. This Question was posted long back at that point of time indexing was not possible in view. Now in SQL Server 2000 and Oracle latest versions its posible..
0 
1