What happens when the default and temp tablespace clauses are left out from create user statements?
No Answer is Posted For this Question
Be the First to Post Answer
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
What is the difference between sga and pga?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
As an oracle dba what are the entire unix file you should be familiar with?
How do you use automatic pga memory management with oracle 9i and above?
Discuss row chaining, how does it happen? How can you reduce it?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
Tell me about standby database? What should we watch out for?
What do you mean by dba?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
Why are recursive relationships bad? How do you resolve them?