← Back to exam page

1z0-902 – Oracle Exadata Database Machine X9M Implementation Essentials

Loading demo links...

Showing 4–6 of 10 questions

Question 4

You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.

Which two actions are NOT appropriate for that purpose?

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.
Question 5

Which two statements are true about applying updates on Exadata systems?

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.
Question 6

Examine this list of software components:

1. Oracle KVM Guest

2. Oracle Enterprise Manager Agent (OMA)

3. ASM instance

4. RDBMS instance

5. Automatic Diagnostic Repository Command Interpreter (ADRCI)

6. CELLCLI

7. Cell Server(CELLSRV)

8. diskmon

9. Restart Server (RS)

10. Management Server (MS)

What is the correct location where these software components can run in the standard Exadata Database Machine deployment?

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.