Oracle 1z0-902 Exam Questions

Question 6 of 60

Which two statements are true in regards to starting the Exadata Virtual Machine? (Choose two.)

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

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

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

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

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

Correct Answer: B, C

Question 7 of 60

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

Backing up Exadata Storage Server Software is critical for restoration.

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

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

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

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.

Correct Answer: B, C

Question 8 of 60

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

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

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

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.

Correct Answer: B, C

Question 9 of 60

In order to support a new application, you are planning to add a RAC VM cluster to an existing Oracle Exadata Machine X9M-2 deployment.
Which two methods can be considered? (Choose two.)

Use Oracle VM Manager.

Use the OEDA web-based configuration tool.

Use domu_maker utility.

Use the xm command.

Use the OEDA Command line interface.

Correct Answer: B, E

Question 10 of 60

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

You query V$SYSSTAT 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.

You query V$SEGMENT_STATISTICS and filter for the Object ID of your table from DBA_OBJECTS and the column STATISTIC_NAME='optimized physical reads'.

You query V$SYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

Correct Answer: A, D