What is explain plan and how is it used?
No Answer is Posted For this Question
Be the First to Post Answer
What are the important tasks of common oracle dba?
How do you put database is archivelog mode, explain procedure?
How many types of dba are there?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
How can you tell if an index on particular table is used or not used in 9i?
How can you determine if an oracle instance is up from the operating system level?
How can you find dead processes?
You have taken a manual backup of a datafile using os. How rman will know about it?
What skills should a dba have?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
Why are recursive relationships bad? How do you resolve them?