Latesttests
2018 Jan Oracle Official New Released 1z0-485
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-485.html

Oracle Exadata Database Machine 2014 Implementation Essentials

Question No: 31

How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?

  1. Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.

  2. Using partition pruning can force the optimizer to use that method instead of Smart Scan. Partitioning in Exadata should be used wisely,

  3. Partition pruning is not a supported option in the 11gR2 database code that runs on an Exadata Machine, due to issues with Cost Based Optimizer plans.

  4. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.

  5. Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.

Answer: A

Explanation: Partition pruning allows you to reduce a 5TB I/O operation to a much smaller I/O operation and therefore much faster return of the information.

Question No: 32

Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.

  1. B. Activate all cores by using a software command. Activate all hard drives and flash drives.

    Create the grid disks.

    Expand the Oracle ASM diskgroups. Review the new configuration.

  2. C. Remove the doors of the 1/8th rack.

    Add an additional Sun Datacenter InfiniBand Switch. Add the new servers.

    Cable the Database Servers in the rack.

    Cable the Exadata Storage Servers in the rack. Close the rack.

    Configure the new hardware.

  3. D. Activate all cores by using a software command. Activate all hard drives and flash drives.

Answer: B

Explanation: Not A: no need to remove doors. Not C: No additional Infiband Switch needed. Note:

Latesttests 2018 PDF and VCE

  • Database Machine Upgrades

  • Database Machine Components and Upgradeability

  • Latesttests 2018 PDF and VCE

    Question No: 33

    Which is a best practice for High Availability (HA) in an Exadata environment?

    1. Checksums performed on the Exadata Storage Server ensure logical consistency of block content.

    2. When a standby database is in place, DB_BLOCK_CHECKING is not required and thus not recommended.

    3. Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.

    4. Due to the different architecture that Exadata has with storage servers, compared to regular Storage Area Network, DB_LOST_WRITE_PROTECT need not be set.

    5. Stretched RAC is the best alternative for Exadata that combines both HA and DR into one.

    Answer: C

    Explanation: Exadata storage cells include Oracle Hardware Assisted Resilient Data (HARD) to provide a

    unique level of validation for Oracle block data structures such as data block address, checksum.

    and magic numbers prior to allowing a write to physical disks. HARD validation with Exadata is

    automatic (setting DB_BLOCK_CHECKSUM is required to enable checksum validation). The

    HARD checks transparently handle all cases including Oracle ASM disk rebalance operations and disk failures.

    Incorrect:

    Not A: The checksum is used to validate that a block is not physically corrupt, detecting corruptions caused by underlying disks, storage systems, or I/O systems. Checksums do not ensure logical consistency of the block contents.

    Not B: MAA recommends that you set DB_BLOCK_CHECKING=MEDIUM or FULL on the physical standby as a minimum practice to prevent the standby from various logical block corruptions.

    Not D: The recommendation is:

    On the primary database: DB_LOST_WRITE_PROTECT=TYPICAL (default TYPICAL on Exadata) On the Data Guard Physical Standby Database: DB_LOST_WRITE_PROTECT=TYPICAL Not E: Protection from a broad range of, but not all disasters

    While not a full disaster recovery (DR) solution, an Extended Distance

    Oracle RAC or Oracle RAC One Node deployment will provide protection from a broad range of

    disasters. For a full DR protection Oracle recommends deploying an Oracle RAC together with a local and a remote Oracle Data Guard setup as described in the Maximum Availability Architecture (MAA).

    Question No: 34

    Which Exadata feature uses Flash as a parallel write cache to Disk Controller Cache?

    1. Exadata DRAM

    2. InfiniBand network cache

    3. high performance SAS disks

    4. Smart Flash Log

    5. Hybrid Columnar Compression

    Answer: D

    Explanation: Smart Flash Logging takes advantage of the flash memory in Exadata storage to speed up log writes.

    Question No: 35

    The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-image with an Oracle Support installation image.

    Which three tasks would you need to perform to re-image the compute node?

    1. Mount the LVM backup image across the network and recover the system.

    2. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.

    3. Create a CELLBOOT USB Flash Drive using an external USB drive.

    4. Reboot the new server using a bootable recovery image from the external USB drive.

    5. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).

    Answer: B,C,E

    Explanation: C: Exadata provides a way for you to create your own CELLBOOT USB. All you have to is plug-in a USB disk which should be at least 1 GB and run the tool:

    $ /opt/oracle.SupportTools/make_cellboot_usb

    Exadata turns your USB disk into a bootable disk of active image of your system.

    Question No: 36

    You are asked to enable Write Back Flash Cache for one of your customers X3-2 Full Rack in a rolling fashion. Put the following steps in the right order:

    1. Set flashCacheMode to writeback.

    2. Inactivate all grid disks and shut down cellsrv.

    3. Drop the Flash Cache.

    4. Verify that cell for flashcacheMode is writeback.

    5. Create the Flash Cache.

    6. Start up cellsrv and activate all grid disks.

    7. Check grdidksk asmdeactivationoutcome and asmmodestatus for all grid disks to ensure that all grid disks on all cells are set to Yes and online, respectively.

    1. G. B, C, A, F, E, D, and G

    2. G, A, B, C, F, E, D, and G

    3. G, C, B, A, F, E, D, and G

    4. G, E, C, B, F, A, D, and G

    Answer: C

    Explanation: Steps for Enabling Write back flash cache:

    First of all,you don’t need the stop CRS or database (This is ROLLING method) ,you can do it cell by cell.

    • (C) drop flashcache

      CellCLIgt; drop flashcache

      Flash cache owtcel03_FLASHCACHE successfully dropped

    • (G) Be sure asmdeactivationoutcome is YES is before disabling grid disk

    lt;/pregt;

    CellCLIgt; list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

    * (B)

    CellCLIgt; alter griddisk all inactive

    Question No: 37

    Which statement is true about the patching features provided in Platinum Services?

    1. Patching services are available for the full software stack up to twice per year.

    2. Patching support includes Exadata, Exalogic, and Database Appliance.

    3. Rolling window and complete down time approaches are two options to patching.

    4. Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

      Answer: D

      Explanation: * Patch Deployment: Oracle Platinum Services also includes patching services in which Oracle

      applies patches to covered systems four times (not A) per year via the Oracle Advanced Support

      Gateway. We work collaboratively with customers to assess, analyze, plan and deploy updates

      and patches to mitigate risks and complications. Through this continuous improvement, customers can experience greater system performance, availability, and security.

      * not B: Oracle Platinum Services provides enhanced support for high availability and performance to Oracle Premier Support customers

      running certified configurations of Oracle Exadata Database Machine, Oracle Exalogic Elastic Cloud, or Oracle SuperCluster-

      at no additional cost.

      Question No: 38

      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.

      Question No: 39

      Identify four significant changes when a backup of Exadata compute nodes must be performed.

      1. application of operating system patches

      2. before shutdown to preserve storage indexes

      3. application of Oracle patches

      4. reconfiguration of significant operating system parameters

      5. installation or reconfiguration of significant non-Oracle software

      6. storage server rebalancing

      7. addition of an Exadata storage expansion rack

    Answer: A,C,D,G

    Question No: 40

    Which table compression technique will not work on Exadata without licensing the Oracle Advanced Compression Option?

    1. COMPRESS

    2. COMPRESS BASIC

    3. COMPRESS FOR OLTP

    4. COMPRESS FOR QUERY

    5. COMPRESS FOR ARCHIVE

    Answer: C

    Explanation: OLTP Table Compression is a part of the Oracle Advanced Compression option, which requires a license in addition to the Enterprise Edition.

    100% Free Download!
    Download Free Demo:1z0-485 Demo PDF
    100% Pass Guaranteed!
    Download 2018 Latesttests 1z0-485 Full Exam PDF and VCE

    Latesttests 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

    2018 Latesttests IT Certification PDF and VCE

    Comments are closed.