New 1Z0-902 Test Materials & Valid 1Z0-902 Test Engine
1Z0-902 Updated Exam Dumps [2023] Practice Valid Exam Dumps Question
What is the exam cost of the Oracle 1Z0-902 Exam
Oracle 1Z0-902 Exam price varies greatly depending on the vendor. The average cost of a bundle is 244.09 USD, which includes the exam and all other materials.
NEW QUESTION 20
You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.
Which command would help investigate this?
- A. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- B. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- C. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- D. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
Answer: C
NEW QUESTION 21
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Database Quarantine
- B. Cell Offload Quarantine
- C. Manually created Quarantine
- D. SQL Plan Quarantine
- E. Disk Region Quarantine
Answer: A,D
NEW QUESTION 22
Which statement is true about the patching features provided in Platinum Services?
- A. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
- B. The rolling and complete down time approaches are two options to patching.
- C. Patching services are available for the full software stack up to twice per year.
- D. Patching is done automatically during business hours.
Answer: C
Explanation:
Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.
NEW QUESTION 23
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?
- A. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.
- B. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.
- C. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.
- D. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.
Answer: A
Explanation:
Exadata Secure RDMA Fabric isolation is a feature that allows you to use virtualization on the X9M-2 platform while maintaining security and isolation between multiple tenants or VM clusters. Secure Fabric isolation works by creating a dedicated network partition and VLAN ID for each Database VM cluster, which is used for cluster networking between the database servers in the VM Cluster. This ensures that the network traffic of each VM cluster is isolated from the others, and it prevents unauthorized access to the data or resources of other VM clusters. Secure Fabric isolation can also be used for other purposes such as client networking, Data Guard traffic, but it's mainly used to provide security and isolation between multiple tenants or VM clusters.
NEW QUESTION 24
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. 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.
- B. 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.
- 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.
Answer: A,C
NEW QUESTION 25
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- B. PMEM Pool Misses in the Exadata Outlier Summary
- C. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- D. PMEM Cache section within Memory Statistics
- E. PMEM Cache section within Exadata Smart Statistics
Answer: C,D
Explanation:
The "cell PMEM cache Read Hits" in the "Database IOs" portion of the "Performance Summary" will show the number of reads that have been satisfied from the Persistent Memory Cache. The "PMEM Cache" section within "Memory Statistics" will give detailed information about the usage of the Persistent Memory Cache, such as cache size, used size, hit rate, etc. This information can help to identify if the Persistent Memory Cache is being used effectively and if there are any issues with it.
NEW QUESTION 26
You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?
- A. list devices attributes name, deviceName, diskType, physicalFirmware
- B. list celldisk attributes name, deviceName, diskType, physicalFirmware
- C. list cell attributes name, deviceName, diskType, physicalFirmware
- D. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
Answer: D
Explanation:
This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85).
NEW QUESTION 27
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?
- A. 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'.
- B. 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.
- C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- D. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
Answer: A,D
NEW QUESTION 28
You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?
- A. 3,2,6,1,4,7,5
- B. 2,3,4,6,1,7,5
- C. 4,3,2,6,1,7,5
- D. 2,6,1,4,3,7,5
- E. 3,2,6,4,1,7,5
Answer: B
Explanation:
This ordering is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. First, the Exadata should be stabilized and unpacked (Steps 2 and 3). Then, the safety guidelines should be reviewed (Step 4). The Exadata should then be allowed to acclimatize for 24 hours (Step 4). After that, the Exadata PDU A should be powered on (Step 6) and the Exadata should be placed in its allocated space (Step 6). Finally, the Exadata PDU B should be powered on (Step 7).
NEW QUESTION 29
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- B. Run the appropriate patchmgr preqequisite check step for each component being updated.
- C. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- D. Run exachk and resolve only WARNINGS that you have not seen before.
- E. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- F. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
Answer: A,B,C,F
Explanation:
For database servers, perform a server backup using patchmgr -dbnodes dblistfile -backup -rolling. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book . The other statement is false as exachk should not be used to resolve warnings or errors [1], but rather to identify them so that they can be addressed. Additionally, patchmgr should not be used with the --autofix, --autobackup, --upgrade, or --rolling flags as this could cause unexpected issues.
NEW QUESTION 30
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR communicates with Oracle support services using HTTPS.
- B. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- C. ASR Manager must be installed and configured on one of the database servers.
- D. ASR can upload configuration metadata to support problem resolution.
- E. Configuring ASR is mandatory for all Database Machine assets.
- F. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
Answer: B,C
NEW QUESTION 31
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?
- A. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
- B. hardware monitoring using the storage server ILOM
- C. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
- D. using the CELLCLI list LUN DETAIL command as the celladmin user
Answer: A,D
NEW QUESTION 32
An Exadata storage server physical disk on an X9M-2 high-capacity full rack entered the predictive failure state. Which two steps must you perform to replace this failed physical disk?
- A. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- B. Replace the failed physical disk.
- C. Rebalance the data on the effected griddisks before performing a manual drop command.
- D. Create a new celldisk and new griddisks on the replaced physical disk.
- E. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- F. Add the griddisks back into the ASM diskgroup they used to be a member of.
Answer: A,B
Explanation:
Once the physical disk has been replaced, you will need to create a new celldisk and griddisks on the replaced physical disk. After the griddisks have been dropped from the associated ASM diskgroups, you can then add the griddisks back into the ASM diskgroup they used to be a member of and rebalance the data on the effected griddisks. Finally, you should verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
NEW QUESTION 33
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- B. installing an alternative package manager
- C. configuring secure shell user equivalency for the cellmonitor user
- D. upgrading the Storage Server software package using rpm
- E. changing the root password
Answer: B,E
NEW QUESTION 34
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. Wait for the email of the failure that Exadata or Enterprise Manager will send.
- B. Call Oracle Support and make an appointment so that the drive can be replaced.
- C. Wait for a blue light to appear on the disk if the rebalance operation is running.
- D. Check the database to see if any rebalance operations are active.
- E. Ask the system administrator to replace the broken disk with a spare.
- F. Download and run the latest exadiag tool.
Answer: E
NEW QUESTION 35
......
1Z0-902 Sample with Accurate & Updated Questions: https://www.testkingfree.com/Oracle/1Z0-902-practice-exam-dumps.html
1Z0-902 Exam Info and Free Practice Test | TestKingFree: https://drive.google.com/open?id=1mYDFfzp2AksEiNoiJ-moIAsEmMLXyUod