Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?
Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?
Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?