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
What do you understand by index hunting?
How do databases work?
What is the main difference between union and union all?
What do you understand by correlated subqueries in dbms?
What is drivermanager getconnection?
What is a distributed database?
What are the features of dbms?
What are 4 types of models?
What are the parts of a table?
Difference between data and information, and how are they related in a database?
What is rdbms and its features?
What is the difference between case version and decode version?
Define view, sequence and index in DBMS.
Mention a query to calculate the even and odd records from a table
What is a database in business?