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 are key constraints?
what is blocking? : Sql server database administration
When would you use sql joins?
What are user-defined functions (udfs) in sql server?
What is reportserver and reportservertempdb ?
What is the distinction amongst delete and truncate?
Define ACID properties in a Database?
what is raid and what are different types of raid configurations? : Sql server database administration
How to select true false based on column value in sql server?
Do I need a report server to run reports in my application?
How can we get count of the number of records in a table?
Explain syntax for dropping triggers?
What is BLOCK statements in SQL?
What is policy management?
What are the requirements to use odbc connections in php scripts?