GeekInterview.com
Series: Subject: Topic:
Question: 102 of 111

What is view? Types of views?use of views?how to create view(syntax)?

Asked by: Interview Candidate | Asked on: Jan 27th, 2006
Showing Answers 1 - 8 of 8 Answers
DIPTENDU HUI

Answered On : Jan 28th, 2006

1. View is nothing but parsed SQL statement which fetches record at the time of execution.2.There are mainly two type of viewsa) Simple Viewb) Complex Viewapart from that we can also subdivided views as UpdatableViews and Read only Views.Lastly there is an another view named as Materialized Views.3. View is used for the purposes as stated below:a) Securityb) Faster Responsec) Complex Query solve4.Syntax is :Create or replace view([olumn1],[column2]...)asSelect column1,column2...from table_name[where condition][with read only],[with check option]

  
Login to rate this answer.
Brajendra Nath Vimal

Answered On : Mar 5th, 2006

View:- View is the vertual or logical or the duplicate copy of the original table with schema parts only.Types Of Views:- i)Readable Viewii) Updatable ViewCreation of view:- Syntax:- Create view As Select A1,A2,.........,An From T1,T2,.............,Tn Where

  
Login to rate this answer.
sreyaskvmce&it

Answered On : Mar 18th, 2006

View all answers by sreyaskvmce&it

A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words, there is no stored file that direct represents the view instead a definition of view is stored in data dictionary.
Growth and restructuring of base tables is not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.

There are two type of views:

1,simple view

2,complex view

  
Login to rate this answer.

A view is a virtual table whose contents are defined by a query.As per sql server 2005 we can create standard,indexed and partitioned views.

  
Login to rate this answer.
srvardhan

Answered On : Nov 29th, 2007

View all answers by srvardhan

The dynamic result of one or more relational operations operating on base relations to produce new relation.creating view: create view View_Name as select query.Basically we use views for 1. to reduce the complexity in writing queries  --> go with view resolution2. To improve performance --> go with materializing view  (remember if the frequency of executing select query is more than the frequency of updating then only go with this) Rajavardhan Sarkapally

  
Login to rate this answer.

View: A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or more tables.Types of Views: a)
DataBase View b) Help View c) Projection View d) Maintenance View
Use of viewsA view provides the mechanism to hide certain data from the view of certain users.
Syntax:use XXX (your database name)GOCREATE VIEW view1(view name)ASSELECT ------------------------(your query)-----------------

  
Login to rate this answer.
sachinbbau

Answered On : Feb 1st, 2011

View all answers by sachinbbau

A view is a virtual table, which provides access to a subset of columns from one or more tables. It is a query stored as an object in the database, which does not have its own data.

  
Login to rate this answer.
raman sharma

Answered On : Mar 2nd, 2012

View is called a temporarily table when we want to create the copy of any table as requirement column then we use the view

syntax-------------
create view (view name) as select (* or column name) from (table name);

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Btrieve Interview Questions

Clipper Interview Questions

Database Admin Interview Questions

Firebird Interview Questions

Informix Interview Questions

Microsoft Access Interview Questions

MYSQL Interview Questions

PostgreSQL Interview Questions

Progress Interview Questions

SAP DB Interview Questions

SQL Interview Questions

SQL Server Interview Questions

Stored Procedures Interview Questions

Sybase Interview Questions

Teradata Interview Questions

Unify Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.