View this parameter setting in your database：   DB_CREATE_FI

第1题：

第2题：

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）

• A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
• B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
• C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
• D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

第3题：

第4题：

Which statement regarding the contents of the V$PARAMETER view is true？（）

• A、displays only the list of default values
• B、displays only the list of all basic parameters
• C、displays the currently in effect parameter values
• D、displays only the list of all advanced parameters
• E、displays the list of all the parameter files of a database

第5题：

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

• A、 The database will not start.
• B、 The database will start but will not retain the undo data in the undo segment.
• C、 The database will start， and the undo segment will contain the undo data for at least one hour.
• D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

第6题：

第7题：

Which setting enables the baselines by default in Oracle Database 11g?（）

• A、setting the STATISTICS_LEVEL parameter to TYPICAL
• B、adding filters to the Automatic Database Diagnostic Monitor (ADDM)
• C、enabling Automated Maintenance Task using Oracle Enterprise Manager
• D、setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

第8题：

第9题：

You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

• A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
• C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

第10题：

You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）

• A、 By using the trace file.
• B、 By using the alert log file.
• C、 By using the database ID
• D、 By using the server parameter file.
• E、 By using the V$CONTROLFILE view.
• F、 By using the autobackup format configuration setting.