When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）

相似题目

• You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）

  A .  DBMS_WORKLOAD_REPOSITORY B .  DBMS_RESOURCE_MANAGER C .  DBMS_SQLTUNE D .  DBMS_ADVISOR

  查看最佳答案

• How can you create a listener class that receives events when the mouse is moved？（）  

  A .  By extending MouseListener. B .  By implementing MouseListener. C .  By extending MouseMotionListener. D .  By implementing MouseMotionListener. E .  Either by extending MouseMotionListener or extending MouseListener. F .  Either by implementing MouseMotion Listener or implementing MouseListener.

  查看最佳答案

• While tuning a SQL statement， the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation？（）  

  A .  It updates the existing SQL profiles with current statistics B .  It makes the statistics information available to GATHER_STATS_JOB C .  It initiates the statistics collection process by running GATHER_STATS_JOB D .  It logs a warning message in the alert log so that the DBA can perform statistics collection manually

  查看最佳答案

• Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）  

  A . ADDM B . AWR C . Cursor Cache D . SQL Tuning Sets E . Flash Recovery Area

  查看最佳答案

• Which parameter can be tuned to affect the selection of a static route as a backup.when a dynamic protocol is also being used?（）

  A . link bandwidth B . hop count C . link cost D . administrative distance E . link delay

  查看最佳答案

• You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

  A .  the SQL text B .  the execution plan C .  the execution context D .  the execution frequency E .  the system change number （SCN）

  查看最佳答案

• What stanza file does a system administrator view to determine what kernel-tuning parameter changes were made when the system was last booted？（）

  A . /etc/rc.net B . /etc/tunables/tuning C . /etc/tunables/lastboot D . /usr/samples/kernel/nextboot

  查看最佳答案

• You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

  A .  Every SQL statement in the STS is considered only once for execution. B .  The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics. C .  The execution plan and execution statistics are computed for each SQL statement in the STS.  D .  The effects of DDL and DML are considered to produce the execution plan and execution statistics.

  查看最佳答案

• Which of the following attributes should be specified when creating a volume group?（）

  A . stripe size B . allocation policy C . physical partition size D . number of logical partitio

  查看最佳答案

• What interface is created when an FC Port Channel is created on a Cisco Unified Computing System？（）

  A .  An interface ’san-port-channel’ in NXOS B .  An interface ’port-channel’ in NXOS C .  An interface ’port-channel’ with ’mode fc’ configured D .  An interface ’fc-port-channel’ in NXOS

  查看最佳答案

• Which of the following resources are created in the WebSphere Application Server configuration when a WebSphere Commerce V5.6 instance is created？（）

  A . DataSource B . Virtual Hosts C . Server Group D . The selected JDBC Driver E . Remote Servlet Redirector

  查看最佳答案

• Which statement is true when you run the SQL Tuning Advisor with limited scope？（）

  A . Access path analysis is not performed for the SQL statements. B . SQL structure analysis is not performed for the SQL statements. C . SQL Profile recommendations are not generated for the SQL statements. D . The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

  查看最佳答案

• Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）

  A . A list of SQL statements and recommendations for tuning B . A list of SQL statements that have been tuned by the Advisor, with before and after metrics C . Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes D . All of the above

  查看最佳答案

• To view the results of a manual SQL Tuning Advisor task， which steps should the DBA take？（）  

  A .  From the Advisor Central home page，select the tuning task from the Advisor Tasks section  B .  From Advisor Central，choose SQL Advisors，SQL Tuning Advisors，Manual Tuning Task Results C .  From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task Results D .  Either B or C

  查看最佳答案

• When should you create a role? （）

  A . To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement. B . To grant a group of related privileges to a user. C . When the number of people using the database is very high. D . To simplify the process of granting and revoking privileges. E . To simplify profile maintenance for a user who is constantly traveling.

  查看最佳答案

• Which of these appropriately describes the results of a manual SQL Tuning Advisor task？（）  

  A .  A list of SQL statements and recommendations for tuning B .  A list of SQL statements that have been tuned by the Advisor，with before and after metrics  C .  Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes D .  All of the above

  查看最佳答案

• What happens when you run the SQL Tuning Advisor with limited scope?（）

  A . Access path analysis is not performed for SQL statements. B . SQL structure analysis is not performed for SQL statements. C . SQL Profile recommendations are not generated for SQL statements. D . Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

  查看最佳答案

• You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

  A . the SQL text SQL B . the execution plan C . the execution context D . the execution frequency E . the system change number (SCN)

  查看最佳答案

• When you create a backup control file， where is the resulting file written to？（）  

  A .  The database user dump destination directory B .  The database diagnostic destination directory C .  To $ORACLE_HOME/rdbms D .  To $ORACLE_HOME/admin E .  To the directory and filename you specify in the command

  查看最佳答案

• When creating a Virtual Ethernet adapter， which of the following steps is done FIRST？（）

  A . Generate a unique MAC address. B . Run cfgmgr to create device special files. C . Create a virtual device with "smitty vlan". D . Add a virtual Ethernet adapter to the partition profile.

  查看最佳答案

• Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）  

  A .  Create new indexes. B .  Modify existing indexes. C .  Implement partitioning on a nonpartitioned table. D .  Create materialized views. E .  All of the above

  查看最佳答案

• Examine the SQL statements that creates ORDERS table: https://assets.asklib.com/images/image2/201808011530357709.jpg For which columns would an index be automatically created when you execute the above SQL statement? （）

  A . SER_NO B . ORDER_ID C . STATUS D . PROD_ID E . ORD_TOTAL F . Composite index on ORDER_ID and ORDER_DATE

  查看最佳答案

• When defining shipping for a store using WebSphere Commerce Accelerator a seller must create：（）

  A . shipping jurisdictions for each fulfillment center B . shipping codes for each set of shipping charges to be applied to products C . shipping methods for each carrier and service offered by the carrier D . shipping zones for each geographical region where goods will be shipped

  查看最佳答案