[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-338 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-338
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-338.html

Oracle Exadata Database Machine and Cloud Service 2018 Implementation Essentials

Question No: 21

Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

  1. database views

  2. InfiniBand networking

  3. Flash Cache

  4. high performance SAS2 disk drives

  5. cell offloading

Answer: E

Question No: 22

What would be the best way to ensure that batch Jobs do not impact performance of online queries that use the same database?

  1. Configure IORM to disable Flash Cache usage for batch workload.

  2. Build a Database Resource Management Plan, giving priority to query workload.

  3. Deploy Instance Caging to control batch jobs.

  4. Configure and enable Parallel Query.

  5. Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workload.

Answer: B

Explanation: Using the Database Resource Manager, you can distribute available processing resources by allocating percentages of CPU time to different users and applications. In a data warehouse, a higher percentage may be given to ROLAP (relational on-line analytical processing) applications than to batch jobs.

Incorrect: not C:

In addition to controlling I/O utilization on the Exadata storage cells, Oracle also allows you to limit CPU resource utilization on the compute nodes using a technique called instance caging.

Question No: 23

Which two statements are true about troubleshooting failed patching activities?

  1. Dependency issues found during yum updates require rolling back to a previous release before retrying.

  2. Bundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.

  3. Failed OS patches on database servers can be rolled back.

  4. Failed storage cell patches are rolled back to the previous release automatically.

  5. Database server OS updates can be rolled back using opatch auto -rollback.

  6. Dependency issues found during yum updates should be ignored using the force option.

Answer: A,D

Question No: 24

Your customer wants to increase the size of the DATA diskgroup on the Exadata systems. The customer is currently using 600 GB disks. Which two are the best options that you would recommend?

  1. adding a High Capacity Storage expansion rack

  2. expanding the Exadata rack from a Half Rack to a Full Rack

  3. moving underutilized grid disks from the RECO diskgroup to DATA

  4. adding a ZFS storage appliance

  5. adding a High Performance Storage expansion rack

Answer: B,E

Question No: 25

Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata?

  1. Auto DOP is an exclusive feature in Exadata, which allows the database optimizer to evaluate each statement and run it in parallel without special hints.

  2. Auto DOP is disabled by default and must be enabled before SQL statements can take advantage of its features.

  3. Auto DOP is enabled by default on Oracle 11gR2, allowing full use of its features.

  4. Oracle#39;s Auto DOP algorithms calculate the Degree of Parallelism based on the table#39;s block counts.

  5. SQL statements that take advantage of Auto DOP am be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager#39;s Monitored SQL Executions page.

Answer: B,D,E

Explanation: B (not c): To enable the features in 11g Release 2, use the parallel_degree_policy parameter (by default this stuff is off – parameter is set to manual). For Auto DOP, setting this to limited is sufficient. If you want more functionality (in-memory parallel processing and parallel statement queuing parallel_degree_policy should be set to auto).

Incorrect: Not A:

  • What if you don’t have Exadata? Chances are that if your system is large enough to warrant Auto DOP, it is similar enough to Exadata to behave nicely with this number.

  • Auto DOP is only useful in systems with enough CPUs and disks to make concurrent parallel processing feasible. It was designed mostly for Exadata, or for systems of similar size. 48 CPUs and 84 disks sound like a nice start

    Question No: 26

    The mpstat output from OS Watcher shows a database node as being 90% idle on an average. What would you do to get a full picture of CPU utilization on the entire Exadata RAC cluster?

    1. Average the mpstat id1 output from all the nodes.

    2. Ask application users if they have noticed a slowdown in screen response.

    3. Look for an increase in batch job servicing times.

    4. A amp; B above

    Answer: A

    Question No: 27

    Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?

    1. INSERT

    2. insert with an append hint

    3. UPDATE

    4. CREATE TABLE AS SELECT

    Answer: B,D

    Explanation: To maximize storage savings with Hybrid Columnar Compression, data must be loaded using data warehouse bulk loading techniques. Examples of bulk load operations commonly used in data warehouse environments are:

  • Insert statements with the APPEND hint

  • Parallel DML

  • Direct Path SQL*LDR

  • Create Table as Select (CTAS)

    Incorrect:

    Not A, Not C: DML operations (INSERT/UPDATE) against a Hybrid Columnar Compressed table/partition can reduce the overall compression savings over time since data INSERTED/UPDATED via DML operations will not be compressed to the same ratio as data that is bulk loaded.

    Question No: 28

    Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.

    1. Transformations can be applied directly on the file data using SQL or PL/SQL constructions.

    2. External tables allow transparent parallelization inside the database.

    3. Parallelizing loads with external tables enables more efficient space management.

    4. External tables can take advantage of storage indexes to speed up data loads.

    Answer: A,C

    Explanation: Parallelizing loads with external tables enables a more efficient space management

    compared to SQL*Loader, where each individual parallel loader is an independent database sessions with its own transaction.

    Question No: 29

    Identify the three values to which the cell_flash_cache attribute can be set.

    1. read

    2. WRITE

    3. KEEP

    4. DEFAULT

    5. NONE

      Answer: C,D,E

      Explanation: There are three values the CELL_FLASH_CACHE attribute can be set to. DEFAULT specifies the cache used for a DEFAULT object is automatically managed as described in the previous section. NONE specifies that the object will never be cached. KEEP specifies the object should be kept in cache.

      Note: The CELL_FLASH_CACHE can be assigned to a database table, index, partition and LOB column.

      Question No: 30

      Storage indexes are unique to the Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:

      1. The Exadata cell services software conducts I/O requests on I MO storage regions.

      2. cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.

      3. The database is started.

      4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.

      5. A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.

      6. A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.

      7. MYOBJ_STATE’S region index is populated with high and low values for the OBJECT_ID column during the I/O request.

    A. 3. 7, 5, 2, 1, 6, and 4

    B. 3, 7, 1, 5, 6, 2, and 4

    C. 3, 6, 1. 7, 2, 5 and 4

    D. 3, 5, 1, 7, 6, 2. and 4

    Answer: D

    Explanation: 3. The database is started.

    5. A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.

    1. The Exadata cell services software conducts I/O requests on I MO storage regions.

    7. MYOBJ_STATE’S region index is populated with high and low values for the OBJECT_ID column during the I/O request.

    6. A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.

    2. cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.

    1. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.

      Note: Example:

      Step 1 (step 5 in answer): The first time that each cell’s cell services software issued an I/O request to access extents

      from the D14.MYOBJ_UNCOMP table, Exadata populated a region index for each storage index with the high and low values found for the OBJECT_ID column, based on the WHERE

      OBJECT_ID BETWEEN 100 AND 200 query predicate.

      Step 2 (step 6 in answer) : Subsequent queries against this table generated an iDB message instructing Exadata’s

      cell services software to read the same sets of extents as the first query, but in this case the

      region indexes would have been populated based on the I/Os read from the first query. Step 3: (step 2 in answer) Prior to issuing a physical disk read, cellsrv checks the high and low values stored in the

      region index and if it determines that a storage region does not contain any values meeting the query predicate, bypasses the physical I/O to the region.

      100% Ensurepass Free Download!
      Download Free Demo:1z0-338 Demo PDF
      100% Ensurepass Free Guaranteed!
      1z0-338 Dumps

      EnsurePass ExamCollection Testking
      Lowest Price Guarantee Yes No No
      Up-to-Dated Yes No No
      Real Questions Yes No No
      Explanation Yes No No
      PDF VCE Yes No No
      Free VCE Simulator Yes No No
      Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.