Interested to Buy Any Domain ? << Click Here >> for more details...
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 difference between mysql and postgresql?
What is pl sql in dbms?
What is synchronized subquery?
What is an exception in pl/sql?
How do I run sql profiler?
Is left join faster than inner join?
What is an emotional trigger?
What is delimiter sql?
What does over partition by mean in sql?
what is meant by nl2br()? : Sql dba
Which function is used to return remainder in a division operator in sql?
Who developed sql?
What are pl sql data types?
What are the advantages of sql? Explain
Can I create table without primary key?
