-
View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?（）https://assets.asklib.com/images/image2/2018080214474089167.jpg
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.
-
Exhibit，View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting？ （）https://assets.asklib.com/images/image2/2018080114300630592.jpg
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.
-
View the Exhibit and examine the structure of the ORDERS table.
https://assets.asklib.com/images/image2/2018080114365996369.jpg
Which task would require subqueries？ （）
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
-
View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are true regarding the location of diagnostic traces?（）https://assets.asklib.com/images/image2/2018080213513444789.png
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.
-
View the Exhibit and examine the initialization parameter settings.
https://assets.asklib.com/images/image2/2018080116211316874.jpg
Which three initialization parameters are to be set manually as they are not automatically tuned（）
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
-
View the Exhibit and examine the Data Pump architecture. Identify the numbered components.（）https://assets.asklib.com/images/image2/2018080214125062228.jpg
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
-
View the Exhibit and examine the output of the query.
https://assets.asklib.com/images/image2/2018080116223452518.jpg
What do you infer from this（）
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.
-
View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?（）https://assets.asklib.com/images/image2/201808021408025170.png
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.
-
View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.https://assets.asklib.com/images/image2/2018080110415468606.jpg
A . 1 MB
B . 6 MB
C . 10 MB
D . 15 MB
E . 11 MB
-
View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?（）https://assets.asklib.com/images/image2/2018080214062464323.png
A . An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B . A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C . The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management .
D . The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contentio
-
View the Exhibit and examine the Flashback Database architecture.
Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）
https://assets.asklib.com/images/image2/2018080210560571406.jpg
A . DBWn
B . RVWR
C . ARCH
D . RECO
E . TRWR
-
View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting？ （）https://assets.asklib.com/images/image2/2018080210125647267.jpg
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.
-
View the Exhibit. Which statements are true regarding the USERS tablespace（）https://assets.asklib.com/images/image2/2018080117542643082.jpg
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
-
Click the Exhibit（s） button to view the DEPARTMENTS plan.
https://assets.asklib.com/images/image2/2018080117241174602.jpg
After analyzing the Exhibit， what conclusion will you draw？（）
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.
-
View the Exhibit and identify the component marked with a question mark.（）https://assets.asklib.com/images/image2/2018080209115933263.jpg
A . Checkpoint （CKPT）
B . Process Monitor （PMON）
C . Archiver Processes （ARCn）
D . Recoverer Process （RECO）
E . Memory Manager process （MMAN）
-
View the Exhibit and examine the data in the PRODUCT INFORMATION table.
https://assets.asklib.com/images/image2/2018080114285063300.jpg
Which two tasks would require subqueries？ （）
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
-
View the Exhibit and examine the output.
Which two statements are true regarding the LISTENER2 listener（）
https://assets.asklib.com/images/image2/2018080209445455276.jpg
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
-
View the exhibit and examine the output.
https://assets.asklib.com/images/image2/2018080214180714803.jpg
Which statement can be an inference from the output?（）
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
-
View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings，respectively.
https://assets.asklib.com/images/image2/201808011533265792.jpg
Why are advisors not available for the shared pool and the buffer cache()
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
-
View the Exhibit and identify the component marked with a question mark. （）https://assets.asklib.com/images/image2/2018080115025841442.jpg
A . Checkpoint （CKPT）
B . Process Monitor （PMON）
C . Archiver Processes （ARCn）
D . Recoverer Process （RECO）
E . Memory Manager process （MMAN）
-
View the Exhibit to examine the Automatic Database Diagnostic Monitor （ADDM) tasks.Which statement describes the consequence？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/d39131b84ca6a8d8b08830b9d4753c7b.jpg' />
<img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/4c44618d517b4d4d3a08325cfb73e2e3.jpg' />
A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
-
Examine the following commands and their output:SQL＞ SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL＞ UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL＞ SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row？（）
<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.
-
View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL＞ EXECUTE dbms_resources_manager.validate_pending_area ();What could be the reason？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135247/2c9611256b04bdd5ba39c52e4e7dd450.png' />
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
-
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN＞ BACKUP DATABASE FILESPERSET 2;The database has seven data files.Why is the %_COMPLETE refreshed to 13.59 in the third output afterreaching 88.77？（）
A. Because the progress is reported for each data file
B. Because the progress is reported for each backup set
C. Because other RMAN sessions have issued the same BACKUP command
D. Because new data files have been added to the database while the RMAN backup is in progress
