INTERVIEW QUESTIONS ORACLE CONCEPTS AND ARCHITECTURE DETAILS

Question: What is a View ?

Answer: A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.) Source: CoolInterview.com

A view is based on a table or another view and acts as a window through which data on tables can be viewed or changed. A view does not contain data. The definition of the view is stored in the data dictionary. You can see definition of view in user_view data dictionary table.
more view options are... these..
> can be simple view, based on one table
> can be a complex view based on more than one table or can contain groups of functi.ons
>can replace other view with same name
>can contain a check constraint
> can be read-only Source: CoolInterview.com

view is a Database object that which describes the definition of the table. Advantages of view are
1.Hide the data
2.Provide security to the data. Source: CoolInterview.com

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.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question