更多"The SQL Tuning Advisor has been con"的相关试题:
[单项选择] The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations
[单项选择]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
[单项选择]The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
A. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations
[单项选择]You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()
A. The tuned plan is not added to the SQL plan baseline.
B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
[单项选择]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
[多项选择]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.
[多项选择]For added security, a network administrator has decided to lock down the wireless network. Which of the following are ways to accomplish this? ()(Select TWO).
A. Disable all 802.11 traffic
B. Disable the SSID from broadcasting
C. Disable WPA
D. Enable Bluetooth only communication
E. Change the default admin password
F. Disable WEP
[多项选择]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
[单项选择] The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations
[单项选择]The new factory that has been built next to us has ______ the value of our house.
A. demoralized
B. depreciated
C. deterred
D. derailed
[单项选择] You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement,which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()
A. The tuned plan is not added to the SQL plan baseline.
B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
[单项选择]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?()
A. Filter versions
B. Filter loads
C. Filter tasks
D. Filter options
[单项选择]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 condition does the author feel has nearly destroyed our cities
A. Lack of financial planning.
B. The breakup of the family.
C. Natural disasters in many regions.
D. The excessive growth of motors.