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:

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

Explanation:

Advanced Compression features in Oracle Database 11g include:

* Online Transaction Processing (OLTP) Table Compression: This breakthrough compression feature compresses table data during all types of data manipulation operations, including conventional INSERT or UPDATE. OLTP Table Compression leverages a sophisticated and intelligent algorithm that minimizes compression overhead during write operations, thereby making it viable for highly transactional workloads

References: