Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of creating view is sql server 2000
- 13 Answers
- 21708 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar.t
1. View is logical representation of the table.
2. View is derived from the table.
3. view don't occupy any memory space.
purpose.
1. Security
2. Simplicity of the query.
Another Important Point : view is updatble.
By
Kumar.T
| Is This Answer Correct ? | 17 Yes | 3 No |
Answer / sundaresan
Views are used to select particular columns from a table
which is residing in a different DB. Once views are
crerated we can access the view to get the specified column
details from the table which is present in a different DB
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / nithya.r
A view is a virtual table. A view serves as a security
mechanism. If we have several tables in a database and we
want to view only specific columns from specific tables we
can go for views. Using view we can avoid the complex
queries.
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / vijayabhaskarreddy
view eassy to use , views used to work with part of the
tables.
** provides security for the data.
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / thirumal
View is used to fetches the data from existing table and it
doesn't occupy any space in memory.
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / reddi
a view is a database object, that contains no data of its own.
it's used for to hide some confidential information.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / parmanand
Not all the views are updatable. updatable viwes are
available from SQL Sever 2000 version.
Pls remember all the views are not up datable again.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Answer / veena
Views can reduce the complexity of database schema
Veiw can provide column level and row level security
By using views present aggregated data and hide detailed data
| Is This Answer Correct ? | 0 Yes | 0 No |
What is WITH CHECK OPTION
3 Answers Karur Vysya Bank KVB,
Can Having clause be used without Group by clause?
6 Answers CarrizalSoft Technologies, CSC, CTS,
What is a Lock and let me know Different types of locks?
What are the differences between stored procedure and functions in SQL Server 2000?
25 Answers College School Exams Tests, HCL, Infosys, TCS,
What is the difference between SSAS 2000 and SSAS 2005?
What is the default schema of your login session in ms sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
how to delete duplicate rows from table
What is the difference between char, varchar and nvarchar?
what's the maximum size of a row? : Sql server database administration
What is difference between rollback immediate and with no_wait during alter database?
How would you choose between a clustered and a non-clustered index?
-
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)
