1Z0-060 · Question #148
1Z0-060 Question #148: Real Exam Question with Answer & Explanation
The correct answer is A: The partitions can be moved online to new tablespaces.. 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
Question
Options
- AThe partitions can be moved online to new tablespaces.
- BGlobal indexes must be rebuilt manually after moving the partitions.
- CThe partitions can be compressed in the same tablespaces.
- DThe partitions can be compressed in the new tablespaces.
- ELocal 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. 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 Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.
Community Discussion
No community discussion yet for this question.