1Z0-515 Online Practice Questions and Answers

Correct Answer: B

Explanation:

Reference partitioning is a partitioning method introduced in Oracle 11g. Using reference partitioning, a

child table can inherit the partitioning characteristics from a parent table.

Correct Answer: D

Explanation:

There is no practical limit to number of cells that can be in the grid.

References:

Correct Answer: B

Explanation:

The database automatically invalidates a cached result whenever a transaction modifies the data or

metadata of any of the database objects used to construct that cached result.

Note: DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete,

insert and update data in database. References:

Correct Answer: A

Explanation: 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. References:

Correct Answer: A

Explanation: Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Oracle provides a rich variety of partitioning strategies and extensions to address every business requirement. Moreover, since it is entirely transparent, partitioning can be applied to almost any application without the need for potentially expensive and time consuming application changes.

References:

Correct Answer: A

Explanation: Data Mining and Data Warehousing Data can be mined whether it is stored in flat files, spreadsheets, database tables, or some other storage format. The important criteria for the data is not the storage format, but its applicability to the problem to be solved. Proper data cleansing and preparation are very important for data mining, and a data warehouse can facilitate these activities. However, a data warehouse will be of no use if it does not contain the data you need to solve your problem. Oracle Data Mining requires that the data be presented as a case table in single-record case format. All the data for each record (case) must be contained within a row. Most typically, the case table is a view that presents the data in the required format for mining Note: Oracle Warehouse Builder (OWB) enables the design and deployment of enterprise data warehouses, data marts, and e-business intelligence applications.

References:

Correct Answer: B

Explanation: 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

References:

Correct Answer: A

Explanation: References:

Correct Answer: A

Explanation: Adaptive Parallelism: The adaptive multiuser algorithm, which is enabled by default, reduces the degree of parallelism as the load on the system increases. When using the Oracle Database adaptive parallelism capabilities, the database uses an algorithm at SQL execution time to determine whether a parallel operation should receive the requested DOP or have its DOP lower to ensure the system is not overloaded. In a system that makes aggressive use of parallel execution by using a high DOP, the adaptive algorithm adjusts the DOP down when only a few operations are running in parallel. While the algorithm still ensures optimal resource utilization, users may experience inconsistent response times. Using solely the adaptive parallelism capabilities in an environment that requires deterministic response times is not advised. Adaptive parallelism is controlled through the database initialization parameter PARALLEL_ADAPTIVE_MULTI_USER.

References:

Correct Answer: BD

Explanation:

Data warehouses often use denormalized or partially denormalized schemas (such as a star schema) to

optimize query performance.

Note: A materialized view is a pre-computed table comprising aggregated or joined data from fact and

possibly dimension tables. Also known as a summary or aggregate table.

References: