[Full-Version] 2025 New Preparation Guide of Oracle 1Z0-902 Exam [Q42-Q61] : IT Certification Exam Braindumps : http://blog.braindumpsit.com

QUESTION 42
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.

With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.

With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.

With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.

QUESTION 43
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

SQL Plan Quarantine

Manually created Quarantine

Database Quarantine

Disk Region Quarantine

Cell Offload Quarantine

QUESTION 44
Which two statements are true in regards to starting the Exadata Virtual Machine?

To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.

Use vm_maker -start-domain to start a virtual machine manually.

Use vm_maker boot-from-iso command to boot a virtual machine.

To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.

Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.

QUESTION 45
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?

10, 8, 2, 5

4,1, 6, 9

3

10, 8, 9, 11

7,6,9,11

QUESTION 46
Which two statements are true about the IPTables firewall configuration on a new Exadata Database Machine after initial deployment?

IPTables is installed and available but not configured or running on the storage servers.

IPTables is configured and running with Oracle-supplied rules on the storage servers.

IPTables is configured and running with Oracle-supplied rules on the database servers.

IPTables is installed and available but not configured or running on the database servers.

IPTables is installed and available but not configured on any server.

QUESTION 47
Which three of the following options are available for database consolidation on Exadata?

Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

Bare Metal deployment with one database per database server

A single database with one or more schema per application

Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently

Multiple Databases on a cluster

Multiple Virtual Machine clusters supporting a single database for greatest resource isolation

QUESTION 48
Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?

Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.

Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.

In order to configure the servers with Oracle Exadata Deployment Assistant (OEDA), the new server information must be entered in OEDA, and the configuration file must contain existing nodes.

The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.

It is required to install OEDA on the first new database server.

QUESTION 49
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

SQL Plan Quarantine

Manually created Quarantine

Database Quarantine

Disk Region Quarantine

Cell Offload Quarantine

QUESTION 50
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.

QUESTION 51
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?

2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.

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.

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.

3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.

1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.

QUESTION 52
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

QUESTION 53
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

QUESTION 54
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.

QUESTION 55
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?

The sparse_<DBM_NAME> diskgroup is created automatically.

There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.

The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.

There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.

There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.

QUESTION 56
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

QUESTION 57
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

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

ASR Manager must be installed and configured on a dedicated server external to the Database Machine.

Configuring ASR is mandatory for all Database Machine assets.

ASR Manager must be installed and configured on one of the database servers.

ASR can upload configuration metadata to support problem resolution.

ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.

ASR communicates with Oracle support services using HTTPS.

QUESTION 59
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?

5, 8, 7, and 6

4, 7, 8, 3, and 6

2, 8, 7, 3, and 6

2, 7, 8, and 6

1, 8, 7, 3 and 6

QUESTION 60
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.

914mm of space required above the rack height is required for maintenance access.

The incline of any access route ramp must be less than or equal to 6 degrees.

All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.

Oracle Exadata Rack may only be installed on raised floor environments.

A conditioned space is required to remove the packaging material to reduce particles before entering the data center.

QUESTION 61
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?

Ask the system administrator to replace the broken disk with a spare.

Check the database to see if any rebalance operations are active.

Call Oracle Support and make an appointment so that the drive can be replaced.

Wait for the email of the failure that Exadata or Enterprise Manager will send.

Download and run the latest exadiag tool.

Wait for a blue light to appear on the disk if the rebalance operation is running.