Answer Posted / anil_abbireddy
1. data security : complex view can not be modified ie.
base tables cannot be visible.
2. it provides easy way to query data from different data
sources like a single table
3.it is very usefull when developing complex reports basing
on multiple tables.
Is This Answer Correct ? | 38 Yes | 4 No |
Post New Answer View All Answers
Who is the owner of mysql database?
what does it mean to have quoted_identifier on? : Sql dba
Can a commit statement be executed as part of a trigger?
Explain the advantages and disadvantages of stored procedure?
what is self join and what is the requirement of self join? : Sql dba
Mention what does plv msg allows you to do?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
what is data manipulation language? : Sql dba
What is tuple in sql?
What are the advantages of sql?
How to get unique records from a table?
Can you call pl/sql package functions from within a fast formula?
What does bitemporal mean?
I need a function for a train ticket reservation please answer it thanks in advance
What is the difference between left join and right join?