Oracle Engineered Systems 1z1-902 Practice Test Engine Try These 87 Exam Questions [Q51-Q72]

admin 1z1-902 Oracle September 7, 2025

4.5/5 - (2 votes)

Oracle Engineered Systems 1z1-902 Practice Test Engine: Try These 87 Exam Questions

Guaranteed Success in Oracle Engineered Systems 1z1-902 Exam Dumps

Oracle 1Z0-902 exam is intended for professionals who want to implement and maintain the Exadata X8M system. 1z1-902 exam covers various topics, including the architecture of the Exadata system, database deployment, configuration, and management, backup and recovery, and performance tuning. 1z1-902 exam requires candidates to have a strong understanding of Exadata X8M components and their interactions.

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

Cloud Control cannot monitor partitioned Exadata Database Machine systems.

Storage nodes forward their SNMP traps to the Management Server process on the same storage node.

Compute nodes forward their SNMP traps to the Management Server process on the same compute node.

Cloud Control can monitor and manage a Database Machine storage Expansion rack.

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.

Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage node.

Q52. Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.

Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.

When backing up multi-rack systems, sharing Exadata X9M switches is recommended.

ZFS Snapshots can provide rapid cloning of development and test environment.

Q53. I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?

OS I/O metrics using Enterprise Manager host pages for the storage servers

OS I/O metrics using OS tools such as iostat on the database servers

I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us

cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

OS I/O metrics using OS tools such as iostat on the storage servers

Q54. Which statement is true about the patching features provided in Platinum Services?

Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

Patching services are available for the full software stack up to twice per year.

The rolling and complete down time approaches are two options to patching.

Patching is done automatically during business hours.

Q55. What are the two benefits of using Oracle Exadata Deployment Assistant (OEDA)?

OEDA facilitates abstracting hardware.

OEDA gathers configuration details and creates the Oracle Exadata Rack configuration file.

OEDA is used for Oracle Exadata Database Machine, Zero Data Loss Recovery Appliance, Private Cloud Appliance, and SuperCluster.

OEDA Web-based user interface cannot import OEDA XML configuration files created with the Java-based version of OEDA without conversion

OEDA provides a CL1 which supports life cycle management tasks for Exadata systems only.

Q56. Which statement is true about the Persistent Memory Commit Accelerator?

Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.

Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).

Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.

Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.

Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.

Q57. Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.

Run exachk and resolve only WARNINGS that you have not seen before.

Run the appropriate patchmgr preqequisite check step for each component being updated.

Run patchmgr –all_comp -autofix -autobackup -upgrade -rolling.

For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.

Q58. 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?

YOU query VSSYSTEM_EVENTS and filter for the event ‘cell physical IO interconnect bytes returned by smart scan’, associated to your table.

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’.

You query v$SYSTAT and filter for the statistic ‘cell smart table scan’, associated to your table.

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.

Q59. Which two statements are true about Exadata System Software metrics and alerts on an Exadata Database Machine?

Metric alerts are never stateful.

Metric thresholds, if set, will persist across storage and database server reboots.

SMTP metric alert notifications must be sent to both ASR manager and Enterprise Manager agents.

Metric alert notifications can be sent to only one destination such as Enterprise Manager OR SNMP OR SMTP.

Metrics have no thresholds set on them by default.

Q60. 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?

patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.

patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.

patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.

Q61. 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?

-> start /System

-> start /SP/console

-> set /SYS power_state=ON

You must be physically present in the data center to start an Exadata Storage Server.

-> start /SYSTEM/power

-> start /SYS/power

Q62. 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?

The installation can go ahead, no change is required.

The installation cannot proceed until two power feeds are available per PDU.

A splitter cable can be used to provide power to all PDU cables.

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.

Q63. Which three statements are true about the CELLCLI command?

It can execute commands on multiple storage servers in parallel.

It has command-line history.

It requires root privileges to create CELLDISKS and GRIDDISKS.

It can be executed on storage servers.

It can be executed using the DCLI utility.

Q64. Which are two correct statements about backing up Exadata Database Machine?

Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.

Backing up Exadata Storage Server Software is critical for restoration.

For high availability, system area can be on the first two disks and M.2 devices.

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.

Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.

Q65. Assume that the RDBMS and ASM instances are up and you are enabling write-back flash cache in one cell server at a time.
Which step(s) should you perform before executing the following command you your Exadata X9M-8 Database Machine, which will set the cell flash cache mode to write-back?
#cellcli -e alter cell flashCacheMode=WriteBack

Inactivate the grid disks on the cell.

Inactivate all the physical disks on the cell.

Drop the existing flash cache on the cell.

Shut down the CELL5RV service on the cell.

Disable the storage indexes on the cell.

Create a new flash cache on the cell.

Q66. You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Exadata Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

No thresholds need to be set because they are preset in the ILOM and in Enterprise Manager

Set thresholds in ILOM and in Enterprise Manager because they are not preset anywhere and must be set in both places.

Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.

No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.

Q67. What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

Oracle Linux 7.5

Oracle Linux 7.9

Oracle Linux 8.0

Oracle Linux 7.7

Q68. Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

the failure of physical disk 1

corruption in the / (root) filesystem

the failure of both physical M.2 disks

the failure of physical disk 0 and 11

moving all disks from one cell to another as part of a chassis-level component failure

accidental loss of all data from all griddisks in a storage server

corruption in a normal or high redundancy ASM diskgroup

Q69. 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?

Normal

Sparse

High

External

Extended

Q70. How do ASM failure groups provide redundancy?

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.

Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

Extended Redundancy mirrors data across data centers providing the highest levels of data protection.

Q71. 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?

CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

CeLLCLI> list GRIDDISK where status != ‘inactive’ on the affected storage server

‘crsct1 stop cluster -all’ on one of the database servers

CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != ‘Yes’ on the affected Storage server

CellCLI alter GRIDDISK all inactive on the affected storage server

shutdown -h now’ on the affected storage server

Q72. Which two statements are true about applying updates on Exadata systems?

Failed storage server updates are automatically rolled back to a previous release.

To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.

Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.

For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.

Failed database server updates are rolled back to a working state on a previous release automatically.

When running a “yum update” for a new Exadata release, all other repositories should be disabled.

Test Engine to Practice 1z1-902 Test Questions: https://www.validexam.com/1z1-902-latest-dumps.html

Oracle Engineered Systems 1z1-902 Practice Test Engine Try These 87 Exam Questions [Q51-Q72]

Written by admin

Leave a Reply Cancel reply

1z1-902 Practice Tests

Related Certifications

Recent Posts

Archives

Categories