Free 1z0-902 – Oracle Exadata Database Machine X9M Implementation Essentials Practice Test Question

Select all that apply, then click Submit answer.

• ○

  OS I/O metrics using Enterprise Manager host pages for the storage servers

• ○

  OS I/O metrics using OS tools such as iostat on the database servers

• ○

  I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod
  database instances using SQL *p1us

• ○

  cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

• ○

  OS I/O metrics using OS tools such as iostat on the storage servers

Select all that apply, then click Submit answer.

• ○

  changing the root password

• ○

  upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

• ○

  installing an alternative package manager

• ○

  upgrading the Storage Server software package using rpm

• ○

  configuring secure shell user equivalency for the cellmonitor user

Select all that apply, then click Submit answer.

• ○

  CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

• ○

  CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server

• ○

  'crsct1 stop cluster -all' on one of the database servers

• ○

  CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server

• ○

  CellCLI alter GRIDDISK all inactive on the affected storage server

• ○

  shutdown -h now' on the affected storage server

Select all that apply, then click Submit answer.

• ○

  YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

• ○

  You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.

• ○

  You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

• ○

  You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.

Select all that apply, then click Submit answer.

• ○

  Failed storage server updates are automatically rolled back to a previous release.

• ○

  To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.

• ○

  Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum —exclude option.

• ○

  For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.

• ○

  Failed database server updates are rolled back to a working state on a previous release automatically.

• ○

  When running a "yum update" for a new Exadata release, all other repositories should be disabled.

Select an option, then click Submit answer.

• ○

  2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.

• ○

  1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.

• ○

  1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.

• ○

  3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.

• ○

  1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.

Select an option, then click Submit answer.

• ○

  dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*’”

• ○

  dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP’ ”

• ○

  dbmcli -e "LIST IBPORT DETAIL"

• ○

  dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"

Select an option, then click Submit answer.

• ○

  Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.

• ○

  Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

• ○

  They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

• ○

  Extended Redundancy mirrors data across data centers providing the highest levels of data protection.

Select an option, then click Submit answer.

• ○

  Ask the system administrator to replace the broken disk with a spare.

• ○

  Check the database to see if any rebalance operations are active.

• ○

  Call Oracle Support and make an appointment so that the drive can be replaced.

• ○

  Wait for the email of the failure that Exadata or Enterprise Manager will send.

• ○

  Download and run the latest exadiag tool.

• ○

  Wait for a blue light to appear on the disk if the rebalance operation is running.

Select an option, then click Submit answer.

• ○

  Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

• ○

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

• ○

  The rolling and complete down time approaches are two options to patching.

• ○

  Patching is done automatically during business hours.