SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1040 Page Views: 

What is meant by View?



Posted By: Avi Date: 1 October 2010 12:12:08 PM
 Answer:

In a datbase there are sevral tables and if you want to view some specific fields from multiple tables a VIEW is created for that. So view is a virtual table which does not exist physically and its contents are defined by a quaery. It is like a table having fields whose dat is retrieved by q query refrencing a table. Views can be generated for multiple tables by joining them. VIEWS are not stored physically in memory but are generated dynamically when are accessed. Syntax For Ceating a View:- CREATE VIEW view_name AS SELECT columns FROM table_name WHERE predicates


Posted By: avibtech

Date: 1 October 2010 12:12:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image sBHmT9
Related Questions
SQL Server : Do you think that it is compulsory to delete duplicate rows in a table with the help of temporary table only?

Do you think that it is compulsory to delete duplicate rows in a table with the help of temporary ta....

No,Temporary table is not compulsory.It can be deleted without craeting temporary table by using ROW....
Category: SQL Server Date: 10/1/2010 11:47:07 AM
SQL Server : What is SQL Job and what are its uses?

What is SQL Job and what are its uses?

SQL Job is set of specified operations set on server to be performed sequentially and automatically.....
Category: SQL Server Date: 10/1/2010 11:45:07 AM
SQL Server : Is it possible to create a Primary Key and Unique Key on Computed columns?

Is it possible to create a Primary Key and Unique Key on Computed columns?

Yes, it is possible to create a Primary ke and unique key on computed columns. In case of Unique key....
Category: SQL Server Date: 10/1/2010 11:44:07 AM
SQL Server : What is the basic concept of Serialization?

What is the basic concept of Serialization?

Serialization is the highest level of isolation. When Serialization is implemented then there will b....
Category: SQL Server Date: 10/1/2010 11:43:07 AM
SQL Server : Write the query to Select the name of the product whose total sales is 20 form the following table named sales:- PID Pname Sale 1 Soap 5 2 Brush 10 3 Tea 8 1 Soap 12 2 Brush 5

Write the query to Select the name of the product whose total sales is 20 form the following table n....

select Pname from sales group by PID having sum(sale)=130
Category: SQL Server Date: 10/1/2010 11:42:07 AM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories