-
View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?()https://assets.asklib.com/images/image2/2018080213555554170.png
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.
-
View the Exhibit to examine the parameter values.
You are planning to set the value for the MEMORY_TARGET parameter of your database instance.
What value would you recommend?()
https://assets.asklib.com/images/image2/2018080117085922509.png
A . 90 MB
B . 272 MB
C . 362 MB
D . 1,440 MB
-
View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.What is the reason for this error?()https://assets.asklib.com/images/image2/2018080213572340869.png
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.
-
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.
-
To examine the Exhibit, press the Exhibit button. Using the "ps -mo THREAD" output as shown in the exhibit, which of the following conclusions is most appropriate to draw?()https://assets.asklib.com/images/image2/2018080211465344151.bmp
A . This is a uniprocessor system
B . The "prog" process has a nice value of 107
C . There are two active processors on this system
D . The "prog" process will only be scheduled to run on processor 0
-
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.
Which statement is trueabout the output of the command()
https://assets.asklib.com/images/image2/2018080117575419854.jpg
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
-
View the Exhibit to examine the details for an incident. Which statement is true regarding the status of theincident()https://assets.asklib.com/images/image2/2018080117523734517.jpg
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
-
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 to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?()https://assets.asklib.com/images/image2/2018080211100285691.jpg
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.
-
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 to examine the details for an incident.
https://assets.asklib.com/images/image2/2018080116061373347.jpg
Which statement is true regarding the status of the incident()
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.
-
Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.
For which situation would you use a nonequijoin query?()
https://assets.asklib.com/images/image2/2018080114250059182.jpg
A . to find the tax percentage for each of the employees
B . to list the name, job_id, and manager name for all the employees
C . to find the name, salary, and the department name of employees who are not working with Smith
D . to find the number of employees working for the Administrative department and earning less than 4000
E . to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned
-
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.
You need to find the percentage tax applicable for each employee. Which SQL statement would you use?()
https://assets.asklib.com/images/image2/2018080114273930960.jpg
A . SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B . SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C . SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);
D . You cannot find the information because there is no common column between the two tables.
-
Refer to the exhibit. Examine the partial configuration and the routing table excerpt. Which routes would be redistributed into OSPF area 1?()https://assets.asklib.com/images/image2/2018073016410242942.jpg
A . 10.10.10.16/28 only
B . 10.10.10.16/28 and 10.10.10.64/26
C . 10.10.10.16/28, 10.10.10.64/26, and 172.16.10.0/24
D . 10.10.10.64/26 only
-
To examine the Exhibit, press the Exhibit button. The system administrator notices a system with routing cannot communicate with a system with an ip address 192.24.34.6. Using the information provided in the exhibit, what is the most likely reason?()
A . The named is not running
B . The default gateway is not set
C . The NIS master server is down
D . Ipforwarding is not turned o
-
To examine the Exhibit, press the Exhibit button. Which option would produce this output from the errpt command? ()https://assets.asklib.com/images/image2/20180802115800592.jpg
A . errpt -t
B . errpt -a
C . errpt -D
D . errpt
-
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?()
A . 120M
B . 320M
C . 480M
D . 600M
-
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 examine the output.
You execute the following RMAN command to perform the backup operation:
https://assets.asklib.com/images/image2/2018080215274892659.jpg
What is the multiplexing level in the preceding backup process()
A . 4
B . 8
C . 7
D . 0
-
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.
https://assets.asklib.com/images/image2/2018080115551810468.jpg
Which statement is true about the output of the command()
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.
-
To examine the Exhibit, press the Exhibit button. Using the "ps -el" output as shown in the exhibit, which of the following conclusions is most appropriate to draw?()https://assets.asklib.com/images/image2/2018080211154480089.jpg
A . The snmpd process is running at a fixed priority of 60
B . If both the syncd process and the portmap process become available to be run at the same time, then the syncd process would get scheduled first
C . If both the userprog process and the qdaemon process become available to be run at the same time, then the qdaemon process would get scheduled first
D . If both the syslogd process and the llbd process become available to be run at the same time, then the llbd process would get scheduled first
-
To examine the Exhibit, press the Exhibit button. The exhibit shows the output of netstat -nr. Which of the following addresses will require an additional route entry? ()https://assets.asklib.com/images/image2/2018080211523042275.jpg
A . 129.35.54.22
B . 129.35.56.35
C . 129.35.57.22
D . 129.35.1.22
-
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.You need to find the percentage tax applicable for each employee. Which SQL statement would you use?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135988/ea49d0916fc0345195a85a9b2816cb50.jpg' />
A.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);
D.You cannot find the information because there is nocommon column between the two tables.
-
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.