QUESTION 10

QUESTION 10
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.
Correct Answer: ACD
Section: (none)
Explanation
Explanation/Reference:
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.
Incorrect Answers: B, E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES
when you move the table.
References: http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34dba-2193424.html

 

为了利用存储管理员提供的某些新存储层，必须将大型堆表的分区移动到Oracle 12c数据库中的其他表空间？

本地和全局分区的B树索引都在表上定义。大量事务在白天访问表，而中等数量的事务在夜间和周末访问表。对可用性的最小中断是必须。哪个关于这个要求有三种说法是正确的？（选择三个。）

A、 分区可以在线移动到新的表空间。

B、 移动分区后，必须手动重建全局索引。

C、 分区可以压缩在相同的表空间中。

D、 分区可以在新的表空间中压缩。

E、 移动分区后，必须手动重建本地索引。

正确答案：ACD

章节：（无）

解释

说明/参考：

说明：

A： 您可以在线创建和重建索引。因此，可以在对基表生成或重建索引的同时更新基表。可以在生成索引时执行DML操作，但不允许执行DDL操作。联机创建或重建索引时不支持并行执行。

D： 移动（重建）索引组织的表因为索引组织的表主要存储在B树索引中，所以增量更新可能会导致碎片。但是，您可以使用ALTERTABLE…MOVE语句来重建索引并减少碎片。

C： 如果一个表可以在新表空间中压缩，那么它也可以在同一个表空间中压缩

表空间。

回答不正确：B，E:移动表时，可以使用更新索引自动重建本地和全局索引。

参考文献：http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34dba-2193424.html