1Z0-515 Question #43: Real Exam Question with Answer & Explanation

The correct answer is A. Partition pruning will occur C. Efficient parallel joins D. Efficient data loading. There are three major advantages of partitioning. Partition Pruning - Oracle only accesses a limited set of table partitions if the FROM and WHERE clause permit it to. Partition-wise Joins - Where two tables that have compatible partitioning schemes are joined , Oracle improves t

Question

What are three advantages provided by proper partitioning in a data warehouse?

Options

APartition pruning will occur
BFaster sorting
CEfficient parallel joins
DEfficient data loading
EReduced disk usage

Explanation

There are three major advantages of partitioning. * Partition Pruning - Oracle only accesses a limited set of table partitions if the FROM and WHERE clause permit it to. * Partition-wise Joins - Where two tables that have compatible partitioning schemes are joined , Oracle improves the efficiency of parallel operations by performing the join between individual partitions of the tables. * Manageability - Partitioning allows DDL operations on a large subset of table rows with some element of commonality defined through the partitioning type. Warehousing-in-Oracle---Part-3.htm

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice