Ultimate Guide to Prepare 1z1-902 with Accurate PDF Questions [May 02, 2025]
Pass Oracle With ITPassLeader Exam Dumps
Oracle Exadata Database Machine X8M is a high-performance database system that is designed to deliver extreme performance for mission-critical workloads. This system is specifically designed to provide maximum performance, scalability, and availability for Oracle Database workloads. The Oracle Exadata Database Machine X8M combines the latest hardware and software technologies, including Oracle Database, Oracle Exadata Storage Server, and Oracle Exadata Database Server, to deliver unmatched performance and scalability. By earning the Oracle 1Z0-902 certification, professionals can demonstrate their ability to implement and manage this powerful database system, which is in high demand among organizations that require high-performance, mission-critical database solutions.
Know about the Passing Score, Duration & Questions for the Oracle 1Z0-902 Exam
Number of Questions: 60 Questions
Time Duration: 90 Minutes
Languages: English
The passing score: 64%
Formate: Multiple Choice
NEW QUESTION # 15
Which two statements are true about applying updates on Exadata systems?
- A. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- B. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- C. Failed database server updates are rolled back to a working state on a previous release automatically.
- D. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- E. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- F. Failed storage server updates are automatically rolled back to a previous release.
Answer: C,F
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 # 16
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Install on Oracle Database Appliance.
- B. Install on Exadata Engineered System.
- C. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- D. Install in Oracle Virtual Machine with required hardware.
- E. Provide individual x86 64-Bit gateway hardware.
Answer: B,C,E
Explanation:
These options are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources. The customer can choose to either provide their own x86 64-Bit gateway hardware or purchase the recommended hardware from Oracle, or they can install the gateway on an Exadata Engineered System.
NEW QUESTION # 17
You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?
- A. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
- B. Copy and execute the script on all storage servers using the dcli command.
- C. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
- D. Copy and execute the script on all storage servers using the EXACLI command.
- E. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
Answer: E
Explanation:
This can be done by using the 'cellcli -e' command, which allows you to execute commands in parallel on all storage servers. For more information about executing CELLCLI commands in parallel, please refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].
NEW QUESTION # 18
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- B. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- C. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- D. Run the appropriate patchmgr preqequisite check step for each component being updated.
- E. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- F. Run exachk and resolve only WARNINGS that you have not seen before.
Answer: A,B,D,E
NEW QUESTION # 19
Which three statements are true about the CELLCLI command?
- A. It requires root privileges to create CELLDISKS and GRIDDISKS.
- B. It has command-line history.
- C. It can execute commands on multiple storage servers in parallel.
- D. It can be executed on storage servers.
- E. It can be executed using the DCLI utility.
Answer: B,D,E
Explanation:
The CellCLI utility supports command-line history.
Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface.
The dcli utility facilitates centralized management across an Oracle Exadata Storage Server Software realm by automating the execution of CellCLI commands on a set of cells and returning the output to the centralized management location where the dcli utility was run.
NEW QUESTION # 20
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
- C. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- D. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
Answer: A
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
NEW QUESTION # 21
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. 3,2,6,4,1,7,5
- C. 2,3,4,6,1,7,5
- D. 4,3,2,6,1,7,5
- E. 2,6,1,4,3,7,5
Answer: C
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 # 22
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?
- A. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- B. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
- C. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
- D. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
Answer: A,D
Explanation:
1. Querying VSSYSTEM_EVENTS for the event 'cell physical IO interconnect bytes returned by smart scan' will not be appropriate for monitoring the access on a particular table. The V$SYSTEM_EVENT view is used to monitor system-wide performance statistics, not specific table access. C. Querying v$SYSTAT for the statistic 'cell smart table scan' will not be appropriate for monitoring the access on a particular table as well. The v$SYSTAT view contains system-wide performance statistics, not specific table access.
NEW QUESTION # 23
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?
- A. OECA facilitates PDU power selection initially and after equipment addition.
- B. OECA extends the hardware for the elastic configuration only.
- C. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
- D. OECA allows one XT storage server in the configuration.
- E. OECA reconfigures the size of disk groups and recreates grid disks.
Answer: A,B
Explanation:
B and E are true statements for the Oracle Exadata Configuration Assistant (OECA). OECA facilitates PDU power selection initially and after equipment addition, and it allows for the elastic configuration of the hardware. It does not reconfigure the size of disk groups or recreate grid disks, nor does it allow for a single XT storage server in the configuration. The "Add Equipment" input option does allow for the allocation of RU slots for customer equipment.
References for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources.
Search results: [1] Oracle Exadata Database Machine X8-2 [1][2]: Configuration Assistant Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [2] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Add Equipment: This input option allows you to allocate RU slots for ... [3] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [4] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Power Selection [1][2]: This input option allows you to select PDU power initially ... [5] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ...
NEW QUESTION # 24
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 incline of any access route ramp must be less than or equal to 6 degrees.
- B. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- C. 914mm of space required above the rack height is required for maintenance access.
- D. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- E. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- F. Oracle Exadata Rack may only be installed on raised floor environments.
Answer: F
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 # 25
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. High
- B. Extended
- C. Normal
- D. External
- E. Sparse
Answer: C
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 dependencies2. 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
NEW QUESTION # 26
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- B. PMEM Pool Misses in the Exadata Outlier Summary
- C. PMEM Cache section within Exadata Smart Statistics
- D. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- E. PMEM Cache section within Memory Statistics
Answer: C,E
Explanation:
The AWR report has two sections that show statistics for X9M Persistent Memory Cache: the PMEM Cache section within Memory Statistics and the PMEM Cache section within Exadata Smart Statistics. Both of these sections provide detailed information about the read and write hits and misses, as well as the total capacity and utilization of the PMEM cache. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 515)
NEW QUESTION # 27
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 16x 32GB DIMMs.
- B. Shutdown the Database Server if running.
- C. Add 24x 32GB DIMMs.
- D. Remove existing memory modules.
- E. Add 32x 64GB DIMMs.
- F. Add 12x 64GB DIMMs.
- G. Add 12x 32GB DIMMs.
- H. Add 16x 64GB DIMMs.
- I. Memory cannot be expanded on Exadata X9M-2 Database Servers.
Answer: B,D,E
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/
NEW QUESTION # 28
In order two support a new application, you are planning to add a RAC VM cluster to an existing Oracle Exadata X9M-2 deployment.
Which two methods can be considered?
- A. Use the xm command.
- B. Use the OEDA Command line interface.
- C. Use Oracle VM Manager.
- D. Use the OEDA web-based configuration tool.
- E. Use domu_maker utility.
Answer: B,D
Explanation:
For adding a new RAC (Real Application Clusters) VM cluster to an existing Oracle Exadata X9M-2 deployment, you can utilize the Oracle Exadata Deployment Assistant (OEDA). OEDA is available in two interfaces:
OEDA Web-based Configuration Tool: This web-based interface facilitates the configuration of Exadata environments, supporting both physical and virtual deployments. The graphical interface helps in defining VM clusters, including RAC clusters, and ensures the configuration aligns with Oracle best practices.
OEDA Command Line Interface (CLI): For more advanced or automated tasks, the command-line interface (oedacli) allows for precise control over the deployment process. It supports various configuration actions such as adding or removing clusters, resizing ASM disk groups, and managing VM clusters.
These tools are specifically designed for Exadata configurations and provide a streamlined approach for deploying and managing RAC clusters in both physical and virtualized environments.
NEW QUESTION # 29
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 Database server and install the MS APEX application.
- B. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
- C. 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.
- D. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
Answer: B
Explanation:
To enable REST access to the MS process, you need to manually enable the REST services on each storage server by running the command cellcli -e "ALTER CELL ENABLE REST" and then configure authentication and authorization to ensure secure access. This is described in detail in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Securing the Exadata Database Machine).
NEW QUESTION # 30
Which two statements are true about applying updates on Exadata systems?
- A. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- B. Failed database server updates are rolled back to a working state on a previous release automatically.
- C. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- D. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- E. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- F. Failed storage server updates are automatically rolled back to a previous release.
Answer: C,F
Explanation:
According to Oracle's documentation12, some of the statements that are true about applying updates on Exadata systems are:
Failed storage server updates are automatically rolled back to a previous release1.
When running a "yum update" for a new Exadata release, all other repositories should be disabled1.
NEW QUESTION # 31
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?
- A. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- B. the storage server ILOM
- C. Oracle clusterware on the database server
- D. the RDMA over Converged Ethernet (RoCE) switches
- E. the Power Distribution Units (PDUs)
- F. ASM instances
Answer: A,C,F
Explanation:
Exadata-specific Enterprise Manager Plug-Ins are used to monitor different components of the Exadata Database Machine.
1. ASM instances: The Automatic Storage Management (ASM) instances can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the storage space, disk usage, and performance of the ASM instances.
2. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers: The HCC ratios on Extended (XT) storage servers can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the compression ratios and performance of the storage servers.
3. Oracle clusterware on the database server: The Oracle clusterware on the database server can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the health and performance of the clusterware.
NEW QUESTION # 32
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 384GB
- B. 1536GB
- C. 768GB
- D. 512GB
- E. 1024GB
- F. 2048GB
Answer: F
NEW QUESTION # 33
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 # 34
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 "create threshold ds_temp comparison='>', critical=30" on each database server
- B. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
- C. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
- D. dbmcli -e "set alert ds_temp> 30" on each database server
Answer: D
NEW QUESTION # 35
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 opens a service request (SR) automatically after sensors detect hardware faults.
- C. ASR Manager must be installed and configured on one of the database servers.
- D. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- E. Configuring ASR is mandatory for all Database Machine assets.
- F. ASR communicates with Oracle support services using HTTPS.
Answer: C,D
NEW QUESTION # 36
......
Oracle 1Z0-902 exam is a valuable credential for professionals who work with Oracle Exadata Database Machine X8M. It demonstrates to employers and clients that the individual has the necessary skills and knowledge to implement and manage this powerful computing platform. Earning this certification can also lead to career advancement opportunities and increased earning potential.
Latest 1z1-902 Exam Dumps - Valid and Updated Dumps: https://www.itpassleader.com/Oracle/1z1-902-dumps-pass-exam.html
Fully Updated 1z1-902 Dumps - 100% Same Q&A In Your Real Exam: https://drive.google.com/open?id=1YtLjCuJQXpee315OWP3B6jDsVyAmaGRj