You plan to execute the following command to perform a Flashback Database operation in your database:<br /> SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);<br /> Which two statements are true about this?（）..

第1题

[] 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?（） 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?（）

A、A. The pending area is automatically submitted after the plan creation B、B. The procedure must be executed before creating the resources plan directive C、C. The SYS_GROUP resource consumer group is not included in the resource plan directive D、D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

点击查看答案

第2题

[] 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?（） 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?（）

A、A. The pending area is automatically submitted after the plan creation B、B. The procedure must be executed before creating the resources plan directive C、C. The SYS_GROUP resource consumer group is not included in the resource plan directive D、D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

点击查看答案

第3题

[多选题] 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)

点击查看答案

第4题

[多选题] 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

点击查看答案

第5题

[多选题] When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?（）

A、It produces less accurate results of the comparison analysis. B、It automatically calls the SQL Tuning Advisor for recommendations. C、It shortens the time of execution and reduces the impact on system resources. D、Only the changes in the execution plan, and not performance regression, are detected.

点击查看答案

第6题

[多选题] When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)

A、It produces less accurate results of the comparison analysis. B、It automatically calls the SQL Tuning Advisor for recommendations. C、It shortens the time of execution and reduces the impact on system resources. D、Only the changes in the execution plan, and not performance regression, are detected.

点击查看答案

第7题

[多选题] When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)

A、It produces less accurate results of the comparison analysis. B、It automatically calls the SQL Tuning Advisor for recommendations. C、It shortens the time of execution and reduces the impact on system resources. D、Only the changes in the execution plan, and not performance regression, are detected.

点击查看答案

第8题

[单选题] Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）

A、The optimizer used a dynamic plan for the query. B、The optimizer chose different plans because automatic dynamic sampling was enabled. C、The optimizer used re-optimization cardinality feedback for the query. D、The optimizer chose different plan because extended statistics were created for the columns used.

点击查看答案

第9题

[] You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（） You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（）

A、A.
B.
C.
D.

点击查看答案

第10题

[单选题] 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.

点击查看答案

You plan to execute the following command to perform a Flashback Database operation in your database:<br /> SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);<br /> Which two statements are true about this?（）

请使用微信扫码支付