[Feb-2025] Pass Oracle 1Z0-902 Exam in First Attempt Guaranteed!
Full 1Z0-902 Practice Test and 87 unique questions with explanations waiting just for you, get it now!
NEW QUESTION # 29
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 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
- 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 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
Answer: C,D
NEW QUESTION # 30
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 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
- B. 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
- C. 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
- D. 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
Answer: C,D
Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
NEW QUESTION # 31
Which statement is FALSE about the OEDA command line interface (OEDACU)?
- A. Add or remove additional databases.
- B. OEDACU has Edit mode and Deploy mode.
- C. Support ZDLRA life cycle management operation.
- D. Resize Oracle ASM disk groups.
- E. Add or remove Oracle Database home directories.
- F. Add nodes to and remove nodes from a VM cluster.
Answer: C
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 .
NEW QUESTION # 32
What type of SRs does the ASR Manager generate for Exadata?
- A. hardware assets
- B. data entry errors
- C. backup and restore failures
- D. software assets
- E. operating system components
Answer: A,D
Explanation:
Oracle Auto Service Request (ASR) on Exadata Database Machines is designed to proactively monitor and detect hardware and software issues. When a problem is detected, ASR Manager automatically opens a service request (SR) with Oracle Support. The primary focus of ASR is on hardware assets, such as storage servers, database servers, and network components, as well as software assets related to Exadata System Software and Oracle Database configurations.
NEW QUESTION # 33
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 will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
- B. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
- C. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
- D. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
Answer: D
Explanation:
According to Oracle documentation12, patchmgr is the utility used to update software for Exadata infrastructure components. It can apply patches in a rolling or non-rolling manner depending on the argument and input file provided.
NEW QUESTION # 34
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- B. Install on Oracle Database Appliance.
- C. Provide individual x86 64-Bit gateway hardware.
- D. Install in Oracle Virtual Machine with required hardware.
- E. Install on Exadata Engineered System.
Answer: A,B,D
NEW QUESTION # 35
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 GRIDDISK all inactive on the affected storage server
- B. shutdown -h now' on the affected storage server
- C. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
- D. 'crsct1 stop cluster -all' on one of the database servers
- E. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
- F. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
Answer: B
Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB
NEW QUESTION # 36
You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?
- A. list devices attributes name, deviceName, diskType, physicalFirmware
- B. list celldisk attributes name, deviceName, diskType, physicalFirmware
- C. list cell attributes name, deviceName, diskType, physicalFirmware
- D. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
Answer: B
NEW QUESTION # 37
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 must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
- B. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
- C. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
- D. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
Answer: B
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 # 38
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.
- B. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.
- C. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.
- D. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
Answer: B,C
Explanation:
A recommended configuration best practice for backup and recovery on Exadata is to place the backup network on dedicated switches installed in the top of the rack (ToR). This provides a greater level of control and isolates the backup network from other workloads. Additionally, even if the backup is limited to writing to four tape drives, it is recommended to specify eight channels to expedite the restore process.
Another best practice is to set the RMAN FILESPERSET parameter to 1 for the level 1 incremental backup set. This will optimize the internal Recovery Appliance backup and restore processing. Finally, if off-site long-term backup retention is needed, Oracle Database Backup Cloud Service should be used as a low-cost, offsite scalable storage solution for a disaster recovery solution.
NEW QUESTION # 39
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 "set threshold ds_temp comparison=' >', critical=30" on each database server
- B. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
- C. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
- D. dbmcli -e "set alert ds_temp> 30" on each database server
Answer: A
Explanation:
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 5-54) recommends using the dbmcli command to set thresholds on metrics, such as temperature. To do this, you should use the following command:
dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server.
This will generate an alert if the temperature exceeds 30C.
NEW QUESTION # 40
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. Extended
- B. High
- C. External
- D. Sparse
- E. Normal
Answer: B
Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the customer should use the High redundancy level for their ASM storage in order to ensure that their data is available on the Exadata machine during updates. The High redundancy level provides the most protection against single-node server failure, as it stores three copies of each data file on separate nodes. This is the same redundancy level used for the Oracle Database's Control Files and Redo Logs. Instructions for configuring the ASM redundancy level can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_asm_overview.html.
NEW QUESTION # 41
You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?
- A. cat /proc/net/bonding/bondeth0
- B. netstat -rn
- C. ifconfig -a legrep "re0| re1"
- D. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
Answer: A
Explanation:
According to Oracle's documentation1, the client network on Exadata X9M-2 Database Server is used for client access to the database servers using Single Client Access Name (SCAN) and Oracle RAC Virtual IP (VIP) addresses. To verify that the client network is available via both client switches, you can use the command:
cat /proc/net/bonding/bondeth0
This command displays information about the bondeth0 interface, which is used for the client network on Exadata X9M-2 Database Server2. You can check if both interfaces (eth0 and eth1) are active and connected to different switches3.
NEW QUESTION # 42
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- D. dbmcli -e "LIST IBPORT DETAIL"
Answer: D
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.
NEW QUESTION # 43
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.
7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?
- A. 0
- B. 10, 8, 9, 11
- C. 7,6,9,11
- D. 10, 8, 2, 5
- E. 44, 6, 9
Answer: B
NEW QUESTION # 44
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 to configure Exadata Smart Flash Logs.
- B. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
- C. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
- D. The sparse_<DBM_NAME> diskgroup is created automatically.
- E. 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.
Answer: A,B
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 # 45
You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?
- A. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
- B. The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.
- C. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
- D. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
Answer: B
NEW QUESTION # 46
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, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
- C. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
- D. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 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: B
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 # 47
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- B. Bare Metal deployment with one database per database server
- C. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- D. Multiple Databases on a cluster
- E. A single database with one or more schema per application
- F. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
Answer: C,D,F
NEW QUESTION # 48
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.
- B. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.
- C. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- D. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.
Answer: A,D
Explanation:
According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:
1. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.
2. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.
NEW QUESTION # 49
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. A splitter cable can be used to provide power to all PDU cables.
- B. The installation cannot proceed until two power feeds are available per PDU.
- 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: D
NEW QUESTION # 50
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 GRIDDISK all inactive on the affected storage server
- B. shutdown -h now' on the affected storage server
- C. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
- D. 'crsct1 stop cluster -all' on one of the database servers
- E. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
- F. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
Answer: A,B
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].
NEW QUESTION # 51
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. 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: B
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 # 52
......
Get Latest 1Z0-902 Dumps Exam Questions in here: https://guidetorrent.dumpstorrent.com/1Z0-902-exam-prep.html