Oracle 1Z0-515 Online Practice Questions and Exam Preparation

Oracle 1Z0-515 Online Questions & Answers

• Question 41:

  How can you use Oracle Data Mining with Oracle Warehouse builder?

  A. To identify records to extract
  B. As a standard transform operation
  C. To increase write performance
  D. To eliminate ETL logging
  A. To identify records to extract

  ---

  Data Mining and Data Warehousing Data can be mined whether it is stored in flat files, spreadsheets, database tables, or some other storage format. The important criteria for the data is not the storage format, but its applicability to the problem to be solved. Proper data cleansing and preparation are very important for data mining, and a data warehouse can facilitate these activities. However, a data warehouse will be of no use if it does not contain the data you need to solve your problem. Oracle Data Mining requires that the data be presented as a case table in single-record case format. All the data for each record (case) must be contained within a row. Most typically, the case table is a view that presents the data in the required format for mining Note: Oracle Warehouse Builder (OWB) enables the design and deployment of enterprise data warehouses, data marts, and e-business intelligence applications.

• Question 42:

  You have analyzed your client's workload and the SQL Access Advisor in Enterprise Manager recommends that you create some materialized views to improve performance. What should you do in order to most simply implement this change?

  A. Rewrite all the queries in the application to identify materialized view
  B. Rewrite existing queries. New queries will automatically use the views.
  C. Respond positively to the Advisor to create the materialized views.
  D. Build virtual views on a third normal form schema.
  C. Respond positively to the Advisor to create the materialized views.

  ---

  Enterprise Manager provides a very simple interface for the SQL Access Advisor (Advisor Central > SQL Advisor >SQL Access Advisor). The first page allows you to create tasks to test existing indexes, materialized view and partitions, or create tasks to suggest new structures. The "Workload Source" page allows you to define the workload to associate with the task. The basic options allow the workload to be gathered from the cursor cache, an existing SQL tuning set, or a hypothetical workload based on specific schema objects. The "Recommendation Options" page allows you to define which type of recommendations you are interested in (Indexes, Materialized Views and Partitioning). After reviewing the result of the analysis you can decide if you should accept or ignore the suggested recommendations.

  Note: The SQL Access Advisor was introduced in Oracle 10g to make suggestions about additional indexes and materialized views which might improve system performance.

• Question 43:

  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
  C. Advanced Security Option

  ---

  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 (PCI- DSS), 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.

• Question 44:

  You want to enable result set caching to quickly see if this feature will help the performance of your application. Which is the quickest way to make this determination?

  A. Set RESULT_CACHE_MODE = FORCE in the initialization file.
  B. Set RESULT_CACHE = ENABLED in the initialization file.
  C. Set RESULT_CACHE_MAX_SIZE = 0.
  D. Set RESULT_CACHE = ENABLED in the initialization file and use a RESULT_CACHE hint in queries.
  A. Set RESULT_CACHE_MODE = FORCE in the initialization file.

  ---

  The RESULT_CACHE_MODE initialization parameter determines the SQL query result cache mode. The parameter specifies when a ResultCache operator is spliced into a query's execution plan. The parameter accepts the following values:

  FORCE

  The ResultCache operator is added to the root of all SELECT statements, if that is possible. However, if the statement contains a NO_RESULT_CACHE hint, then the hint takes precedence over the parameter setting.

  MANUAL

  The ResultCache operator is added, only if you use the RESULT_CACHE hint in the SQL query.

• Question 45:

  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
  A. Reusable code templates for Oracle Data Integrator

  ---

  Knowledge modules (KMs) in Oracle Data Integrator are components that implement reusable transformation and ELT (extract, load, and transform) strategies across different technologies.

• Question 46:

  Which best describes Oracle's OLAP Option for Oracle Database 11g Release 2?

  A. Is stored as relational tables and is considered a ROLAP solution
  B. Uses bitmap indexes
  C. Physically stores OLAP cubes as objects within the relational database
  D. Is available both within the Oracle Database and as a stand-alone solution
  A. Is stored as relational tables and is considered a ROLAP solution

  ---

  Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries - producing results with speed of thought response times. This outstanding query performance may be leveraged transparently when deploying OLAP cubes as materialized views enhancing the performance of summary queries against detail relational tables. Because Oracle OLAP is embedded in Oracle Database 11g, it allows centralized management of data and business rules in a secure, scalable and enterprise-ready platform.

• Question 47:

  Your customer is looking to implement ad-hoc analysis in a data warehouse. Which approach is least likely to be used assuming that the customer does not want the expense of managing view?

  A. Star schema
  B. Snowflake schema
  C. Third normal form schema
  D. OLAP
  C. Third normal form schema

  ---

  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.

• Question 48:

  Identify the control structure that would NOT be defined as part of a data flow with Oracle Data Integrator.

  A. Loops
  B. Conditions
  C. Error handling
  D. GOTOs
  D. GOTOs

  ---

  GOTOs cannot be used within the Oracle Data Integrator.

• Question 49:

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

  A. range-list
  B. list-list
  C. list-range
  D. interval-hash
  D. interval-hash

  ---

  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.

• Question 50:

  You want to create an optimally performing data warehouse hardware configuration for your customer. Which way of creating a hardware configuration will reduce the implementation time the most?

  A. Use reference configurations or an appliance-like configuration.
  B. Use the existing system and add on relevant components.
  C. Customize a configuration from a vendor.
  D. Build the system from scratch.
  A. Use reference configurations or an appliance-like configuration.

  ---

  Oracle Optimized Warehouse Reference Configurations are best practice guides to choosing the right server, storage and networking components to build an Oracle data warehouse. These best practice guides encapsulate years of configuration expertise from Oracle and its partners, helping customers take the risk out of implementing a data warehouse.