Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 22093 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / mehtab ullah
Purpose of view
Views hide data complexity.
Views add security by restricting access to the columns of a
table.
Views simplify the complex queries for the user.
View is a way to isolate application from changes in
definitions of base tables.
View is derived from the perant table.
View do not occupy any space in the memory .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is your recommendation for a query running very slow? : sql server database administration
How to assign null values to variables or columns?
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
Do you know what is user defined datatypes and when you should go for them?
Can two different columns be merged into single column? Show practically?
What is stored procedures?
Define self join in sql server joins?
How to implement service broker?
How to resolve the orphan use problem? : sql server security
What is the difference between push and pull subscription? : sql server replication
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Explain database normalization?
What happens if we shrink log file in sql server?
what data regions are and what are the different data regions?
Is it important for a database administrator to understand the operating system and file access?
