QUESTION 148 In order to exploit some new storage tiers that have been

Question 148 in order to exploit some new storage

This preview shows page 109 - 111 out of 117 pages.

QUESTION 148 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. Correct Answer: ABD 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. B: Note: *Transporting and Attaching Partitions for Data Warehousing Typical enterprise data warehouses contain one or more large fact tables. These fact tables can be partitioned by date, making the enterprise data warehouse a historical database. You can build indexes to speed up star queries. Oracle recommends that you build local indexes for such historically partitioned tables to avoid rebuilding global indexes every time you drop the oldest partition from the historical database. D:Moving (Rebuilding) Index-Organized Tables Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a
Image of page 109
- Website designed to help IT pros advance their careers. consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation. QUESTION 149 Which three are true about the large pool for an Oracle database instance that supports shared server connections? A. Allocates memory for RMAN backup and restore operations B. Allocates memory for shared and private SQL areas C. Contains a cursor area for storing runtime information about cursors D. Contains stack space E. Contains a hash area performing hash joins of tables Correct Answer: ABC Section: (none) Explanation Explanation/Reference: Explanation: The large pool can provide large memory allocations for the following: /(B)UGA(User Global Area)for the shared server and the Oracle XA interface (used where transactions interact with multiple databases) /Message buffers used in the parallel execution of statements / (A)Buffers for Recovery Manager (RMAN) I/O slaves Note: *large pool Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.
Image of page 110
Image of page 111

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture