oracle 1Z0-902 Exam Questions

Questions for the 1Z0-902 were updated on : Dec 01 ,2025

Page 1 out of 6. Viewing questions 1-15 out of 85

Question 1

Which statement is FALSE about the OEDA command line interface (OEDACU)?

  • A. Add nodes to and remove nodes from a VM cluster.
  • B. Add or remove additional databases.
  • C. Resize Oracle ASM disk groups.
  • D. Support ZDLRA life cycle management operation.
  • E. Add or remove Oracle Database home directories.
  • F. OEDACU has Edit mode and Deploy mode.
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Explanation:
The Oracle Exadata Deployment Assistant Command Line Interface (OEDACU) supports a variety of
configuration and lifecycle management tasks for Exadata systems, such as adding or removing
nodes, resizing ASM disk groups, and managing Oracle Database home directories. However, it does
not support lifecycle management for the Zero Data Loss Recovery Appliance (ZDLRA), as this device
requires different management tools specific to its backup and recovery functions .

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 2

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

B

User Votes:
A
50%
B
50%
C
50%
D
50%

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 .

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

What is the minimum Exadata System Software version required for Exadata X9M?

  • A. 20.1.1.0.0
  • B. 19.2.1 0.0
  • C. 21.2.0.0.0
  • D. 19.3.0.0.0
  • E. 18.1.3.0.0
  • F. 21.3.0.0.0
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Explanation:
The minimum Exadata System Software version required to support Oracle Exadata X9M is
21.2.0.0.0. This version introduced various enhancements and capabilities tailored for the X9M
series, including optimizations for the RoCE network fabric and support for new hardware
components .

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 4

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

  • A. the number of full table scans that accessed the table
  • B. 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
  • C. the number of serial queries that accessed the table
  • D. the number of parallel queries 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:

BE

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

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 .

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 5

When receiving an Exadata Database Machine rack on site, which of the following statements is
INCORRECT?

  • A. Push Oracle Exadata Rack from behind when moving into place.
  • B. Four leveling feet share the load with the casters.
  • C. Pushing on the side panels can tip the rack over.
  • D. Front casters do not turn, you must steer the unit by moving the rear casters.
  • E. Reuse the shipping brackets to permanently mount the rack to the floor.
Answer:

E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
The handling and installation of an Exadata Database Machine rack require caution and adherence to
recommended guidelines:
Shipping Brackets: Shipping brackets are specifically designed for transportation purposes and should
not be reused for permanent installation. Permanent floor mounting should use approved rack-
mounting equipment to ensure stability and safety .
Steering and Pushing the Rack: Exadata racks should be steered from the rear due to fixed front
casters. It is critical to avoid pushing the rack from the side panels, which could cause it to tip over,
presenting a serious safety risk. This careful movement ensures safe positioning and prevents
damage to the equipment during installation.

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 6

Which of the below is NOT a precaution that should be adhered to in order to ensure the site is safe
and ready for

  • A. Do not use a flathead screwdriver to disconnect connector locks on LAN cables.
  • B. Be sure that each grounding wire used for Oracle Exadata Rack is used exclusively for Oracle Exadata Rack.
  • C. Do not install Oracle Exadata Rack near a photocopy machine.
  • D. Do not place anything on top of Oracle Exadata Rack.
  • E. When using shared grounding, the grounding resistance must not be greater than 10 ohms.
  • F. Do not install Oracle Exadata Rack in a location that is exposed to direct sunlight.
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Explanation:
When preparing a site for an Exadata Database Machine, several precautions ensure both the safety
of the installation and the optimal performance of the equipment. These precautions include:
Avoiding High-Interference Equipment: Installing near devices like photocopy machines, which can
emit electromagnetic interference (EMI), is not a specified precaution for Exadata installations.
However, attention should be given to site requirements for temperature, power, and proper
grounding connections .
In contrast, other site requirements include exclusive grounding for Exadata racks, avoiding direct
sunlight exposure, and ensuring grounding resistance is less than 10 ohms for shared grounding to
minimize electrical risks.

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 7

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

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

BE

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
Oracle Exadata Deployment Assistant (OEDA) offers multiple benefits for configuring and deploying
Exadata systems:
Configuration Gathering and Rack File Creation: OEDA simplifies the setup of Exadata environments
by collecting system-specific configuration details. It uses this information to generate the Exadata
Rack configuration file, which outlines the optimal setup for the particular environment, streamlining
the deployment process and ensuring compatibility with Oracle best practices .
Lifecycle Management CLI for Exadata Systems: OEDA includes a command-line interface (CLI) that
facilitates various lifecycle management tasks, specifically designed for Exadata systems. This CLI
helps in automating deployment steps, adjusting configurations, and updating system parameters,
tailored specifically for Exadata’s hardware and software environment .

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 8

Which two steps concise the path used to communicate with Enterprise Manager from an Exadata
Database Machine?

  • A. SNMP traps for alerts are sent by the storage server RS process to the storage server ILOM.
  • B. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.
  • C. SNMP traps for alerts are sent by the storage server ILOM to the storage server is process.
  • D. SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agent.
  • E. SNM? traps for alerts are sent by the storage server ILOM to the Enterprise Manager agent.
  • F. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process.
  • G. SNMP traps for alerts are sent by the storage server RS process to the Enterprise Manager agent.
Answer:

DE

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%

Explanation:
In an Exadata environment, the path of communication for SNMP traps involves:
Management Server (MS) Process to EM Agent: Alerts related to the storage server are generated by
the MS process, which then forwards SNMP traps directly to the Enterprise Manager agent, allowing
centralized monitoring and alert management .
ILOM to EM Agent: The ILOM on each Exadata storage server can independently send SNMP traps to
the EM agent, providing additional hardware-level monitoring and alerting capabilities .
These pathways ensure that alerts from both hardware and software layers reach Enterprise
Manager efficiently, supporting proactive management and rapid response to system issues.

Discussions
vote your answer:
A
B
C
D
E
F
G
0 / 1000

Question 9

Which two statements are true about Exadata System Software metrics and alerts on an Exadata
Database Machine?

  • A. Metric alerts are never stateful.
  • B. Metric thresholds, if set, will persist across storage and database server reboots.
  • C. SMTP metric alert notifications must be sent to both ASR manager and Enterprise Manager agents.
  • D. Metric alert notifications can be sent to only one destination such as Enterprise Manager OR SNMP OR SMTP.
  • E. Metrics have no thresholds set on them by default.
Answer:

BE

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
Exadata System Software metrics and alerts work as follows:
Persistence of Thresholds: When metric thresholds are configured, they remain active and persist
across server reboots. This ensures consistent monitoring behavior even after maintenance or
unexpected reboots .
Default Metrics: By default, metrics are collected without predefined thresholds. Administrators
must set custom thresholds to enable specific alerting based on their operational requirements .

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 10

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

DEF

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

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  .

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 11

Exadata X9M enables virtualization using KVM. Which statement is true about virtualization on
Exadata X9M?

  • A. Up to 12 virtual guests per X9M-2 database server are supported. If the database server memory has 384GB and Exadata Secure RDMA Fabric isolation is configured 8 guests are supported
  • B. Up to 12 virtual guests per X9M-2 database server are supported.
  • C. Exadata X9M-8 supports up to 48 virtual guests regardless if Exadata Secure RDMA Fabric Isolation is configured.
  • D. Oracle KVM Manager should be installed on at least two Database servers per Exadata rack.
  • E. Virtual guests from X8 and earlier can be migrated to X9M using VM Guard.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
Oracle Exadata X9M-2 supports virtualization through Kernel-based Virtual Machine (KVM), enabling
multiple virtual machines (VMs) to run on each database server. Specifically:
Each X9M-2 database server can support up to 12 virtual guests. This number provides ample
flexibility for running various applications or Oracle Real Application Clusters (RAC) instances across
virtualized environments .
While Exadata X9M-8 supports even more extensive virtualization, this question focuses on the X9M-
2 model. The specified limitation of 12 guests per database server considers both system resource
allocation and performance optimization .

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 12

Which statement is true about the disks that are used in ASM diskgroups on the Exadata platform?

  • A. In an Exadata storage server, each disk is placed into a separate failure group.
  • B. The grid disks in ASM diskgroups must have similar performance characteristics in addition lo having the same size.
  • C. Sparse diskgroups are virtual objects allocated from the DATA diskgroup.
  • D. If High redundancy is selected, grid disks from the primary and secondary Exadata Database Machine must be specified.
  • E. Extreme Flash (EF) and High Capacity (HC) disks can be mixed to any capacity within the same diskgroup.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
On Exadata systems, ASM disk group configurations require that:
Grid Disks Must Have Similar Performance Characteristics: Within a disk group, grid disks must not
only be of the same size but also need to exhibit similar performance traits. This consistency ensures
balanced I/O operations and optimizes the performance for ASM mirroring and striping across disks .
Sparse Diskgroups: These are specialized virtual objects that reside within the DATA disk group.
Sparse diskgroups are used to support snapshots and other space-efficient storage solutions by
creating virtual representations of grid disks within an existing disk group without consuming
additional physical space .
These characteristics are fundamental to ensuring that ASM maintains optimal performance and
storage efficiency on Exadata platforms.

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 13

You are monitoring PMEM cache to see if it is being used effectively with RDM

  • A. PMEM Cache Space Usage section in AWR Report
  • B. PMEM Cache User Reads section in AWR Report
  • C. Database lOs section in AWR Report
  • D. Database Statistics (v$ View)
  • E. Exadata Metrics (LIST METRICCURRENT)
Answer:

BE

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
To monitor the effectiveness of Persistent Memory (PMEM) cache usage with RDMA on Exadata,
information on RDMA I/O statistics can be found in:
PMEM Cache User Reads section in the AWR Report: This section provides detailed statistics on
PMEM read operations, including user reads that leverage RDMA for direct memory access from
PMEM. These metrics help gauge the utilization and efficiency of the PMEM cache .
Exadata Metrics (LIST METRICCURRENT): By using the LIST METRICCURRENT command within the
Exadata environment, real-time metrics related to PMEM usage and RDMA I/O statistics can be
accessed. This provides an immediate view of the current performance and activity on Exadata’s
persistent memory components .
These tools together offer insights into PMEM cache usage and the effectiveness of RDMA for
optimized data access.

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 14

You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the
database nodes in your Exadata Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor
readings, faults, and any related alerts, are visible in Enterprise Manager?

  • A. No thresholds need to be set because they are preset in the ILOM and in Enterprise Manager
  • B. Set thresholds in ILOM and in Enterprise Manager because they are not preset anywhere and must be set in both places.
  • C. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.
  • D. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%

Explanation:
For Exadata systems, hardware monitoring for components like the motherboard, memory, power,
fans, and network cards on the database nodes is managed through the Integrated Lights Out
Manager (ILOM). The ILOM provides built-in thresholds and sensor readings that are automatically
recognized by Oracle Enterprise Manager.
These thresholds and alerts are already configured within ILOM for Exadata components, ensuring
seamless integration with Enterprise Manager for alerting and monitoring purposes .
Enterprise Manager uses these pre-set ILOM thresholds and does not require additional
configuration for monitoring hardware components. Therefore, administrators benefit from preset
alerting mechanisms that are sufficient for comprehensive hardware status visibility .

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

Your customer would like to configure monitoring capabilities Auto Service Request (ASR) on the
stand-alone server that was set aside to run ASR Manager.
What configuration should you set up for the customer?

  • A. ASR Manager inside the firewall along with ExaWatcher to monitor Database and Storage Server performance.
  • B. Enterprise Manager, Exachk and ASR Manager on the stand-alone server because ASR needs Exachk for continuous Hardware monitoring.
  • C. ASR Manager with SNMP traps configured to listen for specific alerts triggered by Exadata Intergrated Lights Out Manager (ILOM).
  • D. Enterprise Manager and ASR Manager on the stand-alone server because ASR is not a monitoring tool.
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%

Explanation:
For setting up Auto Service Request (ASR) monitoring on a standalone server dedicated to ASR
Manager:
ASR Manager with SNMP Traps: Configuring ASR Manager to utilize SNMP traps allows it to
automatically receive alerts from the Integrated Lights Out Manager (ILOM) on Exadata components.
The SNMP traps notify ASR Manager of specific hardware faults or critical system events, which then
automatically generate service requests with Oracle Support .
This setup ensures proactive monitoring and allows rapid response to any critical alerts related to the
Exadata hardware, leveraging the ILOM’s ability to monitor key system health metrics and trigger
alerts as necessary.

Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2