oracle 1z0-902 practice test

Oracle Exadata Database Machine X9M Implementation Essentials

Last exam update: Nov 18 ,2025
Page 1 out of 6. Viewing questions 1-15 out of 85

Question 1

What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

  • A. 1536GB
  • B. 512GB
  • C. 2048GB
  • D. 768GB
  • E. 1024GB
  • F. 384GB
Mark Question:
Answer:

A


Explanation:
According to 1
, Exadata X9M-2 Database Servers are based on Intel Xeon Platinum 8368Y
processors with 32 cores and 768 GB of DRAM memory per server. This memory can be expanded up
to 1.5 TB per server by adding 24 x 32 GB DIMMs.
The DRAM memory is used for buffer cache, PGA,
and other database purposes1
.
Exadata X9M-2 Database Servers also have 25.6 TB of Persistent
Memory Acceleration (PMEM) per server, which is used for log writes and columnar data
caching1
.
PMEM is a new type of memory that combines the speed of DRAM with the persistence of
flash2
.
Exadata X9M-2 Database Servers are designed to run Oracle Database workloads with high
performance, scalability, and reliability2

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 2

Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata
Database Machine deployment?

  • A. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
  • B. 1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
  • C. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
  • D. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
  • E. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
Mark Question:
Answer:

C


Explanation:
Oracle KVM Guest: This is a virtual machine that runs on top of Oracle Linux KVM hypervisor.
It can
be used to run Oracle Database or other applications on Exadata Database Machine2
. Therefore, it
runs on the Database Servers.
Oracle Enterprise Manager Agent (OMA): This is a software agent that communicates with Oracle
Enterprise Manager Cloud Control and provides monitoring and management capabilities for
Exadata Database Machine2
. Therefore, it runs on both Database Servers and Storage Servers.
ASM instance: This is an instance of Oracle Automatic Storage Management (ASM), which is a
volume manager and a file system for Oracle Database files. It manages disk groups that span across
multiple Storage Servers
. Therefore, it runs on the Database Servers.
RDBMS instance: This is an instance of Oracle Database that processes SQL statements and executes
transactions. It uses ASM disk groups to store data files, control files, redo log files, etc
. Therefore, it
runs on the Database Servers.
Automatic Diagnostic Repository Command Interpreter (ADRCI): This is a command-line tool that
enables you to view diagnostic data stored in the Automatic Diagnostic Repository (ADR). ADR is a
file-based repository for database diagnostic data such as trace files, alert logs, etc
. Therefore,
ADRCI runs on both Database Servers and Storage Servers, depending on where the ADR is located.
CELLCLI: This is a command-line interface that enables you to configure and manage Exadata Storage
Server Software.
It allows you to perform tasks such as creating disk groups, monitoring cell health,
applying patches, etc2
. Therefore, it runs on the Storage Servers.
Cell Server(CELLSRV): This is a process that runs on each Storage Server and handles I/O requests
from the Database Servers. It implements Exadata Smart Scan , which offloads data-intensive SQL
operations from the Database Servers to the Storage Servers
. Therefore, it runs on the Storage
Servers.
diskmon: This is a process that monitors the status of disks and flash devices on each Storage
Server. It reports disk failures and performs automatic disk reclamation
. Therefore, it runs on
the Storage Servers.
Restart Server (RS): This is a process that manages automatic restarts of critical processes such as
CELLSRV , MS , or OMA in case of failures. It also handles graceful shutdowns and startups of all
processes on each server
. Therefore, it runs on both Database Servers and Storage Servers.
Management Server (MS): This is a process that provides management services for each server such
as collecting metrics , logging events , executing commands from CELLCLI , etc2
. Therefore, it runs on
both Database Servers and Storage Servers

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 3

Your customer needs to ensure that their data is available on the Exadata machine during updates.
The customer wants to be able to update one server at a time but still be protected against single-
node server failure.
What ASM redundancy level should they use?

  • A. Normal
  • B. Sparse
  • C. High
  • D. External
  • E. Extended
Mark Question:
Answer:

A


Explanation:
Your customer needs to ensure that their data is available on the Exadata machine during updates.
The customer wants to be able to update one server at a time but still be protected against single-
node server failure. This means that they need a redundancy level that can tolerate at least one disk
failure without losing data availability or performance. Therefore, the best option for them is normal
redundancy .
Normal redundancy provides two-way mirroring by default, which means that each
data extent has a primary copy and a mirror copy on different disks in different failure groups1
. A
failure group is a subset of disks within a disk group that are likely to fail at the same time due to
common dependencies
.
On Exadata Database Machine , each Storage Server is considered as a
failure group by default2
.
This means that if one Storage Server fails or needs to be updated , the
data on its disks can still be accessed from another Storage Server that has the mirror copies of the
same data extents2
. Therefore, normal redundancy ensures data availability and performance during
updates or single-node server failures.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-administering-asm.html

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 4

Which three statements are true about the CELLCLI command?

  • A. It can execute commands on multiple storage servers in parallel.
  • B. It has command-line history.
  • C. It requires root privileges to create CELLDISKS and GRIDDISKS.
  • D. It can be executed on storage servers.
  • E. It can be executed using the DCLI utility.
Mark Question:
Answer:

BDE


Explanation:
The statements that are true about the CellCLI command are:
It has command-line history . According to
, you can use the up and down arrow keys to scroll
through previous commands that you entered in CellCLI . You can also use Ctrl+R to search for a
previous command by entering part of it .
It can be executed on storage servers .
According to 1
, you can invoke CellCLI by logging in to the
Exadata cell as cellmonitor , celladmin , or root user and typing “cellcli” .
Within CellCLI , you can
perform various management and monitoring tasks for the cell134
.
It can be executed using the DCLI utility .
According to 5
, DCLI (distributed CLI) is another utility that
can be used to execute scripts and commands across multiple storage cells from a single
interface.
You can use DCLI to run CellCLI commands on multiple cells at once54
.

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 5

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. A splitter cable can be used to provide power to all PDU cables.
  • B. 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.
  • C. The installation cannot proceed until two power feeds are available per PDU.
  • D. The installation can go ahead, no change is required.
Mark Question:
Answer:

C


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

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

You have been tasked with replacing a memory module of an Exadata Storage Server and need to
power off the affected storage server. Which two commands must you execute to safely power off
the storage server in an Exadata X9M Database Machine?

  • A. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
  • B. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
  • C. 'crsct1 stop cluster -all' on one of the database servers
  • D. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
  • E. CellCLI alter GRIDDISK all inactive on the affected storage server
  • F. shutdown -h now' on the affected storage server
Mark Question:
Answer:

EF


Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB
The two commands that must be executed to safely power off the storage server in an Exadata X9M
Database Machine are E and F.
Command E, CellCLI alter GRIDDISK all inactive, will deactivate all of the GRIDDISKS on the affected
storage server. This will ensure that no data is lost during the power-off process.
Command F, shutdown -h now, will shut down the storage server. This will ensure that the storage
server is completely powered off and no data is lost.
For more information on how to properly power off an Exadata Storage Server, refer to the Oracle
Exadata Database Machine X9M Implementation Essentials official text book and resources
[1][2]
.
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1188080_1.html

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 7

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

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

BC


Explanation:
The two valid reasons are:
corruption in the / (root) filesystem . According to
, 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
.

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%
Discussions
vote your answer:
A
B
C
D
E
F
G
0 / 1000

Question 8

What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

  • A. Oracle Linux 7.5
  • B. Oracle Linux 7.9
  • C. Oracle Linux 8.0
  • D. Oracle Linux 7.7
Mark Question:
Answer:

B


Explanation:
Oracle Linux 7.9 is the minimum version required to support RoCE and Persistent Memory.
This is
because Oracle Linux 7.9 includes kernel enhancements that enable RDMA over Converged Ethernet
(RoCE) networking and Intel Optane DC Persistent Memory Modules (DCPMM) for Exadata X8M
systems3
. These features allow faster access latency and higher throughput for database workloads
.

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

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

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

E


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)
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/index.html

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 10

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. 5, 8, 7, and 6
  • B. 4, 7, 8, 3, and 6
  • C. 2, 8, 7, 3, and 6
  • D. 2, 7, 8, and 6
  • E. 1, 8, 7, 3 and 6
Mark Question:
Answer:

A


Explanation:
Option 5 stops the clusterware on all database servers as the grid user3
.
Option 8 shuts down all Exadata storage servers using their ILOM interfaces1
.
Option 7 shuts down all database servers using their ILOM interfaces1
.
Option 6 powers off the rack using the power switches on the PDUs2
.

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 11

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
Mark Question:
Answer:

CE


Explanation:
Option C shows the number of read hits from PMEM cache on storage servers which indicates how
much data was served from PMEM instead of flash or disk1
.
Option E shows detailed information about PMEM cache such as size, utilization, hit ratio, read
latency and write latency2
.

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 12

A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA
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 can go ahead, no change is required.
  • B. The installation cannot proceed until two power feeds are available per PDU.
  • C. A splitter cable can be used to provide power to all PDU cables.
  • 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.
Mark Question:
Answer:

A


Explanation:
According to the Oracle Exadata Database Machine X9M-2 Data Sheet
, each PDU has two power
input cables that can be connected to separate power sources for redundancy. However, if only one
power source is available per PDU, then a single cable can be used to provide sufficient power for
normal operation.
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

Which dbmcli command is NOT valid on Exadata X9M?

  • A. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*’”
  • B. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP’ ”
  • C. dbmcli -e "LIST IBPORT DETAIL"
  • D. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
Mark Question:
Answer:

C


Explanation:
The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle
Exadata Database Machine X9M Implementation Essentials Official Text Book
[1][2]
, this command is
only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M.
https://forums.oracle.com/ords/apexds/map/tech/apps-infra/discussion/4342715/monitoring-roce-
performance

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

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. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
  • C. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
  • D. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
Mark Question:
Answer:

CD


Explanation:
C . OEDA deployment steps include calibrate cells, create cell disks, and resecure machine
.
D .
OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility
included with OEDA2
.

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest
memory configuration available to the highest memory configuration?

  • A. Add 12x 32GB DIMMs.
  • B. Add 12x 64GB DIMMs.
  • C. Shutdown the Database Server if running.
  • D. Add 16x 32GB DIMMs.
  • E. Add 16x 64GB DIMMs.
  • F. Memory cannot be expanded on Exadata X9M-2 Database Servers.
  • G. Remove existing memory modules.
  • H. Add 32x 64GB DIMMs.
  • I. Add 24x 32GB DIMMs.
Mark Question:
Answer:

CGH


Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
https://chriscraftoracle.wordpress.com/2022/11/09/what-makes-exadata-faster/

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%
H
50%
I
50%
Discussions
vote your answer:
A
B
C
D
E
F
G
H
I
0 / 1000
To page 2