1Z0-060 Real Exam Prep DEMO

Question 1: 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?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions
access it at night and during weekends.
Minimal disruption to availability is required.
Which three statements are true about this requirement? (Choose three.)
A. The partitions can be compressed in the same tablespaces.
B. The partitions can be compressed in the new tablespaces.
C. The partitions can be moved online to new tablespaces.
D. Global indexes must be rebuilt manually after moving the partitions.
E. Local indexes must be rebuilt manually after moving the partitions.
Correct Answer: A,B,C
Explanation
A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time
you are building or rebuilding indexes on that table. You can perform DML operations while the index
build is taking place, but DDL operations are not allowed. Parallel execution is not supported when
creating or rebuilding an index online.
D: Moving (Rebuilding) Index-Organized Tables
Because index-organized tables are primarily stored in a B-tree index, you can encounter
fragmentation as a consequence of incremental updates. However, you can use the ALTER
TABLE...MOVE statement to rebuild the index and reduce this fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same
tablespace.