READ Free Dumps For Oracle- 1z0-050
| Question ID 6073 | 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 thisprocess? (Choose all that apply.) |
| Option A | the SQL text |
| Option B | the execution plan |
| Option C | the execution context Do- the execution frequency |
| Option D | the system change number (SCN) |
| Correct Answer | A,C,D |
| Question ID 6074 | View the following SQL statements: Transaction T1 INSERT INTO hr.regions VALUES (5,'Pole'); COMMIT; Transaction T2 UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5; COMMIT; Transaction T3 UPDATE hr.regions SET region_name='North and South Poles' WHERE regionjd = 5; You want to back out transaction T2. Which option would you use? |
| Option A | It is possible, but transaction T3 also backs out. |
| Option B | It is possible with the NOCASCADE_FORCE option. |
| Option C | It is possible with the NONCONFLICT_ONLY option. |
| Option D | It is not possible because it has conflicts with transaction T3. |
| Correct Answer | B |