How many control files should you have?
No Answer is Posted For this Question
Be the First to Post Answer
Discuss row chaining, how does it happen? How do you correct it?
How many control files should you have? Where should they be located?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
Which date function is used to find the difference between two dates?
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?
What is a dba why is this position necessary?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
What exactly does a dba do?
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?
How does one create a new database?
What do you understand by the term 'system change number (scn)'?
What happens when the default and temp tablespace clauses are left out from create user statements?