Whether the updations made to the views reflect the
original records in the table
Answer Posted / ravi sharma
in the case if same table (all column) are make a view then
updations reflect the original record in the table.
but mostly make a view to security purpose the , uniques
are constaint column are not use,
then not be reflect .
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Tell me what are cursors and when they are useful?
What does nvl stand for?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Explain four layers of abstraction microsoft architectured?
What is the language structure to add a record to a table?
What is a data source file?
Is it ok to shrink transaction log?
How many joins in sql server?
Can we perform backup restore operation on tempdb?
What is the difference between composite index and covering index?
what is a self join? Explain it with an example? : Sql server database administration
What is partitioned view?
Explain the working of sql privileges?
What are secondary xml indexes?
How to enforce security in sql server? : sql server security