What is a view? is View updatable?

Answer Posted / sai krishna.k

a view is nothing but a logical representation of tables.
it is also called as "virtual table".
a view may be updatable view or non updatable view.

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

806


Explain having clause?

727


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

708


What is set nocount on and what is set nocount off?

666


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

665






What is stretch database in sql server?

761


What is replication with database mirroring? : sql server database administration

701


How do I find the transaction log size in sql server?

684


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

694


Explain identity in sql server?

721


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

751


What are the properties of the transactions?

813


Define Wed Edition in SQL Azure?

92


What is transactional replication?

712


What are the differences between left join and inner join in sql server?

770