Oracle Others Oracle Certifications 1Z0-515 Questions & Answers

• Question 31:

  You are looking to create a RAC cluster to deliver high performance for your client's data warehouse. Which statement is true about a configuration with a few large nodes versus a configuration with many smaller nodes?

  A. A few large nodes always perform better than many small nodes.

  B. A few large nodes always perform worse than many small nodes.

  C. It depends on the workload specifics and the effect of a node failure.

  D. Performance should be the same with either option.

  Correct Answer: D

  Explanation:

• Question 32:

  Which is NOT an available composite partition in Oracle Database 11g?

  A. range-list

  B. list-list

  C. list-range

  D. interval-hash

  Correct Answer: D

  Explanation:

  Extended Composite Partitioning

  In previous releases of Oracle, composite partitioning was limited to Range-Hash and Range-List

  partitioning. Oracle 11g Release 1 extends this to allow the following composite partitioning schemes:

  Range-Hash (available since 8i)

  Range-List (available since 9i)

  Range-Range

  List-Range

  List-Hash

  List-List

  Note: inverval-hash is a valid Interval partitioning.

  References:

• Question 33:

  Which questions CANNOT be addressed by Oracle Data Mining?

  A. Fraud detection

  B. Prediction of customer behavior

  C. Root cause de

  D. Identify factors associated with a business problem

  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:

• Question 34:

  Indentify the dimension that appears most often in queries in a data warehouse.

  A. Product dimension

  B. Time dimension

  C. Cost dimension

  D. Location dimension

  Correct Answer: B

  Explanation: In a data warehouse, a dimension is a data element that categorizes each item in a data set into non-overlapping regions. A data warehouse dimension provides the means to "slice and dice" data in a data warehouse. Dimensions provide structured labeling information to otherwise unordered numeric measures. For example, "Customer", "Date", and "Product" are all dimensions that could be applied meaningfully to a sales receipt. A dimensional data element is similar to a categorical variable in statistics. The primary function of dimensions is threefold: to provide filtering, grouping and labeling. For example, in a data warehouse where each person is categorized as having a gender of male, female or unknown, a user of the data warehouse would then be able to filter or categorize each presentation or report by either filtering based on the gender dimension or displaying results broken out by the gender.

• Question 35:

  You can perform what-if analysis of potential changes with Oracle Warehouse Builder.

  A. TRUE

  B. FALSE

  Correct Answer: A

  Explanation: The Metadata Dependency Manager (MDM) enables you to plan your project by previewing the impact of the changes or future changes for "what-if" analysis. When you plan to introduce changes to your source systems, you can gauge the impact of that change on your warehouse design. If changes have already been introduced, then you can plan the time required to update your ETL design and rebuild your data warehouse.

  References:

• Question 36:

  Which unique method of improving performance is NOT used by the Oracle Exadata Database Machine?

  A. Flash to improve query performance

  B. Reduces the amount of data required to flow through I/O

  C. Increases the I/O using InfiniBand

  D. Performs analysis in a special in-memory database

  Correct Answer: D

  References:

• Question 37:

  Which Oracle option might be used to encrypt sensitive data in an Oracle data warehouse?

  A. Active Data Guard

  B. Total Recall

  C. Advanced Security Option

  D. Virtual Private Database

  Correct Answer: C

  Explanation: Oracle Advanced Security is an option to the Oracle Database 11g Enterprise Edition that helps address privacy and regulatory requirements including the Payment Card Industry Data Security Standard (PCIDSS), Health Insurance Portability and Accountability Act (HIPAA), and numerous breach notification laws. Oracle Advanced Security provides data encryption and strong authentication services to the Oracle database, safeguarding sensitive data against unauthorized access from the network and the operating system. It also protects against theft, loss, and improper decommissioning of storage media and database backups.

  References:

• Question 38:

  Knowledge Modules are:

  A. Reusable code templates for Oracle Data Integrator

  B. Prebuilt applications for Oracle Business Intelligence

  C. Options for Oracle Enterprise Manager

  D. Algorithms for data mining

  Correct Answer: A

  Explanation:

  Knowledge modules (KMs) in Oracle Data Integrator are components that implement reusable

  transformation and ELT (extract, load, and transform) strategies across different technologies.

  References:

• Question 39:

  What two types of results can be cached in the Result Set Cache?

  A. Results of an SQL query

  B. Results from a PL/SQL function

  C. Sequence object results

  D. Result sets derived from data dictionary tables

  Correct Answer: AB

  Explanation:

  Your applications sometime send repetitive queries to the database. To improve the response time of

  repetitive queries, results of queries, query fragments, and PL/SQL functions can be cached in memory. A

  result cache stores the results of queries shared across all sessions. When these queries are executed

  repeatedly, the results are retrieved directly from the cache memory.

  You must annotate a query or query fragment with a result cache hint to indicate that results are to be

  stored in the query result cache.

  The query result set can be cached in the following ways:

  *

  Server-side Cache

  *

  Client Result Cache

  Oracle Database 11g Release 1 (11.1) provides support for server-side Result Set caching for both JDBC types. The server-side result cache is used to cache the results of the current queries, query fragments, and PL/SQL functions in memory and then to use the cached results in future executions of the query, query fragment, or PL/SQL function. The cached results reside in the result cache memory portion of the SGA. A cached result is automatically invalidated whenever a database object used in its creation is successfully modified. The server-side caching can be of the following two types:

  *

  SQL Query Result Cache (A)

  *

  PL/SQL Function Result Cache (B)

• Question 40:

  Which feature would enable higher availability during maintenance operations while also improving query response performance?

  A. Partitioning

  B. Materialized views

  C. Bitmap Indexing

  D. OLAP

  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: