You are running a cartisian query, typically by mistake. Make sure every table has a join criteria specified for it.
You are working on a table with 100+million rows.
The database server is busy doing a backup.
Check the disk IO for the process that appears hung and if the disk IO is increasing every 5-10 seconds then the job is not hung, it is just taking a while to complete.
Explain Difference between procedure and function.?
Explain Which datatype is used for storing graphics and images?
Explain Difference between an implicit and an explicit cursor?
Explain ROWID?
Please Explain Connect by Prior?
Explain What is a database link?
Explain Explicit Cursor attributes?
Explain What is a corelated subquery?
Explain How to drop the index?
What is a join in Oracle? Explain the different types of joins?
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
