How can you tell if an index on particular table is used or not used in 9i?
No Answer is Posted For this Question
Be the First to Post Answer
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
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?
List five most important parameter in 9i affecting performance?
what does the no logging option do? Why would we use it?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
How do you prevent output from coming to the screen?
Which is the best option used to move database from one server to another serve on same network and why?
What does a senior database administrator do?
Why are recursive relationships bad? How do you resolve them?
What is the full form of dba?
What is dba and functionalities of dba?