Explain different types of Views ?
- 5 Answers
- 34497 Views
- HCL, Inbound Solutions, I also Faced
- E-Mail Answers
Answer Posted / 9742108000(venu gopal reddy)
The views are Mainly 2 types .
1-> SIMPLE VIEW
2-> COMPLEX VIEW
Simple view:
- It is created by selecting only one table.
- It does not contains functions.
- it can perform DML (SELECT,INSERT,UPDATE,DELETE,MERGE, CALL,LOCK TABLE) operations through simple view.
Complex view :
-It is created by selecting more than one table.
-It can performs functions.
-You can not perform always DML operations through Complex views.
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
What is a table called in database?
What is a join in the sql?
Explain the difference between a dynamic and materialized view.
Explain what are tp-lite and tp-heavy monitors?
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
What is the difference between a catalog and a database?
What is dbms and types of dbms?
What is the largest component of a database?
Which is the most used database?
does pl/sql support “overloading”? Explain
What are queries in dbms?
What is data sublanguage?
Why not phenix, the zelinka/otwinoski libraries, etc?
What is in a database?
What is built_in Subprogram ?
