Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1Z0-902 by Oracle - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 60

1 2 3

→

Know a question that should be here? Contribute to this exam

Which two activities are supported on the storage servers in an Exadata Database Machine? (Choose two.)

A upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
B installing an alternative package manager
C changing the root password
D configuring secure shell user equivalency for the cellmonitor user
E upgrading the storage Server software package using RPM

You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should you use to generate alerts for such an event?

A dbmcli -e "set alert ds_temp> 30" on each database server
B dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
C dbmcli -e "set threshold ds_temp comparison='>', critical=30" on each database server
D dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server

Which are two correct statements about backing up Exadata Database Machine? (Choose two.)

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

Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)? (Choose two.)

A There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
B OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
C OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
D OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.

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

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

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 Call Oracle Support and make an appointment so that the drive can be replaced.
B Download and run the latest exadiag tool.
C Wait for the email of the failure that Exadata or Enterprise Manager will send.
D Wait for a blue light to appear on the disk.
E Ask the system administrator to replace the broken disk with a spare.

Which two statements describe the memory capabilities of the X9M-2 Exadata Systems? (Choose two.)

A The High Capacity (HC) and Extreme Flash (EF) Storage Server comes with 384 GB memory default.
B The Database Server can contain 768 GB memory.
C The High Capacity (HC) and Extreme Flash (EF) Storage Server contains 256 GB memory.
D The Database Server comes with 384 GB memory default.
E The Database Server can contain 2048 GB memory.
F The Eighth Rack Database Server comes with 512 GB memory default.

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? (Choose two.)

A on all database servers and at least two storage servers in both racks
B on all storage servers in both racks
C on all database servers in the second rack
D on all database servers in both racks and one storage server in each rack
E on all database servers in the first rack
F on only one database server in both racks

Which tool should you use to model an Exadata rack layout?

A Oracle Exadata Instantiation Assistant
B Oracle Exadata Configuration Assistant
C Oracle Exadata Deployment Assistant
D Oracle Exadata Installation Assistant

Which two statements are true about enabling write-back flash cache? (Choose two.)

A Before write-back flash cache is enabled, you need to drop the Flash Cache first.
B Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
C When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
D When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
E Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.

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. Each component type must be upgraded independently of the other.
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 with all database and storage servers listed in a single input file.

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

A For database servers, perform a server backup using patchmgr --dbnodes db_list_file --backup --rolling.
B Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
C Run patchmgr --all_comp --autofix --autobackup --upgrade --rolling.
D Run exachk and resolve only WARNINGS that you have not seen before.
E Run the appropriate patchmgr prerequisite check step for each component being updated.
F Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.