what is difference between table and view? where to use views?
thanks in advance!
Answer / 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 |
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
what is the syntax of CREATE command?
Explain the use of full option in exp command.
what is grid in Oracle 10g...
How to remove a row in a database table?
what are the differen between key flexifild and discriptive fiexifild.
What is an index associated with a constraint?
Display the number value in Words?
State some uses of redo log files?
What is a Segment ?
What is a data dictionary and how can it be created?