Question No. 1

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?

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

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

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

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

Show Answer

Correct Answer: D

Question No. 2

You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.

Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?

Ato the CELLADMIN account by calling CELLCLI on all cells using DCLI

Bto an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli

Cto the CELLMONITOR account using cellcli interactively on each storage server

Dto an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli

Eto the CELLMONITOR account calling CELLCLI on all cells using DCLI

Fto the CELLADMIN account using cellcli interactively on each storage server

Show Answer

Correct Answer: B, C, E

Question No. 3

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?

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

BYou 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'.

CYou query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

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

Show Answer

Correct Answer: A, B

Question No. 4

Which two activities are supported on the storage servers in an Exadata Database Machine?

Achanging the root password

Bupgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

Cinstalling an alternative package manager

Dupgrading the Storage Server software package using rpm

Econfiguring secure shell user equivalency for the cellmonitor user

Show Answer

Correct Answer: A, C

Question No. 5

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

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

BBacking up Exadata Storage Server Software is critical for restoration.

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

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

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

Show Answer

Correct Answer: D, E

Free Oracle 1Z0-902 Exam Actual Questions

The questions for 1Z0-902 were last updated On Dec 17, 2024