READ Free Dumps For Oracle- 1z0-062
Question ID 2493 | In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? |
Option A | A. The partitions can be moved online to new tablespaces. |
Option B | B. Global indexes must be rebuilt manually after moving the partitions. |
Option C | C. The partitions can be compressed in the same tablespaces. |
Option D | D. The partitions can be compressed in the new tablespaces. |
Option E | E. Local indexes must be rebuilt manually after moving the partitions. |
Correct Answer | A,C,D |
Question ID 2494 | Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.) |
Option A | A. The ADDM requires at least four AWR snapshots for analysis |
Option B | B. The ADDM runs after each AWR snapshot is collected automatically by MMON |
Option C | C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR) |
Option D | D. The ADDM analysis provides only diagnostics information but does not provide recommendations |
Option E | E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors |
Correct Answer | B,C |