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.)
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.
Currently there are no comments in this discussion, be the first to comment!
This section is not available anymore. Please use the main Exam Page.1z0-053 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Comments