1Z0-902 Online Practice Questions and Answers

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

A. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

B. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.

C. Run exachk and resolve only WARNINGS that you have not seen before.

D. Run the appropriate patchmgr preqequisite check step for each component being updated.

E. Run patchmgr --all_comp --autofix --autobackup --upgrade --rolling.

F. For database servers, perform a server backup using patchmgr --dbnodes db_list_file --backup --rolling.

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 must be invoked with the --rolling argument. Each component type must be upgraded independently of the other.

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

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

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

Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

A. the failure of physical disk 1

B. corruption in the / (root) filesystem

C. the failure of both physical M.2 disks

D. the failure of physical disk 0 and 11

E. moving all disks from one cell to another as part of a chassis-level component failure

F. accidental loss of all data from all griddisks in a storage server

G. corruption in a normal or high redundancy ASM diskgroup

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

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

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

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

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

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

Which three statements are true about the CELLCLI command?

A. It can execute commands on multiple storage servers in parallel.

B. It has command-line history.

C. It requires root privileges to create CELLDISKS and GRIDDISKS.

D. It can be executed on storage servers.

E. It can be executed using the DCLI utility.

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

A. Add 12x 32GB DIMMs.

B. Add 12x 64GB DIMMs.

C. Shutdown the Database Server if running.

D. Add 16x 32GB DIMMs.

E. Add 16x 64GB DIMMs.

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

G. Remove existing memory modules.

H. Add 32x 64GB DIMMs.

I. Add 24x 32GB DIMMs.

Which dbmcli command is NOT valid on Exadata X9M?

A. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"

B. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "

C. dbmcli -e "LIST IBPORT DETAIL"

D. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"

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 use use to generate alerts for such an event?

A. dbmcli -e "set alert ds_temp> 30" on each database server

B. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server

C. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server

D. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server

You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.

The new storage servers are called DM01CEL08 through dmoicel14.

After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?

A. 1 consisting of all 96 griddisks

B. 96 consisting of one griddisk each

C. 0 because the new griddisks will be added to the existing faiigroups

D. 12 consisting of seven griddisks each

E. 7 consisting of 12 griddisks each

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

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

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

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

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

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

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