if i perform any operation on views such as insert, delete
etc will my base table get affected?????
Answer Posted / ramesh
yes if it is simple view. error if it is compunt view
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Explain what is a field in a database and record in a database?
what is a composite primary key ? : Sql dba
what is sp_pkeys? : Transact sql
What are the types of functions in sql?
what is acid property in database? : Sql dba
What is view? Can we update view
what is query cache in mysql? : Sql dba
What are the types of views in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are stored procedures in mysql?
Is full outer join same as cross join?
What are different types of sql commands?
List different type of expressions with the example.
Will truncate release space?
What is sql query limit?