Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；  What would be the outcome of this command（）

A . statistics recommendations B . SQL Profile recommendations C . Index-related recommendations D . restructuring of SQL recommendatio

A . The sessions are able to perform only queries. B . The sessions are not affected and continue to function normally. C . The sessions are terminated and the active transactions are rolled back. D . The sessions are not allowed to perform any operations till the listener is started.

A . Oracle Migration Assistant B . Recovery Manager （RMAN） C . Oracle Data Pump Export and Import D . conventional Oracle Export and Import E . operating system utilities to copy the files to the ASM instance

A . They are able to perform only queries. B . They are not affected and continue to function normally. C . They are terminated and the active transactions are rolled back. D . They are not allowed to perform any operations until the listener LISTENER is started

A . The database would open normally. B . The database would not open， and it would stop at mount stage. C . The database would open after automatically performing instance recovery. D . The database would not open， and you have to perform database recovery to open it.

A .  Oracle Net Manager B .  Listener Control utility C .  Database Configuration Assistant D .  Oracle Net Configuration Assistant

A . The sessions are able to perform only queries. B . The sessions are not affected and continue to function normally. C . The sessions are terminated and the active transactions are rolled back. D . The sessions are not allowed to perform any operations till the listener is started

A . statistics recommendations B . SQL profile recommendations C . index-related recommendations D . restructuring of SQL recommendatio

A . Archiving will be disabled because the destination for the redo log files is missing. B . The database instance will shut down and the error details will be logged in the alert log file. C . Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly. D . Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

A . User session data B . Stack space C . Private SQL area D . Location of the runtime area for DML and DDL Statements E . Location of a part of the runtime area for SELECT statement

A .  statistics recommendations B .  SQL profile recommendations C .  index-related recommendations D .  restructuring of SQL recommendatio

A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

A . Oracle Net Manager B . Listener Control utility C . Database Configuration Assistant D . Oracle Net Configuration Assistant

A .  statistics recommendations B .  SQL Profile recommendations C .  Index-related recommendations D .  restructuring of SQL recommendatio

A . Oracle Net Manager B . Listener Control utility C . Database Configuration Assistant D . Oracle Net Configuration Assistant

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.

A .  The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE B .  The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA C .  The database instance starts，but Automatic Memory Management is disabled D .  The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

A . Data Pump B . Oracle Net Manager C . Oracle Enterprise Manager D . Oracle Universal Installer （OUI） E . Database Configuration Assistant （DBCA）

A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL＞ CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP controller1 DISK ‘/devices/diska1‘, ‘/devices/diska2‘FAILGROUP controller2 DISK ‘/devices/diskb1‘, ‘/devices/diskb2‘ ;What happens when the whole CONTROLLER1 Failure group is damaged？（） A. The transactions that use the disk group will halt. B. The mirroring of allocation units occurs within the CONTROLLER2 failure group. C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered. D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

<img src='https://img2.soutiyun.com/shangxueba/ask/64233001-64236000/64234478/9691c5b47b07d813739fc0e9660c9439.jpg' /> A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

A. statistics recommendations B. SQL profile recommendations C. index-related recommendations D. restructuring of SQL recommendations

A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics. B. The optimizer can re optimize a query only once using cardinality feedback. C. The optimizer enables monitoring for cardinality feedback after the first execution of a query. D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled. E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.