Which three statements are true about this requirement?

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?

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.
Local indexes must be rebuilt manually after moving the partitions.

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.
The partitions can be compressed in the same tablespaces.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Patty

Patty

Correct BCE

Narendra

Narendra

Correct BCE