Examine the following set of RMAN commands: https://assets.asklib.com/images/image2/2018080210170026958.jpg Which statement is true when the RMAN RUN block Is executed?（）

A .  when ASM disk goes offline B .  when one or more ASM files are dropped C .  when some disks in a disk group are offline D .  when some disks in a failure group for a disk group are rebalancing

A .  The members of LOW_GROUP would get more priority than those of OTHER_GROUPS. B .  The members of SYS_GROUP would get most of the CPU allocation at level 1. C .  The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation at two different levels. D .  The members of LOW_GROUP would get no CPU allocation at level1 if the members of OTHER_GROUPS are using all the CPU at level 2. E .  The members of SYS_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.

A . The shrink operation touches every block in the BOOKING table B . The high-water mark (HWM) for the BOOKING table is shifted from its original position C . The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table D . The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio

A . The COMMIT order in the captured workload is preserved during replay. B . The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls. C . The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured. D . The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying. E . The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

A . when ASM disk goes offline B . when one or more ASM files are dropped C . when some disks in a disk group are offline D . when some disks in a failure group for a disk group are rebalancing

A . LOG_BUFFER B . SORT_AREA_SIZE C . JAVA_POOL_SIZE D . STREAMS_POOL_SIZE E . DB_16K_CACHE_SIZE F . DB_KEEP_CACHE_SIZE

A .  The shrink operation touches every block in the BOOKING table B .  The high-water mark （HWM） for the BOOKING table is shifted from its original position C .  The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table D .  The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio

A . It cancels all pending disk drops within the disk group. B . It restores disks that are being dropped as the result of a DROP DISKGROUP operation C . It mounts disks in the disk group for which the drop-disk operation has already been co pleted D . It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E . It adds previously dropped disks back into the disk grou

A . Automatic statistics collection is stopped for the CUSTOMERS table. B . Statistics for the CUSTOMERS table are locked and cannot be overwritten. C . Existing statistics for the CUSTOMERS table become unusable for the query optimizer. D . Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.

A . The members of LOW_GROUP would get more priority than those of OTHER_GROUPS. B . The members of SYS_GROUP would get most of the CPU allocation at level 1. C . The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation at two different levels. D . The members of LOW_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2. E . The members of SYS_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.

A . Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file. B . All DDL commands are logged in the alert log file. C . All DDL commands are logged in a different log file that contains DDL statements and their execution dates. D . Only DDL commands that resulted in the creation of new segments are logged. E . All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

A . Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set B . The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set C . The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set D . Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startu

A . Enable Signature Default B . Enable Engine Fail Closed C . Enable Default IOS Signature ActualTests.com D . Enable Fail Opened

A .  It cancels all pending disk drops within the disk group. B .  It restores disks that are being dropped as the result of a DROP DISKGROUP operation C .  It mounts disks in the disk group for which the drop-disk operation has already been co pleted D .  It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E .  It adds previously dropped disks back into the disk grou

A . The data file is checked for physical corruption and backed up if found clean. B . The backup of data file 5 is performed and the interactive messages during the backup are suppressed. C . The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup. D . The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

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

A . None of the data definition language (DDL) statements are logged in the trace file. B . Only DDL commands that resulted in errors are logged in the alert log file. C . A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file. D . Only DDL commands that resulted in the creation of new database files are logged.

A . Automatic statistics collection is stopped for the CUSTOMERS table. B . Statistics for the CUSTOMERS table are locked and cannot be overwritten. C . Existing statistics for the CUSTOMERS table become unusable for the query optimizer. D . Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistic

A.2，4，5 B.2，1，4，3，5 C.1，2，3，4，5 D.1，2，4，5

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a303b81782e5cc63228b13b8df2b43c9.jpg' /> A. Flashback logging is not enabled for the database. B. The changes made to the table are not committed. C. Supplemental logging is not enabled for the database. D. The database is not configured in ARCHIVELOG mode.

是 否