Whether the updations made to the views reflect the
original records in the table
- 5 Answers
- 8378 Views
- NIIT, I also Faced
- E-Mail Answers
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
How to list all columns in a table using odbc_columns()?
What are distinctive joins find as a part of sql?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What do you understand by a view? What does the with check option clause for a view do?
How do triggers work?
Why are you getting errors when creating a new odbc dsn?
What do you understand by a stored procedure?
How global temporary tables are represented and its scope?
How to insert a new row into a table with "insert into" statements in ms sql server?
How you can minimize the deadlock situation?
What is shared lock?
What does it mean to normalize data?
What is the use of =,==,=== operators?
How to get a list of all tables with "sys.tables" view in ms sql server?
Can we use pragma autonomous_transaction in trigger?
