1Z0-515 Exam Questions & Answers

Correct Answer: A

The SQL Access Advisor was introduced in Oracle 10g to make suggestions about additional indexes and materialized views which might improve system performance. Oracle 11g has made two significant changes to the SQL Access

Advisor:

The advisor now includes advice on partitioning schemes that may improve performance. The original workload manipulation has been deprecated and replaced by SQL tuning sets.

Correct Answer: A

If your priority is manageability, use a local index.

Local partitioned indexes are easier to manage than other types of partitioned indexes. They also offer greater availability and are common in DSS environments. The reason for this is equipartitioning: each partition of a local index is

associated with exactly one partition of the table. This enables Oracle to automatically keep the index partitions in sync with the table partitions, and makes each table-index pair independent. Any actions that make one partition's data invalid

or unavailable only affect a single partition.

Local partitioned indexes support more availability when there are partition or subpartition maintenance operations on the table. A type of index called a local nonprefixed index is very useful for historical databases. In this type of index, the

partitioning is not on the left prefix of the index columns.

Correct Answer: B

Advanced compression:

Advanced Compression, an option introduced in Oracle Database 11 g Enterprise Edition, offers a comprehensive set of compression capabilities to help organizations reduce costs, while maintaining or improving performance. It significantly

reduces the storage footprint of databases through compression of structured data (numbers, characters) as well as unstructured data (documents, spreadsheets, XML and other files). It provides enhanced compression for database backups

and also includes network compression capabilities for faster synchronization of standby databases.

Archival Compression:

*

Built on HCC technology

*

Compression algorithm optimized for maximum storage savings

*

Benefits any application with data retention requirements

*

Best approach for ILM and data archival

Partitioning:

There are a number of benefits to partitioning data. Partitioning provides an easy way to distribute the data across appropriate storage devices depending on its usage, while still keeping the data online and stored on the most cost-effective

device. Since partitioning is completely transparent to anyone accessing the data, no application changes are required, thus partitioning can be implemented at any time.

Note There is a wide variety of information held in an organization today, for example it could be an email message, a picture, or an order in an Online Transaction Processing System. Therefore, once the type of data being retained has been

identified, you already have an understanding of what its evolution and final destiny is likely to be.

The challenge now before all organizations, is to understand how their data evolves and grows, monitor how its usage changes over time, and decide how long it should survive. In addition, the evolving rules and regulations such as

Sarbanes-Oxley, place additional constraints on the data that is being retained and some organizations now require that data is deleted when there is no longer a legal requirement to keep it, to avoid expensive e-discovery when the data is

requested for a legal matter. Implementing ILM using Oracle Database 11g Page 4 Information Lifecycle Management (ILM) is designed to address these issues, with

a combination of processes, policies, software and hardware so that the appropriate technology can be used for each phase of the lifecycle of the data.1