• Home
  • Blogs
  • Practice 1z1-902 Questions With Certification guide Q&A from Training Expert [Q24-Q43]

Practice 1z1-902 Questions With Certification guide Q&A from Training Expert [Q24-Q43]

Share

Practice 1z1-902 Questions With Certification guide Q&A from Training Expert Pass4SureQuiz

Free Oracle 1z1-902 Test Practice Test Questions Exam Dumps


Oracle Exadata Database Machine X8M is a high-performance computing platform designed to help organizations achieve maximum efficiency and scalability in their database operations. The machine combines the power of Oracle Database with the performance of hardware and software designed specifically for Oracle Database workloads. The machine is ideal for businesses that require high-performance database processing, such as financial institutions, healthcare providers, and government agencies.

 

NEW QUESTION # 24
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?

  • A. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network
  • B. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using SFP28 transceivers and OM4 fiber cable for client network
  • C. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network
  • D. 2x 10Gb ports on eth1 and eth2 using FU45 cat6 cable for client network, and 2x 25Gb ports on eth11 and eth12 using SFP28 transceivers and OM4 fiber cable for backup network

Answer: A,B

Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf


NEW QUESTION # 25
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 is done automatically during business hours.
  • D. Patching services are available for the full software stack up to twice per year.

Answer: D

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 # 26
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, 7, 8, and 6
  • B. 2, 8, 7, 3, and 6
  • C. 5, 8, 7, and 6
  • D. 1, 8, 7, 3 and 6
  • E. 4, 7, 8, 3, and 6

Answer: C

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.


NEW QUESTION # 27
You use Enterprise Manager to monitor all the components of your Exadata Database Machine.
Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.
In which two sources would you find diagnostic messages related to this problem?

  • A. alert logs for the ASM instances
  • B. alert logs for the prod database instances
  • C. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
  • D. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
  • E. alert logs for Enterprise Manager

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

Answer: A

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
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. 4,3,2,6,1,7,5
  • C. 2,3,4,6,1,7,5
  • D. 3,2,6,4,1,7,5
  • E. 2,6,1,4,3,7,5

Answer: A


NEW QUESTION # 30
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 LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
  • B. 'crsct1 stop cluster -all' on one of the database servers
  • C. CellCLI alter GRIDDISK all inactive on the affected storage server
  • D. shutdown -h now' on the affected storage server
  • E. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
  • F. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

Answer: C,D

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


NEW QUESTION # 31
Which two statements are true about enabling write-back flash cache?

  • A. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
  • B. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
  • C. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
  • D. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
  • E. Before write-back flash cache is enabled, you need to drop the Flash Cache first.

Answer: C,E

Explanation:
According to the Oracle documentation1, two statements that are true about enabling write-back flash cache are:
Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations (A). This is because write-back flash cache provides better performance and reliability for data file writes than write-through flash cache.
Before write-back flash cache is enabled, you need to drop the Flash Cache first (D). This is because changing the flash cache mode requires recreating the flash cache with a different configuration.


NEW QUESTION # 32
Which two activities are supported on the storage servers in an Exadata Database Machine?

  • A. upgrading the Storage Server software package using rpm
  • B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
  • C. installing an alternative package manager
  • D. configuring secure shell user equivalency for the cellmonitor user
  • E. changing the root password

Answer: D,E

Explanation:
According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
1. changing the root password
2. configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html


NEW QUESTION # 33
Which are two correct statements about backing up Exadata Database Machine?

  • A. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
  • B. For high availability, system area can be on the first two disks and M.2 devices.
  • C. Backing up Exadata Storage Server Software is critical for restoration.
  • D. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
  • E. The M.2 disk is hot pluggable and can be replaced when the power is on, but you will have to restore the system data manually.

Answer: C,D

Explanation:
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 4: Oracle Clusterware [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 8: Oracle Exadata Storage Server Software [3] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 9: Oracle Exadata Storage Server Infrastructure


NEW QUESTION # 34
Which two statements are true about applying updates on Exadata systems?

  • A. Failed database server updates are rolled back to a working state on a previous release automatically.
  • B. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
  • C. Failed storage server updates are automatically rolled back to a previous release.
  • D. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
  • E. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
  • F. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.

Answer: A,C

Explanation:
When applying updates on Exadata systems, database server updates are automatically rolled back to a working state on a previous release if the update fails. This ensures that the system can be restored to a working state in the event of a failed update. Additionally, storage server updates are also automatically rolled back to a previous release in the event of a failed update.
This is documented in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and more information can be found on the Oracle support website [1][2].


NEW QUESTION # 35
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?

  • A. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
  • B. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
  • C. The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.
  • D. The sparse_<DBM_NAME> diskgroup is created automatically.
  • E. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.

Answer: A,E

Explanation:
According to the Oracle Exadata Database Machine Technical Architecture1, the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers includes two ASM disk groups: DATA_<DBM_Name> and RECO_<DBM_NAME>. These disk groups are built on hard disks and flash disks inside the Exadata Storage Servers1.
The correct statements about this configuration are:
Option D: There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes. Storage indexes are a feature of Exadata Storage Software that can improve query performance by avoiding unnecessary I/O operations. Storage indexes use a small amount of flash memory to store metadata about data blocks stored on disk1.
Option E: There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs. Exadata Smart Flash Logs are another feature of Exadata Storage Software that can improve database performance by using flash memory as an extension of the database redo log buffer. This can reduce latency and increase throughput for redo log writes1.


NEW QUESTION # 36
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?

  • A. You must be physically present in the data center to start an Exadata Storage Server.
  • B. -> start /System
  • C. -> start /SYS/power
  • D. -> start /SYSTEM/power
  • E. -> start /SP/console
  • F. -> set /SYS power_state=ON

Answer: F

Explanation:
This command is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. This command sets the power state of the system to ON and starts the storage server. It is the only command that is able to start the storage server remotely. All the other commands are incorrect or require the user to be physically present in the data center.


NEW QUESTION # 37
How do ASM failure groups provide redundancy?

  • A. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
  • B. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
  • C. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
  • D. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

Answer: D

Explanation:
According to Oracle's documentation12, ASM failure groups provide redundancy by storing mirror copies of data on different disks or storage servers. When ASM allocates an extent for a normal redundancy file, ASM allocates a primary copy and a secondary copy. ASM chooses the disk on which to store the secondary copy so that it is in a different failure group than the primary copy1. This way, if one disk or storage server fails, ASM can still access the data from another failure group2.
Therefore, the statement that is true about how ASM failure groups provide redundancy is:
Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.


NEW QUESTION # 38
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

  • A. Cisco management switch
  • B. power supplies in the database servers
  • C. RoCE network interface cards in the database servers
  • D. power distribution units
  • E. RoCE network interface cards in the storage servers
  • F. Cisco RDMA over Converged Ethernet (RoCE) switches
  • G. fans in the storage servers

Answer: B,D,E,F

Explanation:
According to the Oracle Auto Service Request (ASR) documentation1, ASR raises service requests for qualified Oracle products that are detected with specific faults. The qualified Exadata products include2:
Database servers
Storage servers
InfiniBand switches
Cisco switches (X8M and later systems)
Power distribution units (PDUs)


NEW QUESTION # 39
Which two activities are supported on the storage servers in an Exadata Database Machine?

  • A. upgrading the Storage Server software package using rpm
  • B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
  • C. installing an alternative package manager
  • D. configuring secure shell user equivalency for the cellmonitor user
  • E. changing the root password

Answer: D,E

Explanation:
According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
A) changing the root password
E) configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html


NEW QUESTION # 40
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. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
  • B. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 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. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
  • E. 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.

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 Servers2. 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, etc2. 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, etc2. 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 Servers2. 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 reclamation2. 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 server2. 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


NEW QUESTION # 41
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. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
  • B. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
  • C. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
  • D. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

Answer: A

Explanation:
Exachk is an Oracle-provided diagnostic tool that allows you to check various components of an Exadata Database Server, including the client network. The tool is located in the /opt/oracle.SupportTools/exachk/ directory and can be run with the command: exachk. This command can be run with the option -from <Fridays_Date>_17:00:00 and -to <Sundays_Date>_23:59:00 to specify a time range of interest, this way you can check the client network status between the specified time range. The tool checks the status of various components such as network interfaces, InfiniBand fabric, and storage servers. It also analyzes log files, configuration files, and system settings to detect any issues. The tool generates a report, which can be used to identify the root cause of the issue and provide recommendations for resolution.
Tfact1 is a tool to collect diagnostic information from Exadata and non-Exadata systems and it is not related to client network status.
Netcheck and GetExaWatcherResults.sh are not tools provided with the Exadata Database Server and they are not related to client network status.


NEW QUESTION # 42
You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers.
Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?

  • A. on all database servers in the second rack
  • B. on only one database server in both racks
  • C. on all database servers in the first rack
  • D. on all database servers in both racks and one storage server in each rack
  • E. on all database servers and at least two storage servers in both racks
  • F. on all storage servers in both racks
  • G. on at least two storage servers in both racks

Answer: E,G

Explanation:
In order to monitor all components of this multirack configuration, Enterprise Manager agents must be deployed on at least two storage servers in both racks and all database servers in both racks. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book [1], in which it states "To monitor all components of the multirack configuration, you must deploy agents on all database servers and at least two storage servers in each rack" (page 6-15).


NEW QUESTION # 43
......

Prepare Top Oracle 1z1-902 Exam Audio Study Guide Practice Questions Edition: https://www.pass4surequiz.com/1z1-902-exam-quiz.html

Dumps Practice Exam Questions Study Guide for the 1z1-902 Exam: https://drive.google.com/open?id=1kufU2_YcbmCiJGh9u8GLiUO0RBJq5mVE

Related Blogs

more
Oracle 1z1-902 Certification Practice Exam

Copyright © 2026 PASS4SUREQUIZ.COM. All rights reserved. All trademarks are the property of their respective owners and we don't provide actual questions from any vendor.