搜题

【多选题】

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.

查看正确答案

更多“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.)”相关的问题

第1题

[多选题] When does a transaction complete?（）

A、when a DELETE statement is executed B、when a ROLLBACK command is executed C、when a PL/SQL anonymous block is executed D、when a data definition language (DDL) statement is executed E、when a TRUNCATE statement is executed after the pending transact ion

点击查看答案

第2题

[] You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（） You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）

A、A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements. B、B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements. C、C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements. D、D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used. E、E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

点击查看答案

第3题

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

点击查看答案

第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? （）(Choose two.)

点击查看答案

第6题

[单选题] A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?（）

A、When view V1 is created B、Each time the REFRESH VIEW v1 statement is executed C、Each time an SQL statement is executed against view V1 D、Only the first time an SQL statement is executed against view V1

点击查看答案

第7题

[] 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.

点击查看答案

第8题

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

点击查看答案

第9题

[多选题] What is true about a background engine? （）(Choose two.)

A、It is a server-side PL/SQL procedure. B、When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code. C、It executes deferred activities in decreasing order of their Cost property value (activities with higher cost value are processed first). D、It would fail if another background engine process is started to handle the same type of activities within the same item type. E、During its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服