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 dense_rank?
how to include numeric values in sql statements? : Sql dba
what are wild cards used in database for pattern matching ? : Sql dba
The in operator may be used if you know the exact value you want to return for at least one of the columns.
How to select random rows from a table?
What is integrity in sql?
How delete a row in sql?
What are the different types of dbmss?
What is file based approach?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
how to increment dates by 1 in mysql? : Sql dba
How many commands are there in sql?
What are operators available in sql?
What is equi join in sql?
What is oracle and pl sql?
