How can you tell if a tablespace has excessive fragmentation?
What is explain plan and how is it used?
What is the most common database language that a db administrator needs to know?
What operator tests column for the absence of data?
How does one create a new database?
What does >> do?
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.
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
What happens if the constraint name is left out of a constraint clause?
What are the possible ways to gain information regarding the control file?
What are the roles and responsibilities of oracle dba?
How do you prevent output from coming to the screen?
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 is the difference between internal & external schema?
Discuss row chaining, how does it happen? How do you correct it?