1z0-902

1z0-902 practice questions, page 3 of 4, with answer review and explanations.

Question 11

Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine? (Choose two.)

  1. Cell Offload Quarantine
  2. Disk Region Quarantine
  3. SQL Plan Quarantine
  4. Database Quarantine
  5. Manually created Quarantine

Question 12

Which three statements are true about Automatic Hard Disk Scrubbing and repair on high-capacity storage servers in an Exadata Database Machine? (Choose three.)

  1. Disk repair is performed immediately from Smart Flash Cache for corruption on disk when the corresponding data is clean in the Smart Flash Cache.
  2. Hard disks are scanned every two weeks by default but only when disks are idle.
  3. Hard disks are scanned every two weeks by default in all situations.
  4. Disk repair is performed immediately from Smart Flash Cache for corruption on disk when the corresponding data is dirty in the Smart Flash Cache.
  5. Disk repair may be made from another mirror copy if the corrupt area is part of a Normal or High Redundancy Disk Group.

Question 13

You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?

  1. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
  2. Copy the script to all storage servers using the DCLI command and manually execute it on all storage servers using the EXADCLI command.
  3. Copy the script to all storage servers using the DCLI command and manually execute it on each storage server using the DCLI command.
  4. Copy and execute the script on all storage servers using the EXACLI command.
  5. Copy and execute the script on all storage servers using the DCLI command.

Question 14

Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'LIST PHYSICALDISK WHERE diskType=HardDisk AND status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system. What is the next step that you should perform before you do anything else?

  1. Call Oracle Support and make an appointment so that the drive can be replaced.
  2. Download and run the latest exadiag tool.
  3. Wait for the email of the failure that Exadata or Enterprise Manager will send.
  4. Wait for a blue light to appear on the disk.
  5. Ask the system administrator to replace the broken disk with a spare.

Question 15

Which two statements describe the memory capabilities of the X9M-2 Exadata Systems? (Choose two.)

  1. The High Capacity (HC) and Extreme Flash (EF) Storage Server comes with 384 GB memory default.
  2. The Database Server can contain 768 GB memory.
  3. The High Capacity (HC) and Extreme Flash (EF) Storage Server contains 256 GB memory.
  4. The Database Server comes with 384 GB memory default.
  5. The Database Server can contain 2048 GB memory.
  6. The Eighth Rack Database Server comes with 512 GB memory default.