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 disrupt ion to availability is required.
Which three statements are true about this requirement?
A.
The partitions can be moved online to new tablespaces.
B.
Global indexes must be rebuilt manually after moving the partitions.
C.
The partitions can be compressed in the same tablespaces.
D.
The partitions can be compressed in the new tablespaces.
E.
Local indexes must be rebuilt manually after moving the partitions.
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.
http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34dba-2193424.html
Incorrect:
Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move
the table.