1Z0-497 Question #86: Real Exam Question with Answer & Explanation

The correct answer is E. nothing; it is transparent. https://docs.oracle.com/cd/B19306_01/server.102/b14220/partconc.htm Introduction to Partitioning Partitioning addresses key issues in supporting very large tables and indexes by letting you decompose them into smaller and more manageable pieces called partitions. SQL queries and

Question

What must you do to an application for it to take advantage of partitioning?

Options

Arecompile it
Brewrite its SQL queries
Crelink
Drework the applications schema
Enothing; it is transparent

Explanation

https://docs.oracle.com/cd/B19306_01/server.102/b14220/partconc.htm Introduction to Partitioning Partitioning addresses key issues in supporting very large tables and indexes by letting you decompose them into smaller and more manageable pieces called partitions. SQL queries and DML statements do not need to be modified in order to access partitioned tables. However, after partitions are defined, DDL statements can access and manipulate individuals partitions rather than entire tables or indexes. This is how partitioning can simplify the manageability of large database objects. Also, partitioning is entirely transparent to applications. Each partition of a table or index must have the same logical attributes, such as column names, datatypes, and constraints, but each partition can have separate physical attributes such as pctfree, pctused, and tablespaces. Partitioning is useful for many different types of applications, particularly applications that manage large volumes of data. OLTP systems often benefit from improvements in manageability and availability, while data warehousing systems benefit from performance and manageability.

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice