1Z0-515 Online Practice Questions and Answers

Correct Answer: C

Explanation:

SYSDATE produces a new value every time it is used. Caching such a value would make no sense.

Correct Answer: D

Explanation:

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

References:

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

Explanation: Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries - producing results with speed of thought response times. This outstanding query performance may be leveraged transparently when deploying OLAP cubes as materialized views enhancing the performance of summary queries against detail relational tables. Because Oracle OLAP is embedded in Oracle Database 11g, it allows centralized management of data and business rules in a secure, scalable and enterprise-ready platform.

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

Explanation:

In this scenario the disk subsystem is the bottleneck. It determines the throughput.

Note: Each of the components must provide sufficient I/O bandwidth to ensure a well-balanced I/O system.

The end-to-end I/O system consists of more components than just the CPUs and disks. A well-balanced I/

O system must provide approximately the same bandwidth across all components in the I/O system.

These components include:

*

Host bus adapters (HBAs), the connectors between the server and the storage.

*

Switches, in between the servers and a storage area network (SAN) or network attached storage (NAS).

*

Ethernet adapters for network connectivity (GigE NIC or Infiniband). In an Oracle Real Application Clusters (Oracle RAC) environment, you need an additional private port for the interconnect between the nodes that you should not include when sizing the system for I/O throughput. The interconnect must be sized separately, taking into account factors such as internode parallel execution.

*

Wires that connect the individual components.

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