[UPDATED Apr-2025] Best Value Available Preparation Guide for 1z1-902 Exam [Q20-Q43]

Share

[UPDATED Apr-2025] Best Value Available Preparation Guide for 1z1-902 Exam

1 Full 1z1-902 Practice Test and 87 Unique Questions, Get it Now!


Oracle Exadata Database Machine X8M is a high-performance database appliance that is designed to deliver superior performance, scalability, and availability for mission-critical databases. It combines the power of hardware and software to provide a complete solution for database management. The machine comes with a range of features, including high-speed networking, flash technology, and intelligent algorithms, which make it the ideal choice for organizations that require high-performance databases. The Oracle 1z1-902 exam is designed to test the candidate's knowledge and skills in working with the Oracle Exadata Database Machine X8M.


The Oracle 1z1-902 exam consists of 70 multiple-choice questions that need to be completed within a time limit of 105 minutes. The questions are designed to test the candidate’s understanding of the Oracle Exadata Database Machine X8M and its various components. Candidates who pass the exam will receive the Oracle Certified Specialist (OCS) certification, which is recognized worldwide by the IT industry.


Prerequisites for Oracle 1Z0-902 Exam

Oracle 1Z0-902 Exam is the most important certification for the IT professionals. Therefore, it is very necessary for you to prepare well for the exam. In order to prepare for the Oracle 1Z0-902 Exam, you should have enough experience in the related fields. We recommend that you should master the concepts of the Java SE platform and the Oracle 1Z0-902 Exam, so that you could pass the Oracle 1Z0-902 Exam easily.

 

NEW QUESTION # 20
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

  • A. Oracle Exadata Rack may only be installed on raised floor environments.
  • B. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
  • C. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
  • D. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
  • E. The incline of any access route ramp must be less than or equal to 6 degrees.
  • F. 914mm of space required above the rack height is required for maintenance access.

Answer: A

Explanation:
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors Oracle Exadata Database Machine X9M Implementation Essentials states that Exadata racks are designed to be installed on flat surfaces, not raised floor environments. It is not required to install the rack on raised floor environments. Additionally, the other options listed are all requirements for validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 41)


NEW QUESTION # 21
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

  • A. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
  • B. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
  • C. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
  • D. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.

Answer: A,B


NEW QUESTION # 22
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

  • A. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
  • B. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
  • C. ZFS Snapshots can provide rapid cloning of development and test environment.
  • D. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.

Answer: B,D


NEW QUESTION # 23
Which statement is true about the Persistent Memory Commit Accelerator?

  • A. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
  • B. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
  • C. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
  • D. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
  • E. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.

Answer: B

Explanation:
Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk. This helps to further reduce redo log write latency by utilizing the speed and low latency of Persistent Memory, along with the Remote Direct Memory Access (RDMA) protocol, to commit changes to disk faster. This allows the system to quickly commit changes to disk, resulting in improved performance and reduced latency.
This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1][2]. The Persistent Memory Commit Accelerator uses Persistent Memory and Remote Direct Memory Access (RDMA) technology to write redo log data to Flash and disk, resulting in improved latency and higher throughput. Additionally, the Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash [1], further reducing latency.


NEW QUESTION # 24
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 physicaldisk attributes name, deviceName, diskType, physicalFirmware
  • B. list celldisk attributes name, deviceName, diskType, physicalFirmware
  • C. list devices attributes name, deviceName, diskType, physicalFirmware
  • D. list cell attributes name, deviceName, diskType, physicalFirmware

Answer: B


NEW QUESTION # 25
What does the following command do?
root@rul6 -]# for j in {01..23} ; do ipmitool sunoem cli "set /SP/network/test ping=192.168.1.1$j'' ; done

  • A. Verifies that the ILOM management network is working before installation of all storage and database servers in a full rack Exadata X9M-2, run from the first database server.
  • B. Sets the address for each storage and database server's /SP during installation to enable ping testing from the management network, run from the first database server.
  • C. Sets the test address for the RoCE network for all storage and database servers in a full rack Exadata X9M-2, run from the first database server.
  • D. Verifies that the ILOM management network is working after OEDA configuration has completed for all storage and database servers in a full rack Exadata X9M-2, run from the first database server.

Answer: A

Explanation:
The given command uses a for loop with ipmitool to issue ping commands sequentially to a range of IP addresses in the management network:
for j in {01..23}; do ipmitool sunoem cli "set /SP/network/test ping=192.168.1.1$j"; done This script verifies the connectivity of the ILOM management network before the Exadata installation. Each server's Service Processor (SP) is tested for reachability, confirming that the management network setup is operational across the full rack .


NEW QUESTION # 26
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?

  • A. 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
  • B. OS I/O metrics using OS tools such as iostat on the storage servers
  • C. OS I/O metrics using OS tools such as iostat on the database servers
  • D. OS I/O metrics using Enterprise Manager host pages for the storage servers
  • E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

Answer: A,E

Explanation:
According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer.
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 *plus. These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.


NEW QUESTION # 27
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?

  • A. 2, 8, 7, 3, and 6
  • B. 1, 8, 7, 3 and 6
  • C. 2, 7, 8, and 6
  • D. 5, 8, 7, and 6
  • E. 4, 7, 8, 3, and 6

Answer: B

Explanation:
In order to power off an Exadata Database Machine in an orderly fashion, the commands should be executed in the following order: 1) Execute "crscti stop cluster -all" as the grid user from one database server; 2) Execute "shutdown -h now" on all database servers; 3) Power off all network switches; 4) Execute "shutdown -h now" on all Exadata storage servers; and 5) Power off the rack using the power switches on the PDUs. This sequence of commands ensures that all services running on the Exadata Database Machine are in a clean state before powering off the system. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 543)


NEW QUESTION # 28
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

  • A. 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.
  • B. 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.
  • C. 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.
  • D. 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.

Answer: D

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.
According to Oracle's documentation1, Exadata Secure RDMA Fabric Isolation is a feature that enables strict network isolation for Oracle Real Application Clusters (Oracle RAC) clusters on Exadata Database Machine systems that use RDMA over Converged Ethernet (RoCE). Exadata Secure RDMA Fabric Isolation uses RoCE VLANs to ensure that network packets from one VM cluster cannot be seen by another VM cluster. VLAN tag enforcement is done at the KVM host level, which means that security cannot be bypassed by any software exploits or misconfiguration on the database server VMs1.
Therefore, the statement that is true about how Exadata Secure RDMA Fabric isolation is used in X9M-2 with virtualization enabled is:
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.


NEW QUESTION # 29
You want to examine how much Smart Scan activity is occurring.
Which two would provide the information you require?

  • A. the number of parallel queries that accessed the table
  • B. the number of serial queries that accessed the table
  • C. the number of Smart Scans performed for the table on all the storage servers, as shown when performing a list activerequest command using CELLCLI on all the cells
  • D. the number of full table scans that accessed the table
  • E. the number of Smart Scans performed for the table on all the storage servers, as shown when performing a list ACTIVEREQUEST command using EXACLI on all the cells

Answer: C,E

Explanation:
To determine the amount of Smart Scan activity on an Exadata Database Machine, you can access two specific commands:
CELLCLI Command: Using the list activerequest command within CELLCLI on all storage cells will show the number of Smart Scans being processed. CELLCLI is an interface specific to Exadata Storage Servers for management and monitoring, and it provides real-time visibility into ongoing Smart Scan operations .
EXACLI Command: Similarly, the list ACTIVEREQUEST command using EXACLI on all storage cells also lists the Smart Scans executed across the storage servers. EXACLI is a remote command-line utility that can be run from a database server to manage storage cells, offering convenient access to similar Smart Scan information .


NEW QUESTION # 30
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

  • A. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
  • B. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
  • C. Configuring ASR is mandatory for all Database Machine assets.
  • D. ASR Manager must be installed and configured on one of the database servers.
  • E. ASR can upload configuration metadata to support problem resolution.
  • F. ASR communicates with Oracle support services using HTTPS.

Answer: B,E

Explanation:
1. ASR can upload configuration metadata to support problem resolution1.
2. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults1
https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm


NEW QUESTION # 31
Which three statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?

  • A. Cloud Control can monitor and manage a Database Machine storage Expansion rack.
  • B. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.
  • C. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
  • D. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage node.
  • E. Compute nodes forward their SNMP traps to the Management Server process on the same compute node.
  • F. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.

Answer: A,B,D

Explanation:
Oracle Enterprise Manager (EM) Cloud Control provides comprehensive monitoring and management for Exadata Database Machines, including:
Support for Database Machine Storage Expansion Racks: EM Cloud Control seamlessly integrates with the Storage Expansion Rack, allowing administrators to monitor both primary and expansion storage environments together, which is essential for large-scale deployments.
Minimal Agent Installation: Cloud Control needs only one Oracle Management Agent on one compute node to monitor the entire Database Machine cluster, covering all compute and storage nodes. This is due to Exadata's interconnect and resource-sharing capabilities, enabling centralized monitoring with minimal setup requirements.


NEW QUESTION # 32
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 celldisk attributes name, deviceName, diskType, physicalFirmware
  • B. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
  • C. list devices attributes name, deviceName, diskType, physicalFirmware
  • D. list cell attributes name, deviceName, diskType, physicalFirmware

Answer: B

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 # 33
Which statement is true about the Persistent Memory Commit Accelerator?

  • A. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
  • B. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
  • C. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
  • D. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
  • E. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.

Answer: A


NEW QUESTION # 34
You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should use use to generate alerts for such an event?

  • A. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
  • B. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
  • C. dbmcli -e "set alert ds_temp> 30" on each database server
  • D. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server

Answer: A

Explanation:
The correct command to generate alerts for an event when the temperature of the database servers in an Exadata Full Rack exceeds 30C is "dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server". The dbmcli is the command-line interface for the Oracle Database Management Agent (DMA), which allows you to perform various management tasks on the Exadata servers. This command creates a threshold for the ds_temp metric with a comparison operator of ">" (greater than), and a critical value of 30. The threshold is set on all database servers in the Exadata Full Rack, so when the server temperature exceeds 30C, an alert will be generated.


NEW QUESTION # 35
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

  • A. 6, 8, 3, 4, 2, 1
  • B. 6, 1, 2, 7, 5, 8
  • C. 6, 3, 1, 9, 7, 8
  • D. 6, 2, 1, 8, 4, 5

Answer: D

Explanation:
The steps and the order in which they should be executed to create an ACFS Filesystem for use as a staging area for data loads are:
asmcrad volcreate -G data -s 1024G acfs_dataload_vol : This command creates a new volume in the data diskgroup, with a size of 1024 GB, and named acfs_dataload_vol.
asmcmd vol info -G data acfs_dataload_vol | grep Device: This command will show the device name of the newly created volume
/usr/sbin/mkfs -t acfs /dev/asm/ac:fs_dataload_vol-123: This command creates a new ACFS filesystem on the volume created in step 1 sudo /u01/app/19.0.0.0/grid/bin/srvctl start filesystem -device /dev/asn/acfs_dataload_vol-123: This command starts the filesystem created in step 3 sudo chovn -R oracle:dba /mnt/acfs_dataload_vol: This command changes the ownership of the /mnt/acfs_dataload_vol to the oracle:dba user.
/sbin/acfsutil snap create -v data_load /mnt/acfs_dataload_vol: This command creates a snapshot of the filesystem to be used as a staging area.
acfsutil size +2S0G -d /dev/asm/acfs_dataload_vol-123 /mnt/acfs_dataload_vol/ : This command increases the size of the filesystem by 2GB
/u01/app/19-G.O-Q7grid/bin/srvctl add filesystem -device /dev/asm/acfs_dataload_vol-


NEW QUESTION # 36
Which two statements are true about the IPTables firewall configuration on a new Exadata Database Machine after initial deployment?

  • A. IPTables is configured and running with Oracle-supplied rules on the storage servers.
  • B. IPTables is installed and available but not configured or running on the database servers.
  • C. IPTables is installed and available but not configured or running on the storage servers.
  • D. IPTables is installed and available but not configured on any server.
  • E. IPTables is configured and running with Oracle-supplied rules on the database servers.

Answer: B,C

Explanation:
On Oracle Exadata Database Machine X9M, the default configuration of the IPTables firewall varies between storage servers and database servers:
Storage Servers: After initial deployment, IPTables is installed but remains in an unconfigured and inactive state. The Exadata storage servers focus on providing high availability and performance for database workloads and thus rely on internal security measures. The external firewall or network security policies typically handle firewall responsibilities, so IPTables is not actively configured on these servers by default.
Database Servers: Similar to storage servers, IPTables is also installed but neither configured nor running on the database servers. The Oracle Exadata Database Machine X9M emphasizes security through other means, such as its network isolation and dedicated interconnects. As part of Oracle's engineered systems design philosophy, the database servers are primarily focused on database performance, offloading much of the security management to other parts of the infrastructure and relying on data center-level firewalls for perimeter security.
To summarize, both database and storage servers have IPTables installed and available, but they are not configured or running by default on either server type. This setup allows Exadata environments to focus on optimized database performance while integrating with external network security solutions.


NEW QUESTION # 37
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

  • A. the failure of both physical M.2 disks
  • B. accidental loss of all data from all griddisks in a storage server
  • C. corruption in the / (root) filesystem
  • D. the failure of physical disk 0 and 11
  • E. corruption in a normal or high redundancy ASM diskgroup
  • F. moving all disks from one cell to another as part of a chassis-level component failure
  • G. the failure of physical disk 1

Answer: A,C

Explanation:
The two valid reasons are:
corruption in the / (root) filesystem . According to 1, this is one of the scenarios that requires a storage server rescue procedure , because it prevents the storage server from booting up normally . The rescue procedure will re-image the root filesystem with a fresh copy of the operating system and restore the configuration files from a backup1.
the failure of both physical M.2 disks . According to 2, each Exadata Storage Server X9M-2 has two physical M.2 disks that store the operating system and configuration files for the storage server . If both M.2 disks fail , then the storage server cannot boot up or function properly . The rescue procedure will replace the failed M.2 disks with new ones and re-image them with the operating system and configuration files2.


NEW QUESTION # 38
You are updating your Exadata X9M-2 Elastic Database Machine with 6 database servers and 12 High Capacity Storage Servers. You will be using patchmgr to apply updates across the entire machine while still maintaining database availability.
Assuming you are driving patchmgr from an external server, which statement is true about the execution phase?

  • A. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
  • B. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
  • C. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
  • D. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.

Answer: D

Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], patchmgr can be used to apply updates in a rolling manner while still maintaining database availability. It will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption. This is done by invoking patchmgr with the -rolling argument and specifying the component groups in the input file.


NEW QUESTION # 39
An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU. Which statement is correct?

  • A. The installation cannot proceed until two power feeds are available per PDU.
  • B. A splitter cable can be used to provide power to all PDU cables.
  • C. The installation can go ahead, no change is required.
  • D. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.

Answer: A

Explanation:
In order for an Exadata X9M-2 Elastic Rack to be installed, two power feeds are required for each of the three-phase 24kVA PDUs. A single cable from each PDU will not be enough to power the rack, and neither a splitter cable nor rearrangement of the power cables from the servers to the PDUs will be able to provide sufficient power for the system. Therefore, the installation cannot proceed until two power feeds are available per PDU.
For more information about power requirements for Exadata X9M-2 Elastic Racks, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation - Oracle Docs [2] Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/exadata-site-requirements.html


NEW QUESTION # 40
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

  • A. Configuring ASR is mandatory for all Database Machine assets.
  • B. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
  • C. ASR Manager must be installed and configured on one of the database servers.
  • D. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
  • E. ASR communicates with Oracle support services using HTTPS.
  • F. ASR can upload configuration metadata to support problem resolution.

Answer: C,D


NEW QUESTION # 41
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?

  • A. OS I/O metrics using OS tools such as iostat on the storage servers
  • B. OS I/O metrics using OS tools such as iostat on the database servers
  • C. OS I/O metrics using Enterprise Manager host pages for the storage servers
  • D. 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
  • E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

Answer: B,E


NEW QUESTION # 42
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

  • A. It is mandatory to install OCM on all database servers.
  • B. It collects configuration information on demand.
  • C. It collects configuration information automatically.
  • D. Collected configuration information can be uploaded manually to Oracle.
  • E. It is mandatory to install OCM on at least one database server.
  • F. Collected configuration information can be uploaded automatically to Oracle.

Answer: A,E,F


NEW QUESTION # 43
......

Get Instant Access to 1z1-902 Practice Exam Questions: https://www.prep4sures.top/1z1-902-exam-dumps-torrent.html

The Best 1z1-902 Exam Study Material Premium Files  and Preparation Tool: https://drive.google.com/open?id=1hjPL-OtWhD7SeyYEJJIAHZIMIr_p70pn