how can you process messages in order asynchronously?
by issuing "alter tablespace begin backup;" what happens to tablespace?
What is the difference between Datapump & export/import?
How would you go about verifying the network name that the local_listener is currently using?
Name three advisory statistics you can collect.
How will u copy the objects of one schema to another schema in datapump & export/import?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
why we use cursors
internal architecture
What are the steps you will take to improve performance of a poor performing query?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what is a crs resource?