READ Free Dumps For Oracle- 1z0-060
Question ID 2203 | Which three operations can be performed as multipartition operations in Oracle? |
Option A | A. Merge partitions of a list partitioned table |
Option B | B. Drop partitions of a list partitioned table |
Option C | C. Coalesce partitions of a hash-partitioned global index. |
Option D | D. Move partitions of a range-partitioned table |
Option E | E. Rename partitions of a range partitioned table |
Option F | F. Merge partitions of a reference partitioned index |
Correct Answer | A,B,F |
Question ID 2204 | |
Option A | A. It succeeds because the PDB_ADMIN user has the required privileges. |
Option B | B. It fails because common users are unable to use the SET CONTAINER statement. |
Option C | C. It fails because local users are unable to use the SET CONTAINER statement. |
Option D | D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB). |
Correct Answer | C |