What are the advantages of VIEW?

Answer Posted / pnc

view is a logical presentation of one or more tables. It is
a virtual table. or A view is a data base object to register
the select statement permanently in the data base.

Is This Answer Correct ?    17 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of operators available in sql?

552


how many groups of data types? : Sql dba

567


What is union?

651


What is a natural join?

514


How do you write a subquery?

521






Enlist the characteristics of pl/sql?

1239


How to fix oracle error ora-00942: table or view does not exist

567


What is a unique constraint?

608


What are the two types of exceptions in pl/sql?

544


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

664


Is postgresql a nosql database?

533


What is a relationship and what are they?

579


How much does a sql dba make? : SQL DBA

507


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

685


Explain the working of foreign key?

544