What is a View ? Can we insert, Update and delete a view?
- 1 Answers
- 1101 Views
- Arigo Infotech, I also Faced
- E-Mail Answers
Answer Posted / Sanjay Rathour
A view is a virtual table based on the result-set of an SQL statement. It does not store data itself but provides a simplified and secured way to query data from one or more tables. A view can be used to restrict access to specific columns, hide sensitive data, improve readability, and simplify complex queries. Views cannot be directly inserted, updated, or deleted because they do not contain actual data. However, you can perform these operations on the base table(s) underlying the view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Where can you add custom error messages to sql server?
What are the kinds of subquery?
What is temporary table in sql server? Why we use temp table?
What is the difference between for xml raw and for xml auto?
How raid can influence database performance?
Why and when do stored procedure recompile?
Explain “row_number()” in sql server with an example?
How can we solve concurrency problems?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How to provide default values to function parameters?
Disadvantages of the indexes?
What are the source of constraints?
What is standby servers? Explain types of standby servers.
What is in place upgrade in sql server?
