Free Oracle 1Z0-902 Exam Dumps Questions & Answers

Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

• A.  cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
• B.  PMEM Cache section within Exadata Smart Statistics
• C.  PMEM Pool Misses in the Exadata Outlier Summary
• D.  PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
• E.  PMEM Cache section within Memory Statistics

What are the two benefits of using Oracle Exadata Deployment Assistant (OEDA)?

• A.  OEDA provides a CL1 which supports life cycle management tasks for Exadata systems only.
• B.  OEDA is used for Oracle Exadata Database Machine, Zero Data Loss Recovery Appliance, Private Cloud Appliance, and SuperCluster.
• C.  OEDA gathers configuration details and creates the Oracle Exadata Rack configuration file.
• D.  OEDA Web-based user interface cannot import OEDA XML configuration files created with the Java-based version of OEDA without conversion
• E.  OEDA facilitates abstracting hardware.

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?

• A.  Check the database to see if any rebalance operations are active.
• B.  Call Oracle Support and make an appointment so that the drive can be replaced.
• C.  Ask the system administrator to replace the broken disk with a spare.
• D.  Download and run the latest exadiag tool.
• E.  Wait for a blue light to appear on the disk if the rebalance operation is running.
• F.  Wait for the email of the failure that Exadata or Enterprise Manager will send.

What are two recommended configuration best practices for backup and recovery on Exadata?

• A.  When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.
• B.  The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.
• C.  Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
• D.  Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.

You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes:

After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?

• A.  # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
• B.  # resize2fs +20G /dev/VGExaDb/LVDbOral
• C.  # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
• D.  # xfs_growfs /uOl +20G