A simple snapshot is based on a query that does not
contains GROUP BY clauses, CONNECT BY clauses, JOINs,
sub-query or snashot of operations.
- A complex snapshots contain atleast any one of the above.
What is the function of Lock (LCKn) Process in System Architecture?
Tell me how many Dispatcher Processes are created?
What is database security? How will you use it?
What is PGA?
Tell me what do Database Buffers contain?
Explain what is SGA? Where it is located? Why the system performance will be slow after loading the oracle?
Why is Oracle called kernel package?
Tell me what are the components of SGA?
What is a cluster and how it is used?
What is the approach taken by Oracle to pass ACID test of a database transaction?
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
