Oracle Others Oracle Certifications 1Z0-515 Questions & Answers

• Question 11:

  Identify the statement about ASM that is NOT true.

  A. ASM is easier to manage than file systems.

  B. ASM delivers the performance of raw partitions.

  C. ASM is an extra cost option for Oracle databases.

  D. ASM delivers automatic striping and mirroring.

  Correct Answer: B

  Explanation:

  ASM is a management tool, not a RAW performance tool.

  Note:

  Automatic Storage Management (ASM) is a new feature that has be introduced in Oracle 10g to simplify

  the storage of Oracle datafiles, controlfiles and logfiles.

  Automatic Storage Management (ASM) simplifies administration of Oracle related files by allowing the

  administrator to reference disk groups rather than individual disks and files, which are managed by ASM.

  The ASM functionality is an extention of the Oracle Managed Files (OMF) functionality that also includes

  striping and mirroring to provide balanced and secure storage. The new ASM functionality can be used in

  combination with existing raw and cooked file systems, along with OMF and manually managed files.

  The ASM functionality is controlled by an ASM instance. This is not a full database instance, just the

  memory structures and as such is very small and lightweight.

  The main components of ASM are disk groups, each of which comprise of several physical disks that are

  controlled as a single unit. The physical disks are known as ASM disks, while the files that reside on the

  disks are known as ASM files. The locations and names for the files are controlled by ASM, but user-

  friendly aliases and directory structures can be defined for ease of reference. The level of redundancy and

  the granularity of the striping can be controlled using templates. Default templates are provided for each

  file type stored by ASM, but additional templates can be defined as needed.

  Failure groups are defined within a disk group to support the required level of redundancy. For two- way

  mirroring you would expect a disk group to contain two failure groups so individual files are written to two

  locations.

  In summary ASM provides the following functionality:

  *Manages groups of disks, called disk groups.

  *Manages disk redundancy within a disk group.

  *Provides near-optimal I/O balancing without any manual tuning. *Enables management of database

  objects without specifying mount points and filenames.

  *Supports large files.

  References:

• Question 12:

  Identify the statement about Oracle OLAP that is NOT true.

  A. Oracle OLAP cubes are stored in the Oracle relational database

  B. Oracle OLAP uses standard Oracle database security.

  C. Meta data for Oracle OLAP is accessible in an external data dictionary

  D. Oracle OLAP can be deployed using RAC.

  Correct Answer: C

  Explanation:

  All metadata for cubes and dimensions is stored in the Oracle database.

  References:

• Question 13:

  Identify the true statement about adaptive parallelism.

  A. It Is turned on by default.

  B. It is turned off by default.

  C. You should always leave the default setting

  D. There is no such thing.

  Correct Answer: A

  Explanation: Adaptive Parallelism: The adaptive multiuser algorithm, which is enabled by default, reduces the degree of parallelism as the load on the system increases. When using the Oracle Database adaptive parallelism capabilities, the database uses an algorithm at SQL execution time to determine whether a parallel operation should receive the requested DOP or have its DOP lower to ensure the system is not overloaded. In a system that makes aggressive use of parallel execution by using a high DOP, the adaptive algorithm adjusts the DOP down when only a few operations are running in parallel. While the algorithm still ensures optimal resource utilization, users may experience inconsistent response times. Using solely the adaptive parallelism capabilities in an environment that requires deterministic response times is not advised. Adaptive parallelism is controlled through the database initialization parameter PARALLEL_ADAPTIVE_MULTI_USER.

  References:

• Question 14:

  How many Exadata Storage Server cells are there in a Full Rack Exadata database machine configuration that has 8 Database Server nodes?

  A. 2

  B. 14

  C. 16

  D. 24

  Correct Answer: B

  Explanation:

• Question 15:

  Your customer wants to use Database Resource Manager to help ensure consistent performance based on users and operations. In designing this implementation, which limitation CANNOT be imposed through Database Resource Manager?

  A. Specifying the maximum number of concurrent operations for a resource group

  B. Limiting resource consumption for a resource group

  C. Specifying the amount of parallelism for a resource group

  D. Limiting access to particular data for a resource group

  Correct Answer: D

  Explanation:

• Question 16:

  How does compression affect resource utilization?

  A. Reduces the amount of CPU and disk utilization

  B. Increases the amount of CPU and disk utilization

  C. Reduces the amount of disk but increases CPU utilization for loading

  D. Increases the amount of disk but reduces CPU utilization for loading!

  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.

• Question 17:

  Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Cognos) will be used to query an Oracle database that includes the Oracle BI tool generate in submitting queries that might include data stored in cubes?

  A. SQL

  B. PIVSQL

  C. Proprietary API code

  D. SQL for relational and proprietary API code for OLAP

  Correct Answer: A

  Explanation:

  Oracle Business Intelligence Enterprise Edition is most commonly used with the Oracle Database using

  SQL as the query language. Although the OLAP cube is a multidimensional data type, it is represented in

  the Oracle database as a collection of relational views and is easily queried by SQL.

  Note #1: The wording of the question is strange. SQL can be used and is the first choice. So it seems to

  be the best answer.

  Note #2: Oracle Business Intelligence Enterprise Edition (OBI EE) is a product suite based on the OBI EE

  Server. The OBI EE Server can map a logical business model to many different physical data sources and

  present the logical model for query to variety of client applications including Interactive Dashboards,

  Answers and Oracle Business Intelligence Plug-in for Microsoft Office.

  References:

• Question 18:

  What are Oracle Data Integrator templates used for?

  A. To model SAP applications

  B. To define how to transform data

  C. As reports to monitor ETL activity

  D. None of these

  Correct Answer: B

  Explanation: Oracle Data Integrator streamlines the highperformance movement and transformation of data between disparate systems in batch, real-time, synchronous, and asynchronous modes. Knowledge Modules are at the core of the Oracle Data Integrator architecture. They make all Oracle Data Integrator processes modular, flexible, and extensible. Knowledge Modules implement the actual data flows and define the templates for generating code across the multiple systems involved in each process. Knowledge Modules are generic, because they allow data flows to be generated regardless of the transformation rules. And they are highly specific, because the code they generate and the integration strategy they implement are finely tuned for a given technology. Oracle Data Integrator provides a comprehensive library of Knowledge Modules, which can be tailored to implement existing best practices (for example, for highest performance, for adhering to corporate standards, or for specific vertical know-how). By helping companies capture and reuse technical expertise and best practices, Oracle Data Integrator's Knowledge Module framework reduces the cost of ownership. It also enables metadata-driven extensibility of product functionality to meet the most demanding data integration challenges.

  References:

• Question 19:

  What is the estimated maximum speed of data loads for a Quarter Rack with the Exadata Storage Server?

  A. 1 TB/hr

  B. 2 TB/hr

  C. 4 TB/hr

  D. 5 TB/hr

  E. It depends on the number of CPUs in the server.

  Correct Answer: A

  Explanation: References:

• Question 20:

  Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Plus, Business Objects and Cognos) will be used to query an Oracle database that includes the Oracle OLAP Option. What does tool generate in submitting queries that might include data stored in relational tables and OLAP cubes?

  A. SQL

  B. PL/SQL

  C. Proprietary API code

  D. SQL for relational and proprietary API code for OLAP

  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.