READ Free Dumps For Oracle- 1z0-050
| Question ID 1778 | You are managing an Oracle Database 11 g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: |
| Option A | A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB. |
| Option B | B. The SBT channel must be configured, with the parallelism setting for’ the SBT device set to 3 |
| Option C | C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0. |
| Option D | D. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1. |
| Correct Answer | B |
| Question ID 1779 | 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 | A. It produces less accurate results of the comparison analysis. |
| Option B | B. It automatically calls the SQL Tuning Advisor for recommendations. |
| Option C | C. It shortens the time of execution and reduces the impact on system resources |
| Option D | D. Only the changes in the execution plan, and not performance regression, are detected. |
| Correct Answer | A,C |