Answer Posted / santosh kumar
Hi,
Advantages of views:
1. View the data without storing the data into the object.
2. Restict the view of a table i.e. can hide some of columns in the tables.
3. Join two or more tables and show it as one object to user.
4. Restict the access of a table so that nobody can insert the rows into the table.
Disadvatages:
1. Can not use DML operations on this.
2. When table is dropped view becomes inactive.. it depends on the table objects.
3. It is an object, so it occupies space.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is java sql drivermanager?
define join and explain different type of joins? : Sql dba
What is the difference between a database and a relational database?
Why use stored procedures?
How do I debug a stored procedure?
What is pivot table in sql?
What is trigger explain it?
What is pl sql commands?
What are all the common sql functions?
Why having clause is used in sql?
Difference between global and parameter variables?
What is the most common sql injection tool?
How to run pl sql program in mysql?
What is sql analyzer?
Name the different types of indexes in sql and define them.
