[Mar-2025] 1z1-902 Questions - Truly Beneficial For Your Oracle Exam [Q26-Q50]

[Mar-2025] 1z1-902 Questions - Truly Beneficial For Your Oracle Exam

Download Oracle 1z1-902 Sample Questions

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

• A. For high availability, system area can be on the first two disks and M.2 devices.
• B. 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.
• C. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
• D. Backing up Exadata Storage Server Software is critical for restoration.
• E. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.

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
https://www.oracle.com/technetwork/database/availability/exadata-backup-recovery-bp-3633870.pdf

NEW QUESTION # 27
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 physicaldisk attributes name, deviceName, diskType, physicalFirmware
• B. list devices attributes name, deviceName, diskType, physicalFirmware
• C. list cell attributes name, deviceName, diskType, physicalFirmware
• D. list celldisk attributes name, deviceName, diskType, physicalFirmware

Answer: A

Explanation:
This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85).

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

Answer: C

Explanation:
In order to completely power off an Exadata Database Machine in an orderly fashion, it's important to properly shut down the cluster first. The command "crscti stop cluster" as root should be executed from one of the database servers.
Once the cluster has been stopped, the next step is to shut down the database servers by executing the command "shutdown -h now" on all database servers.
Next, shut down the Exadata storage servers by executing the command "shutdown -h now" on all Exadata storage servers.
Finally, power off the rack using the power switches on the PDUs.

NEW QUESTION # 29
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 list LUN DETAIL command as the celladmin user
• D. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

Answer: A,C

NEW QUESTION # 30
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. Sparse
• B. High
• C. Normal
• D. Extended
• E. External

Answer: B

Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf

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

Explanation:
An Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs would typically require two power feeds per PDU, one for each of the two power distribution units (PDUs) in the rack. A single power feed per PDU is not sufficient to provide the necessary power to the servers and storage in the rack.

NEW QUESTION # 32
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

• A. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
• B. ZFS Snapshots can provide rapid cloning of development and test environment.
• C. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
• D. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.

Answer: A,D

Explanation:
1. ZFS Storage Appliance (ZFSSA) can't connect directly to the Exadata 100Gb RoCE network switches. ZFSSA uses Fibre Channel protocol to connect to the Exadata storage cells. C. When backing up multi-rack systems, sharing Exadata X9M switches is not recommended. Each rack should have its own switches to minimize the risk of data loss due to switch failure.

NEW QUESTION # 33
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. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 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. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 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: A

Explanation:
Oracle KVM Guest, Oracle Enterprise Manager Agent (OMA), RDBMS instance, Automatic Diagnostic Repository Command Interpreter (ADRCI), CELLCLI, diskmon, and Restart Server (RS) can all run on the database servers. The Cell Server (CELLSRV) and Management Server (MS) can both run on the Exadata storage servers. Specific instructions for installing and configuring these software components can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_software_components.html.

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

• A. It can be executed using the DCLI utility.
• 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 requires root privileges to create CELLDISKS and GRIDDISKS.

Answer: A,B,D

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.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-cellcli.htm

NEW QUESTION # 35
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 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.
• B. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
• C. 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'.
• D. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

Answer: B,C

Explanation:
The two actions that are not appropriate for monitoring how a large production table is accessed in order to leverage the benefits of the Exadata Platform are A) querying VSSYSTEMEVENTS and filtering for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table; and B) querying v$segmentstatistics and filtering for the Object ID of your table from dbaobjects and the the column STATISTICNAME='optimized physical reads'. Instead, you should query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table (C), or 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). These two methods are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Monitoring the Exadata Database Machine).

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

• A. 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.
• B. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
• C. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
• D. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

Answer: C

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 # 37
Which two steps concise the path used to communicate with Enterprise Manager from an Exadata Database Machine?

• A. SNMP traps for alerts are sent by the storage server RS process to the Enterprise Manager agent.
• B. SNM? traps for alerts are sent by the storage server ILOM to the Enterprise Manager agent.
• C. SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agent.
• D. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process.
• E. SNMP traps for alerts are sent by the storage server RS process to the storage server ILOM.
• F. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.
• G. SNMP traps for alerts are sent by the storage server ILOM to the storage server is process.

Answer: B,C

Explanation:
In an Exadata environment, the path of communication for SNMP traps involves:
Management Server (MS) Process to EM Agent: Alerts related to the storage server are generated by the MS process, which then forwards SNMP traps directly to the Enterprise Manager agent, allowing centralized monitoring and alert management.
ILOM to EM Agent: The ILOM on each Exadata storage server can independently send SNMP traps to the EM agent, providing additional hardware-level monitoring and alerting capabilities .
These pathways ensure that alerts from both hardware and software layers reach Enterprise Manager efficiently, supporting proactive management and rapid response to system issues.

NEW QUESTION # 38
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

• A. 384GB
• B. 768GB
• C. 512GB
• D. 1024GB
• E. 1536GB
• F. 2048GB

Answer: E

Explanation:
According to 1, Exadata X9M-2 Database Servers are based on Intel Xeon Platinum 8368Y processors with 32 cores and 768 GB of DRAM memory per server. This memory can be expanded up to 1.5 TB per server by adding 24 x 32 GB DIMMs. The DRAM memory is used for buffer cache, PGA, and other database purposes1. Exadata X9M-2 Database Servers also have 25.6 TB of Persistent Memory Acceleration (PMEM) per server, which is used for log writes and columnar data caching1. PMEM is a new type of memory that combines the speed of DRAM with the persistence of flash2. Exadata X9M-2 Database Servers are designed to run Oracle Database workloads with high performance, scalability, and reliability2

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

Answer: C

NEW QUESTION # 40
Which three statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?

• A. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
• B. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage node.
• C. Compute nodes forward their SNMP traps to the Management Server process on the same compute node.
• D. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
• E. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.
• F. Cloud Control can monitor and manage a Database Machine storage Expansion rack.

Answer: B,E,F

Explanation:
Oracle Enterprise Manager (EM) Cloud Control provides comprehensive monitoring and management for Exadata Database Machines, including:
Support for Database Machine Storage Expansion Racks: EM Cloud Control seamlessly integrates with the Storage Expansion Rack, allowing administrators to monitor both primary and expansion storage environments together, which is essential for large-scale deployments.
Minimal Agent Installation: Cloud Control needs only one Oracle Management Agent on one compute node to monitor the entire Database Machine cluster, covering all compute and storage nodes. This is due to Exadata's interconnect and resource-sharing capabilities, enabling centralized monitoring with minimal setup requirements.

NEW QUESTION # 41
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. 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. 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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

Answer: B,D

NEW QUESTION # 42
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 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.
• D. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
• E. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.

Answer: C

Explanation:
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.
This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1][2]. The Persistent Memory Commit Accelerator uses Persistent Memory and Remote Direct Memory Access (RDMA) technology to write redo log data to Flash and disk, resulting in improved latency and higher throughput. Additionally, the Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash [1], further reducing latency.

NEW QUESTION # 43
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 # 44
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 and execute the script on all storage servers using the dcli command.
• B. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
• C. Copy and execute the script on all storage servers using the EXACLI command.
• D. Copy the script to all storage servers using the dcli command and manually execute it 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 # 45
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

• A. Cell Offload Quarantine
• B. Manually created Quarantine
• C. Database Quarantine
• D. SQL Plan Quarantine
• E. Disk Region Quarantine

Answer: B,C

NEW QUESTION # 46
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 physicaldisk attributes name, deviceName, diskType, physicalFirmware
• C. list cell attributes name, deviceName, diskType, physicalFirmware
• D. list celldisk attributes name, deviceName, diskType, physicalFirmware

Answer: D

NEW QUESTION # 47
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. Memory cannot be expanded on Exadata X9M-2 Database Servers.
• B. Remove existing memory modules.
• C. Add 32x 64GB DIMMs.
• D. Add 12x 32GB DIMMs.
• E. Add 16x 64GB DIMMs.
• F. Add 16x 32GB DIMMs.
• G. Add 24x 32GB DIMMs.
• H. Add 12x 64GB DIMMs.
• I. Shutdown the Database Server if running.

Answer: B,E,I

Explanation:
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.
The steps required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration are as follows:
Shutdown the Database Server if running.
Remove existing memory modules.
Add 16x 64GB DIMMs.
For reference, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "the lowest memory configuration for the Exadata X9M-2 Database Servers is 384GB and the highest is 768GB [1]. The memory upgrade is done in increments of 64GB using 16x 64GB DIMMs".

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

• A. 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.
• B. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
• C. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
• D. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

Answer: C

Explanation:
In an Automatic Storage Management (ASM) environment, failure groups are used to provide redundancy for the storage disks. Failure groups are used to group together a set of disks and ensure that no two copies of the same data are stored on the same physical disk or storage server. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
For example, if the disks in a failure group are mirrored, one copy of the data is stored on one set of disks, and the other copy is stored on another set of disks. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
ASM failure groups also provide the option to spread the data across different storage servers, this way, even if a storage server fails, data can still be accessed from the other storage servers in the group. This will improve the availability of the data.

NEW QUESTION # 49
You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.
Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?

• A. to the CELLMONITOR account using cellcli interactively on each storage server
• B. to the CELLADMIN account using cellcli interactively on each storage server
• C. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
• D. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
• E. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
• F. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli

Answer: A,D,F

NEW QUESTION # 50
......

Truly Beneficial For Your Oracle Exam: https://www.pass4leader.com/Oracle/1z1-902-exam.html

Real 1z1-902 Exam Questions and Answers FREE: https://drive.google.com/open?id=1rmUhRkXmAiw_CwB40hRyzLVS0MxivjLq