多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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.
正确答案:A,B,D
答案解析:
进入题库查看解析

微信扫一扫手机做题