Partitioning and Storage-Related Enhancements

These questions are based on 1Z0-050 – Oracle Database 11g New Features
Oracle Self Test Software Practice Test.


Objective: Partitioning and storage-related enhancements.
Sub-objective: Implement the new partitioning methods.


Multiple answer, multiple choice


You execute the CREATE TABLE statement shown in the exhibit to create the EMPLOYEES table. (Click the Exhibit(s) button.)


Which two statements are true? (Choose two.)



  1. The EMPLOYEES table is created with four partitions.
  2. New partitions are added to the EMPLOYEES table as needed when data is inserted.
  3. Partition pruning can occur for the specified partitioning key.
  4. The table is not created because it uses a virtual column for the partitioning key.

Answer:
A. The EMPLOYEES table is created with four partitions.
C. Partition pruning can occur for the specified partitioning key.


Tutorial:
The EMPLOYEES table is created with four partitions, and partition pruning can occur for the specified partitioning key.


You can create a partition table using a virtual column as the partitioning key. In this scenario, you specify the virtual column BONUS_AMT as the partitioning key. The statement executes and creates the table with the four specified partitions. The values in the BONUS_AMT column are evaluated as needed and not physically stored in the table. Partition pruning and partition-wise joins are supported for tables that are partitioned on virtual columns.


The option that states new partitions are added to the EMPLOYEES table as needed when data is inserted is incorrect. This is…


cmadmin

ABOUT THE AUTHOR

Posted in Uncategorized|

Comment:

Powered by WebDesk