What is difference between co-related sub query and nested sub query?
No Answer is Posted For this Question
Be the First to Post Answer
What are bind variables and why are they important?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What do you mean by dba?
What is da in database?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
What is dump destination? What are bdump, cdump and udump?
How many control files should you have?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
What is tkprof and how is it used?
Why do we need a database?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
How do you set up tablespaces during an oracle installation?