Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amadur
If we have several tables in a DB and we want to view only
specific columns from specific tables we can go for
views.It would also suffice the needs of security sometimes
allowing specific users to see only specific columns based
on the permission that we can configure on the view. Views
also reduce the effort that is required for writing queries
to access specific columns every time
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give the advantages and disadvantages of clusters.
Can we save images in a database and if yes, how?
What suggestions do you have to reduce the network traffic?
What are the different types of trigger and explain its various uses and functions?
What is the difference between sharding and replication?
What is a oracle database?
How would you begin to troubleshoot an ORA-3113 error?
What is the difference between a primary key & a unique key?
Explain the different normalization forms?
How to use "if" statements on multiple conditions?
6. Display the client name and order date for all orders using the traditional method.
What happens to the indexes if a table is recovered?
What are a query and state the different types of queries and their uses?
How to write date and time interval literals in oracle?
How to invoke the data pump export utility?
