Correct Answer: B

Explanation:

Reference partitioning is a partitioning method introduced in Oracle 11g. Using reference partitioning, a

child table can inherit the partitioning characteristics from a parent table.

Correct Answer: D

Explanation:

GOTOs cannot be used within the Oracle Data Integrator.

References:

Correct Answer: B

Explanation:

Substring functions are not analytic.

Correct Answer: A

Explanation: CTAS refers to a CREATE TABLE AS statement - a new table is created and populated with row from a specified query.

The most common uses of CTAS are in these scenarios:

*

Creating a table identical to another table in structure, but with a filter criteria applied to its data.

*

Creating a table with small structural differences from an existing table.

For best performance use Direct Path Load. The conventional path uses standard insert statements whereas the direct path loader loads directly into the Oracle data files and creates blocks in Oracle database block format. During direct-path INSERT operations, the database appends the inserted data after existing data in the table. Data is written directly into datafiles, bypassing the buffer cache. Free space in the existing data is not reused, and referential integrity constraints are ignored. These procedures combined can enhance performance.

References:

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:

Correct Answer: C

Explanation:

Classification is a data mining function that assigns items in a collection to target categories or classes. The goal of classification is to accurately predict the target class for each case in the data. For example, a

classification model could be used to identify loan applicants as low, medium, or high credit risks.

The simplest type of classification problem is binary classification. In binary classification, the target

attribute has only two possible values: for example, high credit rating or low credit rating

Note:

Oracle Data Mining provides the following algorithms for classification:

*

Decision Tree

Decision trees automatically generate rules, which are conditional statements that reveal the logic used to

build the tree.

*

Naive Bayes

Naive Bayes uses Bayes' Theorem, a formula that calculates a probability by counting the frequency of

values and combinations of values in the historical data.

*

Generalized Linear Models (GLM)

GLM is a popular statistical technique for linear modeling. Oracle Data Mining implements GLM for binary

classification and for regression. GLM provides extensive coefficient statistics and model statistics, as well

as row diagnostics. GLM also supports confidence bounds.

*

Support Vector Machine

Support Vector Machine (SVM) is a powerful, state-of-the-art algorithm based on linear and nonlinear

regression. Oracle Data Mining implements SVM for binary and multiclass classification.

References:

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

Explanation: Data warehouses often use denormalized or partially denormalized schemas (such as a star schema) to optimize query performance. On the other hand OLTP (Online Transaction Processing) systems often use fully normalized schemas to optimize update/insert/delete performance, and to guarantee data consistency.

References: