What is tkprof and how is it used?
What do you understand by recovery catalog?
If you are not sure what command does a particular unix function what is the best way to determine the command?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
How do you analyze table partition using oracle provided package?
What is oracle full backup?
How many types of database software are there?
What are dba privileges?
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 end user in database?
What are the types of locks in database?
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?)
What are the goals of dba?
What is the difference between internal & external schema?
How do you set up tablespaces during an oracle installation?