View the Exhibit to observe the roles assigned to the SLP_REP user. https://assets.asklib.com/images/image2/2018080117044917589.jpg Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REPuser（）

相似题目

• 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 observe the roles assigned to the SL_REP user.  Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）

  A . The user must enable the role explicitly. B . The user can grant the role to other users. C . The user cannot use the role until the DBA enables it explicitly. D . The user can start using the role immediately without any change

  查看最佳答案

• View the Exhibit. https://assets.asklib.com/images/image2/2018080210301383494.jpg You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up？ （）

  A . password file B . online redo log files C . the current control file D . archived redo log files E . the current server parameter file F . all the data files belonging to the USERS tablespace G . data files belonging to the USERS tablespace and all the default tablespace

  查看最佳答案

• 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 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. https://assets.asklib.com/images/image2/2018080210291676439.jpg You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS; Which type of backup would this command perform？（）

  A . backup set B . image copy C . incremental backup D . None; the user receives an error indicating that the backup type must be specified.

  查看最佳答案

• 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 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（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.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

  A .  all the data files belonging to the USERS tablespace B .  password file C .  online redo log files D .  the current control file E .  archived redo log files F .  the current server parameter file G .  data files belonging to the USERS tablespace and all the default tablespace

  查看最佳答案

• View the Exhibit1， which shows the options that are selected to create the user SL_REP. https://assets.asklib.com/images/image2/2018080116564397477.jpg Which two statements are true regarding this user（）

  A . The user is authenticated by the operating system. B . The objects created by the user are placed in the USERS tablespace. C . The user does not require quota on the TEMP tablespace to perform sort operations. D . The user is forced to change the password at the first login to the database instance. E . The objects created by the user in future are unlocked to be accessed by all the users in the database by defa

  查看最佳答案

• 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.

  查看最佳答案

• 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.

  查看最佳答案

• View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN＞ REPAIR FAILURE;Which statement describes the consequence of the command？（）

  <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/31f166c0cedddf6946f2b336e2153075.jpg' /> A. The command performs the recovery and closes the failures. B. The command only displays the advice and the RMAN script required for repair. C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command. D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

  查看最佳答案

• 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

  查看最佳答案