Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）

A、120M

B、320M

C、480M

D、600M

相关问题推荐

• Observe the following warning in an RMAN session of your database instance：   WARNING:// new failures were found since last LIST FAILURE command   Which statement describes the scenario that must have produced this warning？（）

  A、 The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository（ADR）

  B、 The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR）

  C、 The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE

  D、 The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed

  查看答案

• You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' Identify the statement that correctly describes this setting.（）

  A、The MANDATORY location must be a flash recovery area.

  B、The optional destinations may not use the flash recovery area.

  C、This setting is not allowed because the first destination is not set as MANDATORY.

  D、The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

  查看答案

• The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）

  A、Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

  B、Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

  C、Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

  D、Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

  查看答案

• 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 （）

  A、 identify the segments that you should shrink

  B、 modify the storage parameters for the tablespace

  C、 automatically shrink the segments with unused space

  D、 check the alerts generated for the tablespace that is running low on space

  查看答案

• A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）

  A、 Flashback Drop

  B、 Flashback Query

  C、 Flashback Versions Query

  D、 Flashback Transaction Query

  E、 Flashback Table

  查看答案