Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vinay dixit
please find the advantages as given below :-
a) data security - no need to give permission on the table,
infact a view can be created, having only selected number
of coloums in its definition. So user will only be able to
see those coloums.
b) simplicity - a very complicated query can be saved as a
view defenition. when needed can be called by its view name.
c) removes dependency - Can be very helpful to remove the
dependecny from the underlying tables. Suppose a view is
created by joining several tables. After some time, there
are some changes on the tables, so only defenition of view
can be changed and there is no need to change all the code
where view is used.
d) No space - takes no space ( except materialized view )
| Is This Answer Correct ? | 61 Yes | 4 No |
Post New Answer View All Answers
What is a record in a database?
Do we need to create index on primary key?
Enlist the characteristics of pl/sql?
What is normalization in sql?
What is autocommit sql?
Whis is not false in primary key?
how is myisam table stored? : Sql dba
How do you write a complex sql query?
Why we use stored procedure instead of query?
what is a table in a database ? : Sql dba
Is sql scripting language?
what is oltp (online transaction processing)? : Sql dba
what are different types of keys in sql?
Explain spool.
What is left join in postgresql?
