what is difference between table and view? where to use views?
thanks in advance!
Answer Posted / shalini
A table is a collection of data in the form of rows and
columns.
Whereas a View is a virtual table in which data comes from
one or more base tables and is stored as a result of a
predefined query for further use.
Uses of Views:
1.used to improve performance as they are the results of
predefined/complex queries which can be used in other
queries.
2.To provide security by granting permissions to certain
group of people only on the views rather than all the
tables database .ie. hiding sensitive data.
3.To hide complexity of data by showing only the relevant
data need to show to a user rather than confusing a uaser
by showing all the information
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How to connect asp pages to oracle servers?
what is port in oracle? how is it related to database application.
How to start instance with a minimal initialization parameter file?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is an oracle?
Explain the use of tables option in exp command.
How to assign query results to variables?
What is Segment Advisor in Oracle?
Explain alias?
What are the benefits of ordbms?
What is analyze command used for?
What is define in oracle?
What happens to the data files if a tablespace is dropped?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What are the different windows events activated at runtime ?