Correct Answer: B

Explanation:

Substring functions are not analytic.

Correct Answer: C

Explanation: As its name suggests, the query result cache is used to store the results of SQL queries for re-use in subsequent executions. By caching the results of queries, Oracle can avoid having to repeat the potentially time-consuming and intensive operations that generated the resultset in the first place (for example, sorting/aggregation, physical I/O, joins etc). The cache results themselves are available across the instance (i.e. for use by sessions other than the one that first executed the query) and are maintained by Oracle in a dedicated area of memory. Unlike our homegrown solutions using associative arrays or global temporary tables, the query result cache is completely transparent to our applications. It is also maintained for consistency automatically, unlike our own caching programs. References:

Correct Answer: B

Explanation:

With Oracle RAC the workload can be distributed access all cluster nodes, parallel query servers can be provided through the Parallel Query tool, and high availability can be obtained through, for example, Oracle Clusterware.

Note: Oracle RAC (Real Application Clusters) is a cluster database with a shared cache architecture that overcomes the limitations of traditional shared-nothing and shared-disk approaches to provide highly scalable and available database solutions for all your business applications. Oracle RAC is a key component of Oracle's private cloud architecture. Oracle RAC support is included in the Oracle Database Standard Edition for higher levels of system uptime. References:

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:

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.

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

Explanation:

Correct Answer: C

Explanation:

A Physical standby database replicates the exact contents of its primary database across the Oracle Net

network layer. While the physical storage locations can be different, the data in the database will be

exactly the same as the primary database.

Incorrect answer:

A, B: Logical standby databases convert the redo generated at the Primary database into data and SQL

and then re-apply those SQL transactions on the Logical standby, thus physical structures and

organization will be different from the Primary database. Users can read from logical standby databases

while the changes are being applied and, if the GUARD is set to STANDBY (ALTER DATABASE GUARD

STANDBY;), write to tables in the Logical standby database that are not being maintained by SQL Apply.

Unfortunately there are a number of unsupported objects (ie: tables or sequences owned by SYS, tables

that use table compression, tables that underlie a materialized view or Global temporary tables (GTTs))

and unsupported data types (ie: Datatypes BFILE, ROWID, and UROWID, user-defined TYPEs,

Multimedia data types like Oracle Spatial, ORDDICOM, and Oracle Text Collections (e.g. nested tables,

VARRAYs), SecureFile LOBs, OBJECT RELATIONAL XMLTypes and BINARY XML).[2] Physical standby

may be appropriate in such a case.

Correct Answer: D

Explanation:

Correct Answer: C

Explanation: A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.