In order to exploit some new storage tiers that have been provisioned by a storage administrator…?

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.
B:
Note:
* Transporting and Attaching Partitions for Data Warehousing Typical enterprise data
warehouses contain one or more large fact tables. These fact tables can be partitioned
by date, making the enterprise data warehouse a historical database. You can build
indexes to speed up star queries. Oracle recommends that you build local indexes for
such historically partitioned tables to avoid rebuilding global indexes every time you

drop the oldest partition from the historical database.
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.