By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）  

A、set point B、control point C、deviation D、offset

A .  FRENCH_AI B .  FRENCH_CI C .  AI_FRENCH D .  CI_FRENCH

A .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

A . The command would return an error because LOG_BUFFER is a static parameter. B . The parameter value would be changed and it would come into effect immediately. C . You need to restart the database so that parameter changes can come into effect. D . The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

A .  Filter versions B .  Filter loads C .  Filter tasks D .  Filter optio

A .  os B .  local C .  -8：00 D .  dbtimezone Li E .  Australia

A .  DB_CACHE_SIZE B .  SHARED_POOL_SIZE C .  LARGE_POOL_SIZE D .  JAVA_POOL_SIZE E .  SGA_MAX_SIZE F .  SORT_AREA_SIZE

A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session. B . A resumable statement is suspended only if an out of space error occurs. C . When a resumable statement is suspended, the transaction that contains the statement is also suspended. D . A resumable statement can only be suspended and resumed once during the execution of the statement. E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a sessio

A .  DATE B .  TIMESTAMP C .  INTERVAL YEAR TO MONTH D .  INTERVAL DAY TO SECOND E .  TIMESTAMP WITH LOCAL TIME ZONE

A . The command would return an error because LOG_BUFFER is a static parameter. B . The parameter value would be changed and it would come into effect immediately. C . You need to restart the database so that parameter changes can come into effect. D . The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

A .  ’os’ B .  local C .  -8：00’ D .  dbtimezone Li E .  ’Australia&rsquo

A、dead band B、control point C、deviation D、offset

A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session. B . A resumable statement is suspended only if an out of space error occurs. （Out of space condition Maximum extents reached condition，Space quota exceeded condition） C . When a resumable statement is suspended, the transaction that contains the statement is also suspended. D . A resumable statement can only be suspended and resumed once during the execution of the statement. E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

A .  The trace files will be disabled only for a specific session. B .  Tracing will be disabled for a client identifier. C .  Tracing will be disabled only for the ARCn process. D .  The SQL Trace facility will be disabled for the instance.

A . ALL B . PFILE C . BOTH D . NONE E . SPFILE F . MEMORY G . INSTANCE H . DATABASE

A . density differences of the water B . rotation of the earth C . direction of primary circulation of air D . all of the above

A . loop guard B . storm control C . storm suppression D . broadcast suppression E . BPDU guard

A . 1 day B . 5 days C . 7 days D . 31 day

A .  The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory. B .  The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory. C .  The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory. D .  The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.

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.

A . 120M B . 320M C . 480M D . 600M

A .  then the default is set to $ORACLE_BASE The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set， B .  then it is set to $ORACLE_HOME C .  DIAGNOSTIC_DEST is always equal to $ORACLE_HOME D .  DIAGNOSTIC_DEST is always equal to $ORACLE_BASE

A . DATE B . TIMESTAMP C . INTERVAL YEAR TO MONTH D . INTERVAL DAY TO SECOND E . TIMESTAMP WITH LOCAL TIME ZONE