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

Explanation:

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

divides a large join into smaller joins between a pair of partitions from the two joined tables. To use this

feature, you must equipartition both tables on their join keys, or use reference partitioning.

Oracle Database can perform partial partition-wise joins only in parallel. Unlike full partition-wise joins,

partial partition-wise joins require you to partition only one table on the join key, not both tables.

Note: 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.

References:

Correct Answer: B

Explanation:

Oracle benchmarks claim that bitmap join indexes can run a query more than eight times faster than

traditional indexing methods.

However, this speed improvement is dependent upon many factors, and the bitmap join is not a panacea.

Some restrictions on using the bitmap join index include:

The indexed columns must be of low cardinality--usually with less than 300 distinct values. The query must

not have any references in the WHERE clause to data columns that are not contained in the index.

The overhead when updating bitmap join indexes is substantial. For practical use, bitmap join indexes are

dropped and rebuilt each evening about the daily batch load jobs. This means that bitmap join indexes are

useful only for Oracle data warehouses that remain read-only during the processing day.

References:

Correct Answer: A

Explanation:

Note:

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.

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

Explanation:

Data Mining can provide valuable results:

*Predict customer behavior (Classification) (not B)

*Predict or estimate a value (Regression)

*Segment a population (Clustering)

*Identify factors more associated with a business

problem (Attribute Importance) (not D)

*

Find profiles of targeted people or items (Decision Trees)

*

Determine important relationships and market baskets within the population (Associations)

*

Find fraudulent or rare events (Anomaly Detection) (not A)

References:

Correct Answer: A

Explanation: Data that cannot be meaningfully interpreted as numerical or categorical is considered unstructured for purposes of data mining. It has been estimated that as much as 85% of enterprise data falls into this category. Extracting meaningful information from this unstructured data can be critical to the success of a business.

Unstructured data may be binary objects, such as image or audio files, or text objects, which are language-based. Oracle Data Mining supports text objects. Text must undergo a transformation process before it can be mined. Once the data has been properly transformed, the case table can be used for building, testing, or scoring data mining models. Most Oracle Data Mining algorithms support text

References:

Correct Answer: A

Explanation: Conventional "Extract, Transform, Load" (ETL) tools closely intermix data transformation rules with integration process procedures, requiring the development of both data transformations and data flow. Oracle Data Integrator (ODI) takes a different approach to integration by clearly separating the declarative rules (the "what") from the actual implementation (the "how"). With ODI, declarative rules describing mappings and transformations are defined graphically, through a drag-and-drop interface, and stored independently from the implementation. ODI automatically generates the data flow, which can be fine-tuned if required. This innovative approach for declarative design has also been applied to ODI's framework for Changed Data Capture. ODI's CDC moves only changed data to the target systems and can be integrated with Oracle GoldenGate, thereby enabling the kind of real time integration that businesses require.

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

Explanation:

Oracle Business Intelligence Enterprise Edition is most commonly used with the Oracle Database using

SQL as the query language. Although the OLAP cube is a multidimensional data type, it is represented in

the Oracle database as a collection of relational views and is easily queried by SQL.

Note #1: The wording of the question is strange. SQL can be used and is the first choice. So it seems to

be the best answer.

Note #2: Oracle Business Intelligence Enterprise Edition (OBI EE) is a product suite based on the OBI EE

Server. The OBI EE Server can map a logical business model to many different physical data sources and

present the logical model for query to variety of client applications including Interactive Dashboards,

Answers and Oracle Business Intelligence Plug-in for Microsoft Office.

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:

Correct Answer: B

Explanation: You can use Analytic Workspace Manager for creating measures, dimensions and cubes in the OLAP database if the database was installed with the OLAP option. Workspace Manager, a feature of Oracle Database, enables application developers and DBAs to manage current, proposed and historical versions of data in the same database.

Note: Applications and DBA operations often work with more than one version of the data. Three common reasons to have multiple data versions are concurrency, auditing and scenario creation. Oracle Workspace Manager provides workspaces as a virtual environment to isolate a collection of changes to production data, keep a history of changes to data and create multiple data scenarios for "what if" analysis. It can save money, time and labor over traditional approaches.

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: