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
Does sql view stored data?
Show code of a cursor for loop.
What is a primary key called that is made up of more than one field?
What is an ndf file?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
Which is faster subquery or join?
Why we use sql profiler?
What is procedure explain with example?
How to avoid duplicate records in a query?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is the purpose of primary key?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is localdb mssqllocaldb?
Advantages and disadvantages of stored procedure?
How to prepare for oracle pl sql certification?
