1Z0-515 Online Practice Questions and Answers

Correct Answer: D

Explanation:

Oracle Database Resource Management (DRM) provides tools that allow any Oracle DBA to manage a

database server's CPU resources effectively for application user groups and during different resource

demand periods.

DRM consists of four basic components:

*Resource Consumer Groups (not A). A resource consumer group is a collection of users with similar

requirements for resource consumption. Users can be assigned to more than one resource consumer

group, but each user's active session can only be assigned to one resource consumer group at a time.

*Resource Plans (not C). In its simplest form, a resource plan describes the resources allocated to one or

more resource consumer group(s).

*Resource Plan Directives (not B). Resource plan directives allocate resources among the resource

consumer groups in the resource plan. Essentially, directives connect resource consumer groups or

subplans to their resource plans.

* SYSTEM_PLAN. Oracle supplies an initial, default resource plan named SYSTEM_PLAN. This plan implements a CPU utilization resource allocation method to divide and prioritize CPU resources to three resource consumer groups

Correct Answer: B

Explanation: Information Lifecycle Management (ILM) is a set of policies and procedures for managing data during its lifetime. The ILM Assistant manages information by recommending the correct placement of data on logical storage tiers as specified by a lifecycle definition, where a lifecycle definition describes the stages and storage tiers that data resides on during its lifetime. Each stage specifies a retention period during which the data resides on a logical storage tier. A logical storage tier is a collection of Oracle tablespaces in which partitions may reside.

Note: Information today comes in a wide variety of types, for example an E-mail message, a photograph, or an order in an Online Transaction Processing System. Therefore, once you know the type of data and how it will be used, you already have an understanding of what its evolution and final destiny is likely to be.

One of the challenges facing each organization is to understand how its data evolves and grows, monitor how its usage changes over time, and decide how long it should survive, while adhering to all the rules and regulations that now apply to that data. 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 stage in the lifecycle of the data.

References:

Correct Answer: A

Explanation:

Partition-wise joins reduce query response time by minimizing the amount of data exchanged among

parallel execution servers when joins execute in parallel. This significantly reduces response time and

improves the use of both CPU and memory resources. In Oracle Real Application Clusters (RAC)

environments, partition-wise joins also avoid or at least limit the data traffic over the interconnect, which is

the key to achieving good scalability for massive join operations.

Partition-wise joins can be full or partial. Oracle decides which type of join to use.

References:

Correct Answer: C

Explanation:

Association is a data mining function that discovers the probability of the co-occurrence of items in a

collection. The relationships between co-occurring items are expressed as association rules.

Market-Basket Analysis

Association rules are often used to analyze sales transactions. For example, it might be noted that

customers who buy cereal at the grocery store often buy milk at the same time. In fact, association

analysis might find that 85% of the checkout sessions that include cereal also include milk. This

relationship could be formulated as the following rule.

Cereal implies milk with 85% confidence

This application of association modeling is called market-basket analysis. It is valuable for direct

marketing, sales promotions, and for discovering business trends. Market-basket analysis can also be

used effectively for store layout, catalog design, and cross-sell.

Association Algorithm

Oracle Data Mining uses the Apriori algorithm to calculate association rules for items in frequent itemsets.

References:

Correct Answer: A

Explanation: References:

Correct Answer: B

Explanation:

DBMS_CUBE PL/SQL Package. In Database 11gR2, a new feature was added that allows cubes and

dimensions to be entirely defined via PL/SQL calls, thus making it a much simpler job to automate the

creation and refresh of cubes within the context of an application.

Correct Answer: B

Explanation: Oracle Data Integrator streamlines the highperformance movement and transformation of data between disparate systems in batch, real-time, synchronous, and asynchronous modes. Knowledge Modules are at the core of the Oracle Data Integrator architecture. They make all Oracle Data Integrator processes modular, flexible, and extensible. Knowledge Modules implement the actual data flows and define the templates for generating code across the multiple systems involved in each process. Knowledge Modules are generic, because they allow data flows to be generated regardless of the transformation rules. And they are highly specific, because the code they generate and the integration strategy they implement are finely tuned for a given technology. Oracle Data Integrator provides a comprehensive library of Knowledge Modules, which can be tailored to implement existing best practices (for example, for highest performance, for adhering to corporate standards, or for specific vertical know-how). By helping companies capture and reuse technical expertise and best practices, Oracle Data Integrator's Knowledge Module framework reduces the cost of ownership. It also enables metadata-driven extensibility of product functionality to meet the most demanding data integration challenges.

References:

Correct Answer: C

Explanation:

Compression is useful because it helps reduce the consumption of resources such as data space or

transmission capacity. Because compressed data must be decompressed to be used, this extra

processing imposes computational or other costs through decompression.

Correct Answer: C

Explanation:

All metadata for cubes and dimensions is stored in the Oracle database.

References:

Correct Answer: B

Explanation: After you connect to your data sources in Oracle Warehouse Builder (including Oracle databases, sources accessed through gateways, and flat file sources) you can apply full-featured data profiling to generate statistics about data quality, and to discover complex patterns, foreign key relationships, and functional dependencies. You can then design complex data rules and create data auditors to monitor compliance with those rules in any source or target system in your landscape, regardless of whether those sources are loaded using Oracle Warehouse Builder or other ETL tools.

For customers who have selected solutions other than Oracle Warehouse Builder for data profiling and data quality, these can be applied independently of Oracle Warehouse Builder ETL and design features.

Note: Oracle Warehouse Builder is a full-featured data integration, data warehousing, data quality and metadata management solution designed for the Oracle database. Oracle Warehouse Builder is an integral part of Oracle Database 11g Release 2 (11.2) and is installed as part of every database installation (other than Oracle Database XE).

The major feature areas of Oracle Warehouse Builder include: *Data modeling *Extraction, Transformation, and Load (ETL) *Data profiling and data quality *Metadata management *Business-level integration of ERP application data *Integration with Oracle business intelligence tools for reporting purposes *Advanced data lineage and impact analysis Oracle Warehouse Builder is also an extensible data integration and data quality solutions platform. Oracle Warehouse Builder can be extended to manage metadata specific to any application, and can integrate with new data source and target types, and implement support for new data access mechanisms and platforms, enforce your organization's best practices, and foster the reuse of components across solutions.

References: