READ Free Dumps For Oracle- 1z0-050
| Question ID 1807 | 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.) |
| Option A | A. Every SQL statement in the STS is considered only once for execution. |
| Option B | B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics. |
| Option C | C. The execution plan and execution statistics are computed for each SQL statement in the STS.
|
| Option D | D. The effects of DDL and DML are considered to produce the execution plan and execution statistics. |
| Correct Answer | A,C |
| Question ID 1810 | Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.) |
| Option A | A. multiplexing of the control file |
| Option B | B. database and operating system upgrades |
| Option C | C. adding the redo log member to the database |
| Option D | D. changing the database storage to ASM-managed storage
|
| Option F |
|
| Correct Answer | B,D |