Materialized view is a view in wich data is also stored in some temp table.i.e if we will go with the View concept in DB in that we only store query and once we call View it extract data from DB.But In materialized View data is stored in some temp tables.
In a Distributed Database System Can we execute two queries simultaneously? Justify?
How we can create a table in PL/SQL block. insert records into it? is it possible by some procedure or function? please give example?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
State the difference between implict and explict cursors?
How to know the last executed procedure?
How can a function retun more than one value in oracle with proper example?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is the basic structure of PL/SQL?
What are the components of a PL/SQL block?
What are the datatypes a available in PL/SQL?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
