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
what is a self join? Explain it with an example? : Sql server database administration
How to create stored procedures with parameters in ms sql server?
What do you do in data exploration
Explain data warehousing in sql server?
Explain how would you store your query in an SSRS report or a Database server?
What the class forname () does?
What are trace flags?
How are the exceptions handled in sql server programming?
Can two tables share the same primary key?
What are triggers? How do you invoke a trigger on demand?
How to find Duplicate Records In table?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is database dimension? : sql server analysis services, ssas
How optimize sql query with multiple joins in sql server?
How you can find out if an index is useful to the optimizer?