You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）  

A、 10M

B、 400M

C、 600M

D、 800M

相关问题推荐

• In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）

  A、 The backup would be retained on the media for 31 days.

  B、 The backup would be maintained in the recovery catalog for 31 days.

  C、 The backup metadata would be retained in the control file for 31 days.

  D、 The backup metadata would be maintained in the recovery catalog for 31 days.

  E、 Automatic backups of the control file will be retained in the flash recovery area for 31 days.

  查看答案

• You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  A

   Flashback logs are not archived.

  B

   Flashback logs are maintained in redo log files.

  C

   Flashback logs are maintained in the Flash Recovery Area.

  D

   Flashback logs are used to maintain Flashback Database related errors.

  E

   Flashback logs need to be cleared manually after you disable Flashback Database.

  查看答案

• You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to？（）

  A、 FREQ = MONTHLY； BYDAY = 2FRI；

  B、 FREQ = MONTHLY； BYDAY = FRI（2）；

  C、 FREQ = MONTHLY； BYDAY = FRI2；

  D、 FREQ = MONTHLY； BYDAY = -2FRI；

  查看答案

• You are operating your database in the manual archiving mode. Currently， your database is configured with the following online redo log groups and members：    You tried to drop Group 1 from the database but received the following errors：        ORA-01623： log 1 is current log for thread 1 cannot drop        ORA-00312： online log 1 thread 1：   ’D:///ORACLE/ORADATA/TESTDB/REDO01a.LOG’   What might be the reason for these errors？（）  

  A、  Group 1 is an active or current online redo log group.

  B、  Group 1 is an inactive online redo group that has not been archived yet.

  C、  The members of the Group 1 are temporarily asymmetric with the members of other groups.

  D、  The size of the online redo log members of Group 1 is different from the size of the members in other groups.

  查看答案

• The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five/x7fdigit number starting with 0.  What could be the possible reason？（）

  A、These are the data files that are corrupted.

  B、There is no SYSAUX tablespace in your database

  C、There is a read­only tablespace in your database.

  D、These are the data files that cannot be recovered.

  查看答案