What is view in sql?



What is view in sql?..

Answer / Gaurav Kumar

In SQL, a view is a virtual table based on the result-set of an SQL statement. It contains rows and columns, just like a real table. However, it does not store data physically. Instead, it is used to improve query performance by storing the SELECT statement that defines the view.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what is the difference between sql query and google query?

10 Answers   TCS,


What is the Disadvantage of indexed sequential file.

1 Answers   HCL,


What are the difference between primary keys and foreign keys?

1 Answers  


what are the Prerequisites for Replication?

2 Answers   IBM,


What is dimension table? : sql server analysis services, ssas

1 Answers  


Why we need sql server?

1 Answers  


What is the difference between functions and scalar functions?

1 Answers   EXL,


Can sql servers linked to other servers?

1 Answers  


What is Outter Join?

1 Answers  


Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,


can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  


How you provide security to cube? : sql server analysis services, ssas

1 Answers  


Categories