View the Exhibit. https://assets.asklib.com/images/image2/2018080116160874823.jpg What would happen if Oracle Home is not empty（）

A . The text alert log file will be available in Diag Trace B . A copy alert log file will be kept in Diag Incident for every incident. C . The XML version of the alert log file will be available in Diag Trace. D . An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.

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 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 . Another repair session is running concurrently. B . The failure ID has not been mentioned in the command for data file 5. C . There are new failures recorded in the Automatic Diagnostic Repository (ADR). D . The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

A .  displaying the total order value for sales representatives 161 and 163 B .  displaying the order total for sales representative 161 in the year 1999 C .  displaying the number of orders that have order mode online and order date in 1999 D .  displaying the number of orders whose order total is more than the average order total for all online order

A . The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace. B . The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert. C . The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace. D . The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

A . The backup piece is expired as the new backup is available. B . The backup piece is expired because the operating-system file was not found. C . The backup piece is expired because the retention period for the backup has expired. D . The backup piece is expired because the backup set to which it belongs is not complete

A . The DBA is working on the incident and prefers that the incident be kept in the ADR. B . The incident is now in the Done state and the ADR can select the incident to be purged. C . The incident has been newly created and is in the process of collecting diagnostic information. D . The data collection for the incident is complete and the incident can be packaged and sent to OracleSupport

A . Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric. B . The statistics for the metric values observed over the baseline time period are not examined to determine threshold values. C . Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline. D . The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.

A . 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API B . 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader C . 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump D . 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pum

A . The SGA_TARGET is a static parameter. B . The instance is started， but the database is not yet open. C . The server parameter file （SPFILE） was used to start the instance. D . The SGA_TARGET parameter does not have any effect onthe databaseinstance untiltheSGA_MAX_SIZE parameter is specified.

A . Accept the recommended SQL profile. B . Collect statistics for the related objects. C . Run the Access Advisor for the SQL statement. D . Run the Segment Advisor for recommendations.

A . All dependent objects remain valid. B . Only the procedure and function become invalid and must be recompiled. C . Only the view becomes invalid and gets automatically revalidated the next time it is used. D . Only the procedure and function become invalid and get automatically revalidated the next time they are called.

A . DBWn B . RVWR C . ARCH D . RECO E . TRWR

A . A bitmap is used to record free extents. B . Free extents information is managed within the tablespace. C . Free extents information is managed in the SYSAUX tablespace. D . The data dictionary tables are updated when extents are allocated or deallocated

A . The DBA is working on the incident and prefers that the incident be kept in the ADR. B . The incident is now in the Done state and the ADR can select the incident to be purged. C . The incident has been newly created and is in the process of collecting diagnostic information. D . The data collection for the incident is complete and the incident can be packaged and sent to OracleSupport.

A .  The CPU cannot be assigned to the members of the SYS_GROUP group. B .  The members of the OTHER_GROUPS group will always be assigned 100 percent CPU. C .  The members of the OTHER_GROUPS group will never be assigned 100 percent CPU. D .  The members of the OTHER_GROUPS group will be assigned 100 percent CPU if the CPU is not assigned to the members of the SYS_GROUP group and the PAYROLL， SALES， and MARKETING groups.

A . Checkpoint （CKPT） B . Process Monitor （PMON） C . Archiver Processes （ARCn） D . Recoverer Process （RECO） E . Memory Manager process （MMAN）

A .  displaying the minimum list price for each product status B .  displaying all supplier IDs whose average list price is more than 500 C .  displaying the number of products whose list prices are more than the average list price D .  displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable E .  displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE

A . The ORCL instance is registered dynamically with the listener. B . The ORCL instance is registered statically in the listener.ora file. C . The number of current client connections handled by the service handler is two. D . The total number of client connections handled so far by the service handler is two

A . The FRA disk group has an asynchronous I/O bottleneck B . The least number of I/Os are performed on the last data file in the list C . The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list D . The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk grou

A . because the DB_CACHE_ADVICE parameter is set to OFF B . because Automatic Memory Management （AMM） is disabled for the database instance C . because Automatic Shared Memory Management （ASMM） is enabled for the database instance D . because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not setinitially

A . The backup piece is expired as the new backup is available. B . The backup piece is expired because the operating-system file was not found. C . The backup piece is expired because the retention period for the backup has expired. D . The backup piece is expired because the backup set to which it belongs is not complete.

A . Checkpoint （CKPT） B . Process Monitor （PMON） C . Archiver Processes （ARCn） D . Recoverer Process （RECO） E . Memory Manager process （MMAN）