Enhance Your Career With Available Preparation Guide for 1Z0-902 Exam [Q18-Q39]

Enhance Your Career With Available Preparation Guide for 1Z0-902 Exam

Get Special Discount Offer of 1Z0-902 Certification Exam Sample Questions and Answers

Oracle 1Z0-902 exam is intended for professionals who have a solid understanding of Oracle Database and Exadata concepts. Candidates for this certification exam should have experience with Exadata Database Machine X8M implementation, configuration, and administration. They should also be familiar with Exadata software, hardware, and networking components. 1Z0-902 exam is designed to validate the skills necessary to implement and configure an Exadata Database Machine X8M.

 

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

• A. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
• B. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
• C. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
• 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 # 19
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. 7,6,9,11
• B. 10, 8, 2, 5
• C. 44, 6, 9
• D. 0
• E. 10, 8, 9, 11

Answer: E

NEW QUESTION # 20
Which three statements are true about the CELLCLI command?

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

Answer: A,B,E

Explanation:
The CELLCLI utility is a command line interface to Exadata that enables the execution of commands across multiple storage servers in parallel. It also has command-line history, so users can easily recall previously entered commands. Furthermore, the CELLCLI utility can be executed using the DCLI utility, which provides a convenient way to execute commands on multiple storage servers simultaneously.
However, CELLCLI does not require root privileges to create CELLDISKS and GRIDDISKS, and it cannot be executed on storage servers. This is because CELLCLI is used to manage the Exadata database machine from the database server [1]. For more information about CELLCLI, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

NEW QUESTION # 21
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 must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
• 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: A

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 # 22
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 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network
• B. 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
• 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: A,D

NEW QUESTION # 23
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. Oracle Exadata Rack may only be installed on raised floor environments.
• D. The incline of any access route ramp must be less than or equal to 6 degrees.
• E. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
• F. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.

Answer: C

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

NEW QUESTION # 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 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: B,D

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

NEW QUESTION # 25
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. -> start /SP/console
• B. -> start /SYS/power
• C. You must be physically present in the data center to start an Exadata Storage Server.
• D. -> start /System
• E. -> start /SYSTEM/power
• 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 # 26
What are two recommended configuration best practices for backup and recovery on Exadata?

• A. 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.
• 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. 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.
• 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:
According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:
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.
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.

NEW QUESTION # 27
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?

• A. hardware monitoring using the storage server ILOM
• B. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
• C. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
• D. using the CELLCLI list LUN DETAIL command as the celladmin user

Answer: A,D

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

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

Answer: D,E

Explanation:
A and F are true statements about Auto Service Request (ASR) with an Exadata Database Machine [1][2]. In order to use the ASR feature, ASR Manager must be installed and configured on a dedicated server which is external to the Database Machine, and it communicates with Oracle support services using HTTPS. Additionally, ASR can upload configuration metadata to support problem resolution, and it can open a service request (SR) automatically after sensors detect hardware faults.
Reference for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1][2].

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

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

Answer: C,D,E,F

NEW QUESTION # 30
Which three of the following options are available for database consolidation on Exadata?

• A. A single database with one or more schema per application
• B. Multiple Databases on a cluster
• C. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
• D. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
• E. Bare Metal deployment with one database per database server
• F. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

Answer: A,B,F

Explanation:
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
A) Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
C) A single database with one or more schema per application12.
E) Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how

NEW QUESTION # 31
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?

• A. hardware monitoring using the storage server ILOM
• B. using the CELLCLI list LUN DETAIL command as the celladmin user
• C. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
• D. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

Answer: A,D

Explanation:
The CELLCLI CALIBRATE command can be used to check the health of all flash cards in the storage server, and it should be run after logging in as the celladmin user. The hardware monitoring using the storage server ILOM should also be used to check for errors and other potential issues with the flash cards. The CELLCLI list LUN DETAIL command should not be used to identify a damaged or failing flash card, since it will not provide any information about the health of the flash card.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/index.html

NEW QUESTION # 32
Which two statements are true in regards to starting the Exadata Virtual Machine?

• A. Use vm_maker -start-domain to start a virtual machine manually.
• B. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
• C. Use vm_maker boot-from-iso command to boot a virtual machine.
• D. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
• E. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.

Answer: A,E

Explanation:
Statement B is true as the vm_maker -start-domain command can be used to start a virtual machine manually, as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 65).
Statement E is also true as the vm_maker -auto-start command can be used to configure a virtual machine to start automatically when the KVM host is started [1][2], as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 66).

NEW QUESTION # 33
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

• A. OECA allows one XT storage server in the configuration.
• B. OECA reconfigures the size of disk groups and recreates grid disks.
• C. OECA extends the hardware for the elastic configuration only.
• D. OECA facilitates PDU power selection initially and after equipment addition.
• E. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.

Answer: B,E

Explanation:
The correct answers are Options A and D. Option A is correct because OECA reconfigures the size of disk groups and recreates grid disks. Option D is correct because OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.

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

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

Answer: A,E

NEW QUESTION # 35
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 power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
• 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 installation can go ahead, no change is required.

Answer: D

Explanation:
According to the Oracle Exadata Database Machine X9M-2 Data Sheet1, 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

NEW QUESTION # 36
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. A single database with one or more schema per application
• C. Multiple Databases on a cluster
• D. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
• E. Bare Metal deployment with one database per database server
• F. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

Answer: A,C,F

Explanation:
A Exadata supports multiple pluggable databases in one or more container databases, which enables database consolidation by allowing multiple databases to be consolidated into a single container database. This can be deployed on a Virtual Machine or Bare Metal cluster.
D Multiple databases spanning a Bare Metal and Virtual Machine cluster provide resource isolation and consolidation concurrently. It allows multiple databases to be deployed on both Bare Metal and Virtual Machine clusters, providing isolation and consolidation at the same time.
E Multiple Databases on a cluster allows multiple databases to be deployed on a single cluster, which enables consolidation of databases by reducing the number of clusters required.

NEW QUESTION # 37
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. Oracle Exadata Rack may only be installed on raised floor environments.
• D. The incline of any access route ramp must be less than or equal to 6 degrees.
• E. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
• F. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.

Answer: C

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

NEW QUESTION # 38
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

• A. Oracle Linux 7.5
• B. Oracle Linux 7.7
• C. Oracle Linux 7.9
• D. Oracle Linux 8.0

Answer: D

Explanation:
RoCE, or Remote Direct Memory Access over Converged Ethernet, is a high-speed networking technology that allows data to be transferred between servers, storage, and other devices over Ethernet. Persistent Memory is a form of non-volatile memory that can be used to store data without losing it when power is lost.
Oracle Linux 8.0 supports both RoCE and Persistent Memory, allowing Exadata systems to leverage the benefits of both technologies. For more information on Oracle Linux 8.0 and its features, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.

NEW QUESTION # 39
......

Updated 1Z0-902 Dumps Questions Are Available For Passing Oracle Exam: https://prep4sure.examtorrent.com/1Z0-902-exam-papers.html