Oracle Database 10g New Features for Administrators Set 2

You modified the optimizer statistics of a table by using the DBMS_STATS.GATHER_TABLE_STATS procedure.
You realized that the newly generated statistics have created suboptimal execution plans for that particular table.
What would you do to revert to the previous set of statistics as soon as possible?

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

Which parameter avoids the overwriting of archived redo log files when you recover the database with the RESETLOGS option?

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to _______.

Which file gets created automatically while migrating from non-ASM files to ASM disk group by using RMAN?

If the database is shown degraded performance, which three charts on the Database Control Console Performance page will help you resolve the problem? (Choose three.)

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does
not include autoextensible data files?

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'.
Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert the database-wide default tablespace usage threshold values for the tablespace.
Which PL/SQL package would you use?

Which three statements regarding Automatic Database Diagnostic Monitor (ADDM) are correct? (Choose three)