Do you need a commit after ddl statements?
No Answer is Posted For this Question
Be the First to Post Answer
What is the easiest method to create a file on unix?
What file will give you oracle instance status information? Where is it located?
What happens if the constraint name is left out of a constraint clause?
When should you increase copy latches?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What are the five functions of a database?
How can you determine if an oracle instance is up from the operating system level?
What command is used to type files to the screen?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
List five most important parameter in 9i affecting performance?
What are the different responsibilities of a dba?