Explain different types of Views ?
- 5 Answers
- 35093 Views
- HCL, Inbound Solutions, I also Faced
- E-Mail Answers
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
How to select a random record from a table?
What is system catalog or catalog relation?
what are the acid properties in dbms?
Explain a join between tables?
Explain by listing some of dbms major advantages.
Can files be stored in a database?
Explain the main control blocks available in ims db?
What is optimization in database?
Who proposed the relational model?
What do you understand by sub-queries in sql?
What is a foreign key constraint?
What is the best database management system?
What is indexing in database with example?
What database should I learn first?
Explain the different types of languages that are available in the dbms?
