What Is The Advantage And Disadvantage Of Sql?


1 Answers

Anonymous Profile
Anonymous answered
Advantages of views:    1. View the data without storing the data into the object.    2. Restrict 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. Restrict the access of a table so that nobody can insert the rows into the table.    Disadvantages:    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.

Answer Question