Answer Posted / fam
a view can be thought as either a store query or a virtual table,store query coz in db only select statement is store and virtual table coz it perfilter the underlying table.
it is updatable in case of simple view and it is non updatable in the case of complex view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain Geography datatype in SQL Server
What do you understand by integration services in sql server?
What does indexation mean?
Define full outer join?
What is model database? : SQL Server Architecture
How exceptions can be handled in sql server programming?
What is the security principal at the database level that represents your session?
What are the Advantages of using CTE in sql server?
Is mysql the same as sql server?
What are the restrictions that views have to follow?
What is subquery? Explain the properties of a subquery?
What is difference between order by and group by?
What is 1nf normalization form?
How many instances per computer are there in sql server 2000?
Define model database?