our database instance is started using the server parameter file （SPFILE）. You executed a command tochange 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 . Event Viewer gives more details on the failure. B . The alert log file gives detailed information about the failure. C . PMON rolls back the transaction and releases the locks. D . SMON rolls back the transaction and releases the locks. E . The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction. F . Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

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 . 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 tape I/O performed is asynchronous B . The tape buffer is allocated from the System Global Area (SGA) C . The tape buffer is allocated from the Program Global Area (PGA) D . Oracle I/O uses an interrupt mechanism to determine when each I/O complete

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 . The online redo log files and archived redo log files are required to accomplish the recovery. B . The uncommitted transaction will be committed at the next startup of the database instance. C . The uncommitted transaction is rolled back automatically at the next opening of the database. D . The DBA has to perform the recovery on the database to recover the uncommitted transactio

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 . PMON coordinates media recovery. B . SMON coordinates instance recovery. C . PMON coordinates instance recovery. D . Undo Advisor would roll back all uncommitted transactions. E . SQL*PLUS reports an error with the message asking you to perform instance recovery.

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

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

A .  The tape I/O performed is asynchronous B .  The tape buffer is allocated from the System Global Area （SGA） C .  The tape buffer is allocated from the Program Global Area （PGA） D .  Oracle I/O uses an interrupt mechanism to determine when each I/O complete

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 . 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 . PMON coordinates media recovery. B . SMON coordinates instance recovery. C . PMON coordinates instance recovery. D . Undo Advisor would roll back all uncommitted transactions. E . SQL*PLUS reports an error with the message asking you to perform instance recovery.&e

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