Debjani

• Aug 25th, 2005

 

A. You can create an index on views

jyomuk

 Profile Answers by jyomuk 

• Mar 8th, 2006

 

ANS: D. Views can be dropped without dropping tables

Sujana

• May 26th, 2006

 

A. You can create an index on views

is the right answer since views are not permanent tables ,indexes cant be created on them

raksha

• Jul 9th, 2006

 

Hey Guys,

Please make sure the answer is correct before posting it.

We can create an index on views. In Oracle these are called materialized views and these have been lately added in SQL Server 2000.

Raksha.

Madhuri

• Aug 20th, 2006

 

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.

radha

• Sep 10th, 2006

 

please read the question again,answers seems right if its true condition but the question is using word "not true'"

Thanx

siva ram

• Sep 13th, 2006

 

 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

mates04

 Profile Answers by mates04 

• May 5th, 2008

 

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..

henzchen

 Profile Answers by henzchen 

• Mar 15th, 2010

 

A. You cannot create an index on a view.