Oracle
1Z0-050 · Question #30
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…
The correct answer is A. Every SQL statement in the STS is considered only once for execution. C. The execution plan and execution statistics are computed for each SQL statement in the STS. See the full explanation below for the reasoning.
Question
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? (Choose two.)
Options
- AEvery SQL statement in the STS is considered only once for execution.
- BThe SQL statements in the STS are executed concurrently to produce the execution plan and
- CThe execution plan and execution statistics are computed for each SQL statement in the STS.
- DThe effects of DDL and DML are considered to produce the execution plan and execution statistics.
How the community answered
(47 responses)- A81% (38)
- B13% (6)
- D6% (3)
Community Discussion
No community discussion yet for this question.