In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a la

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a la

Post by answerhappygod »

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 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply