READ Free Dumps For Oracle- 1z0-050
| Question ID 5931 | 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.) |
| Option A | It produces less accurate results of the comparison analysis. |
| Option B | It automatically calls the SQL Tuning Advisor for recommendations |
| Option C | It shortens the time of execution and reduces the impact on system resources |
| Option D | Only the changes in the execution plan, and not performance regression, are detected. |
| Correct Answer | A,C |
| Question ID 5932 | you are managing an Oracle Database 11 g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.) |
| Option A | Set the ASM compatibility attribute for the ASM disk group to 11.1.0. |
| Option B | Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0. |
| Option C | Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0. |
| Option D | Set the COMPATIBLE initialization parameter for the database instance to 11.1.0. |
| Correct Answer | A,B,D |