What is view is it possible to create index on view on view & how ? -

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

DETAILS

Question: What is view is it possible to create index on view on view & how ?

Answer:

Category	Database Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 7691 users
Added on	5/20/2013
Views	69104
Rate it!

Question: What is view is it possible to create index on view on view & how ?

Answer:

Source: CoolInterview.com

A view may be thought of as a virtual table,ie., a table that does not really exist in its own right but is instead derived from one or more underlying base tables.
In other words , there is no stored file that represents the view instead a definition of view is stored in data dictionary. Source: CoolInterview.com

Answered by: satya | Date: 8/24/2008 |

Contact satya

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is row changing how u eliminate ?	View Answer
	How we determine index require rebuilding ?	View Answer
	How we determine index require rebuilding ?	View Answer
	Your query return 80 % data from table is it we use index or not why ?	View Answer
	How you can determine query use full table scan?	View Answer
	I don't set user dump test parameter where trace file default store on linux platform.	View Answer
	where is trace file generate & when this is create .	View Answer
	How you implement trace of query when user run query what is syntax ?	View Answer
	If a user complaint his query run slow how u detre mine which is reason ?	View Answer
	Which files of unix or linux use or configure in oracle installation ?	View Answer
	If i create unquie index on empid of employees table which index i create bitmap or btree why ?	View Answer
	How data store in bitmap & btree index what is benefit ?	View Answer
	what type of indexes?	View Answer
	How sga use if i execute select * from emp where empid=111;	View Answer
	Is it possible we can define the path of control file backup by creating a text tarce file default where this is store ?	View Answer
	Why are we not use tablespce begin backup with read only tablespace?	View Answer
	Is it same we set log_archive _start =true or alter system archive log start if u use any one then automatic archive ing start or not ?	View Answer
	User say your database is slow how you solve this how identified reasons ?	View Answer
	what is listner how u can change default name & port	View Answer
	What is standard parameter at database creation?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Database Interview Questions & Answers - Exam Mode / Learning Mode