Printable & Easy to Use 1Z0-902 Dumps 100% Same Q&A In Your Real Exam [Q11-Q35] – IT Certification Exam Questions & Answers

Rate this post

Printable & Easy to Use 1Z0-902 Dumps 100% Same Q&A In Your Real Exam

1Z0-902 Practice Test Give You First Time Success with 100% Money Back Guarantee!

Learn about the Need for Oracle 1Z0-902 Exam

Oracle 1Z0-902 Exam is a very popular certification. If you want to make a career in the field of Oracle, you have to prepare for this certification.

As we all know, there are many people who are interested in this certification, but they do not have any idea about the preparation process for this certification. So, we are here to help you.

This is the guide which has been written for you. We have collected many resources from the internet and added some of our own.

You will find the things you need to know about this certification, including the test format, the questions and answers, the required preparation time, the required materials, etc. We hope this guide could help you. Oracle 1Z0-902 exam dumps will help you to get certified in your first attempt.

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

ASM instances

Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers

the storage server ILOM

the Power Distribution Units (PDUs)

Oracle clusterware on the database server

the RDMA over Converged Ethernet (RoCE) switches

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

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.
E Download and run the latest exadiag tool.

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

QUESTION 13
You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers.
Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?

on at least two storage servers in both racks

on only one database server in both racks

on all database servers in the first rack

on all storage servers in both racks

on all database servers and at least two storage servers in both racks

on all database servers in the second rack

on all database servers in both racks and one storage server in each rack

QUESTION 14
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 15
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?

4,3,2,6,1,7,5

3,2,6,4,1,7,5

2,3,4,6,1,7,5

3,2,6,1,4,7,5

2,6,1,4,3,7,5

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

QUESTION 17
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 18
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.

There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.

OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.

OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.

QUESTION 19
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

Oracle Linux 7.5

Oracle Linux 6.9

Oracle Linux 8.0

Oracle Linux 7.7

QUESTION 20
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?

using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

using the CELLCLI CALIBRATE command on the storage server after logging in as the root user

hardware monitoring using the storage server ILOM

using the CELLCLI list LUN DETAIL command as the celladmin user

QUESTION 21
You are adding a disk expansion kit to a running Exadata X8M Database Machine’s Database Servers, and have a filesystem layout that includes:

After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?

# lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral

# xfs_growfs /uOl +20G

# resize2fs +20G /dev/VGExaDb/LVDbOral

# lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral

QUESTION 22
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

6, 2, 1, 8, 4, 5

6, 8, 3, 4, 2, 1

6, 3, 1, 9, 7, 8

6, 1, 2, 7, 5, 8

QUESTION 23
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

Install on Oracle Database Appliance.

Provide individual x86 64-Bit gateway hardware.

Install in Oracle Virtual Machine with required hardware.

Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Install on Exadata Engineered System.

QUESTION 24
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 25
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 26
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 27
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.

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

QUESTION 29
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

RoCE network interface cards in the storage servers

fans in the storage servers

Cisco RDMA over Converged Ethernet (RoCE) switches

RoCE network interface cards in the database servers

power distribution units

Cisco management switch

power supplies in the database servers

QUESTION 30
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 31
An Exadata storage server physical disk on an X9M-2 high-capacity full rack entered the predictive failure state. Which two steps must you perform to replace this failed physical disk?

Replace the failed physical disk.

Add the griddisks back into the ASM diskgroup they used to be a member of.

Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.

Rebalance the data on the effected griddisks before performing a manual drop command.

Create a new celldisk and new griddisks on the replaced physical disk.

Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.

QUESTION 32
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

Add 12x 32GB DIMMs.

Add 12x 64GB DIMMs.

Shutdown the Database Server if running.

Add 16x 32GB DIMMs.

Add 16x 64GB DIMMs.

Memory cannot be expanded on Exadata X9M-2 Database Servers.

Remove existing memory modules.

Add 32x 64GB DIMMs.

Add 24x 32GB DIMMs.

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

Copy and execute the script on all storage servers using the EXACLI command.

Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.

Copy and execute the script on all storage servers using the dcli command.

Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.

Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.

QUESTION 34
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?

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

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

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

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

QUESTION 35
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

RoCE network interface cards in the storage servers

fans in the storage servers

Cisco RDMA over Converged Ethernet (RoCE) switches

RoCE network interface cards in the database servers

power distribution units

Cisco management switch

power supplies in the database servers

What is the importance of the Oracle Exadata Database Machine X9M Implementation Essentials Certification?

We all know that the Oracle Exadata Database Machine X9M is a powerful database machine which is designed to manage large-scale data. And the Oracle Exadata Database Machine X9M Implementation Essentials Certification is the latest Oracle certification. It is one of the most popular certifications. Oracle 1Z0-902 exam dumps will help you to get certified. In contrast, if you don’t have this certification, then you will not be able to get a high-paying job.

In this certification, you will learn the implementation details of the Exadata Database Machine X9M and you will be given the practical knowledge to implement the Oracle Exadata Database Machine X9M.

You will learn how to configure, deploy, and manage the Oracle Exadata Database Machine X9M.

You will also understand the architecture of the Oracle Exadata Database Machine X9M and the related components.

As the title says, the Oracle Exadata Database Machine X9M Implementation Essentials Certification is one of the most important certifications.

It is widely regarded as the most comprehensive and detailed Oracle certification. There are no other Oracle certifications that cover the same amount of topics.

The main reason is that the Exadata Database Machine X9M Implementation Essentials Certification covers all the latest Oracle Exadata Database Machine X9M features.

Fully Updated Free Actual Oracle 1Z0-902 Exam Questions: https://www.it-tests.com/1Z0-902.html