Explain different types of Views ?

Answer Posted / sweta

There are two types of view-
1.Simple view(does not contain function, only one table exists,allow DML operation)
2.Complex View (Allow function,multiple table,did not allow DML operations all time)

Attributes of view --
1.with check option
2.read only
3.Force|Noforce

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bcnf in the dbms?

510


How is foreign key commands related to primary key?

449


How to monitor firebird server activity?

542


What is database partition key?

484


Write down the differences between nosql and rdbms?

527






Have you written applications to retrieve stored images in a table?

607


What is the purpose of queries in a database?

543


What is natural key?

543


What are the differences between a dbms and rdbms?

470


How do you exit a database?

490


What is drivermanager getconnection?

613


What does you mean by s4 super key?

569


What is the advantages and disadvantages of database management system?

439


What do you understand by data independence?

566


What is sorting in dbms?

513