ベスト良質なOracle 1Z0-902試験問題PassTestリアル練習試験 [2025]
重要な試験問題でOracle Exadata Database Machine X8M Implementation Essentials一発合格
質問 # 12
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?
- A. Wait for the email of the failure that Exadata or Enterprise Manager will send.
- B. Check the database to see if any rebalance operations are active.
- C. Download and run the latest exadiag tool.
- D. Wait for a blue light to appear on the disk if the rebalance operation is running.
- E. Call Oracle Support and make an appointment so that the drive can be replaced.
- F. Ask the system administrator to replace the broken disk with a spare.
正解：E
解説：
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], before doing anything else you should call Oracle Support and make an appointment so that the drive can be replaced. If Platinum Support is enabled, then you can call Oracle Support and they will arrange for the disk to be replaced. If Platinum Support is not enabled, then you can arrange for the disk to be replaced through Enterprise Manager Cloud Control.
質問 # 13
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
正解：A、B
解説：
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-administering-asm.html
質問 # 14
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
- A. Collected configuration information can be uploaded manually to Oracle.
- B. It is mandatory to install OCM on at least one database server.
- C. It collects configuration information automatically.
- D. Collected configuration information can be uploaded automatically to Oracle.
- E. It collects configuration information on demand.
- F. It is mandatory to install OCM on all database servers.
正解：A、B、F
解説：
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, OCM is mandatory to install on at least one database server and can be used to collect configuration information on demand. The collected information can then be uploaded either manually or automatically to Oracle.
質問 # 15
Which three statements are true about the CELLCLI command?
- A. It can be executed using the DCLI utility.
- B. It requires root privileges to create CELLDISKS and GRIDDISKS.
- C. It has command-line history.
- D. It can be executed on storage servers.
- E. It can execute commands on multiple storage servers in parallel.
正解：A、C、E
解説：
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].
質問 # 16
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. using the CELLCLI list LUN DETAIL command as the celladmin user
- B. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
- C. hardware monitoring using the storage server ILOM
- D. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
正解：A、B
質問 # 17
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- B. PMEM Cache section within Memory Statistics
- C. PMEM Cache section within Exadata Smart Statistics
- D. PMEM Pool Misses in the Exadata Outlier Summary
- E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
正解：B、C
解説：
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)
質問 # 18
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 8.0
- D. Oracle Linux 7.9
正解：D
解説：
Oracle Linux 7.9 is the minimum version required to support RoCE and Persistent Memory. This is because Oracle Linux 7.9 includes kernel enhancements that enable RDMA over Converged Ethernet (RoCE) networking and Intel Optane DC Persistent Memory Modules (DCPMM) for Exadata X8M systems3. These features allow faster access latency and higher throughput for database workloads2.
質問 # 19
Which statement is true about the Persistent Memory Commit Accelerator?
- A. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
- B. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
- C. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
- D. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
- E. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
正解：C
解説：
Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk. This helps to further reduce redo log write latency by utilizing the speed and low latency of Persistent Memory, along with the Remote Direct Memory Access (RDMA) protocol, to commit changes to disk faster. This allows the system to quickly commit changes to disk, resulting in improved performance and reduced latency.
質問 # 20
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. Cisco management switch
- B. fans in the storage servers
- C. RoCE network interface cards in the storage servers
- D. power supplies in the database servers
- E. power distribution units
- F. RoCE network interface cards in the database servers
- G. Cisco RDMA over Converged Ethernet (RoCE) switches
正解：A、C、D、G
質問 # 21
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 /System
- B. -> start /SYS/power
- C. -> set /SYS power_state=ON
- D. You must be physically present in the data center to start an Exadata Storage Server.
- E. -> start /SP/console
- F. -> start /SYSTEM/power
正解：C
解説：
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.
質問 # 22
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 8.0
- B. Oracle Linux 7.5
- C. Oracle Linux 7.9
- D. Oracle Linux 7.7
正解：A
解説：
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.
質問 # 23
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. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
- C. CellCLI alter GRIDDISK all inactive on the affected storage server
- D. 'crsct1 stop cluster -all' on one of the database servers
- E. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
- F. shutdown -h now' on the affected storage server
正解：C、F
解説：
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
質問 # 24
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. 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.
- C. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- D. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
正解：B
解説：
Failure groups provide redundancy in Oracle Exadata Database Machine X9M by ensuring that mirror copies of the data are written to different storage servers [1][2]. This prevents the potential for mirror copies to be written to the same server, which would cause a data loss if that server were to experience a physical disk failure. Furthermore, failure groups help to ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster, providing an extra layer of data protection. Additionally, Extended Redundancy mirrors data across data centers, providing the highest levels of data protection. Reference: Oracle Exadata Database Machine X9M Implementation Essentials [1][2], Chapter 5: Configuring Oracle ASM.
質問 # 25
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 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
- 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 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、C
解説：
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
質問 # 26
Exadata X9M enables virtualization using KVM. Which statement is true about virtualization on Exadata X9M?
- A. Virtual guests from X8 and earlier can be migrated to X9M using VM Guard.
- B. Up to 12 virtual guests per X9M-2 database server are supported.
- C. Exadata X9M-8 supports up to 48 virtual guests regardless if Exadata Secure RDMA Fabric Isolation is configured.
- D. Up to 12 virtual guests per X9M-2 database server are supported. If the database server memory has 384GB and Exadata Secure RDMA Fabric isolation is configured 8 guests are supported
- E. Oracle KVM Manager should be installed on at least two Database servers per Exadata rack.
正解：B
解説：
Oracle Exadata X9M-2 supports virtualization through Kernel-based Virtual Machine (KVM), enabling multiple virtual machines (VMs) to run on each database server. Specifically:
Each X9M-2 database server can support up to 12 virtual guests. This number provides ample flexibility for running various applications or Oracle Real Application Clusters (RAC) instances across virtualized environments .
While Exadata X9M-8 supports even more extensive virtualization, this question focuses on the X9M-2 model. The specified limitation of 12 guests per database server considers both system resource allocation and performance optimization .
質問 # 27
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 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 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup 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
正解：A、C
質問 # 28
......
Oracle 1z1-902：Oracle Exadata Database Machine X8M Implementation Essentialsは、ITプロフェッショナルの知識とスキルをテストする試験で、Oracle Exadata Database Machine X8Mの実装および管理を行います。試験は、Exadata Database Machineのインストール、設定、最適化能力を検証するように設計されています。Exadata Database Machineは、ハードウェアとソフトウェアを組み合わせて、ミッションクリティカルなデータベースのパフォーマンス、可用性、および拡張性を提供する高性能データベースマシンです。
Oracle Exadata Database Machine X8Mは、エンタープライズワークロードに極端なパフォーマンスとスケーラビリティを提供する強力で高性能データベースマシンです。 OLTP、データウェアハウジング、分析など、最も要求の厳しいデータベースワークロードを処理するように設計されています。 Exadataデータベースマシンx8mを使用すると、組織はデータベースを統合し、パフォーマンスとスケーラビリティを改善しながらITコストを削減できます。
1Z0-902試験問題集合格保証：https://www.passtest.jp/Oracle/1Z0-902-shiken.html
ベスト良質なOracle 1Z0-902試験問題：https://drive.google.com/open?id=1cGph66FBidb25JV4WgeDBdTwU0OVR7tS