Whether the updations made to the views reflect the
original records in the table
Answers were Sorted based on User's Feedback
Answer / sabareetha
If the view is created with single table. Updating a view
will affect the origival records in the table
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / 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 |
Answer / soorai ganesh
No. Updating View will not affect the table records.
| Is This Answer Correct ? | 9 Yes | 13 No |
Why do we partition data?
What are the types of lock supported by ?
What is the difference between primary key and unique constraints?
Can we return Data from 4(more than 1) tables in stored procedure?
can we call functions from stored procedure in SQL Server 2005 ? How?
What are the disadvantages of indexes?
What are synonyms?
What are the steps you will take to improve the performance of a poor performing query?
List the different types of joins?
What do you mean by an execution plan? Why is it used?
List some of the rules that apply to creating and using a ‘view’
What is sub-query in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)