Oracle 1Z0-902 Online Practice Questions and Exam Preparation

Oracle 1Z0-902 Online Questions & Answers

• Question 1:

  Which two statements are true in regards to starting the Exadata Virtual Machine?

  A. To see Oracle Linux boot messages during guest startup, use --console option with the vm_maker --start-domain command.
  B. Use vm_maker --start-domain to start a virtual machine manually.
  C. Use vm_maker boot-from-iso command to boot a virtual machine.
  D. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
  E. Use vm_maker --auto-start command to configure a virtual machine to start automatically when the KVM host is started.
  B. Use vm_maker --start-domain to start a virtual machine manually.
  E. Use vm_maker --auto-start command to configure a virtual machine to start automatically when the KVM host is started.

  ---

  Explanation/Reference:

  Statement B is true as the vm_maker --start-domain command can be used to start a virtual machine manually, as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 65). Statement E is also true as the vm_maker --auto-start command can be used to configure a virtual machine to start automatically when the KVM host is started [1][2], as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 66).

• Question 2:

  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?

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

  ---

  Explanation/Reference:

  In order to monitor all components of this multirack configuration, Enterprise Manager agents must be deployed on at least two storage servers in both racks and all database servers in both racks. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book [1], in which it states "To monitor all components of the multirack configuration, you must deploy agents on all database servers and at least two storage servers in each rack" (page 6-15).

• Question 3:

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

  A. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
  B. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
  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.
  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.

  ---

  Explanation/Reference:

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

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

• Question 4:

  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.
  B. It has command-line history.
  D. It can be executed on storage servers.
  E. It can be executed using the DCLI utility.

  ---

  Explanation/Reference:

  The statements that are true about the CellCLI command are:

  It has command-line history . According to 1, you can use the up and down arrow keys to scroll through previous commands that you entered in CellCLI . You can also use Ctrl+R to search for a previous command by entering part of it . It can

  be executed on storage servers . According to 1, you can invoke CellCLI by logging in to the Exadata cell as cellmonitor , celladmin , or root user and typing "cellcli" . Within CellCLI , you can perform various management and monitoring tasks

  for the cell134.

  It can be executed using the DCLI utility . According to 5, DCLI (distributed CLI) is another utility that can be used to execute scripts and commands across multiple storagecells from a single interface. You can use DCLI to run CellCLI

  commands on multiple cells at once54.

• Question 5:

  You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?

  A. ifconfig -a legrep "re0| re1"
  B. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 --all
  C. netstat -rn
  D. cat /proc/net/bonding/bondeth0
  D. cat /proc/net/bonding/bondeth0

  ---

  Explanation/Reference:

  According to Oracle's documentation1, the client network on Exadata X9M-2 Database Server is used for client access to the database servers using Single Client Access Name (SCAN) and Oracle RAC Virtual IP (VIP)

  addresses. To verify that the client network is available via both client switches, you can use the command:

  cat /proc/net/bonding/bondeth0

  This command displays information about the bondeth0 interface, which is used for the client network on Exadata X9M-2 Database Server2. You can check if both interfaces (eth0 and eth1) are active and connected to different switches3.

• Question 6:

  You use Enterprise Manager to monitor all the components of your Exadata Database Machine.

  Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.

  In which two sources would you find diagnostic messages related to this problem?

  A. alert logs for Enterprise Manager
  B. alert logs for the ASM instances
  C. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
  D. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
  E. alert logs for the prod database instances
  B. alert logs for the ASM instances
  E. alert logs for the prod database instances

  ---

  Explanation/Reference:

  According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not. https://docs.oracle.com/en/engineered-systems/exadata-database- machine/sagug/exadata-administering-asm.html

• Question 7:

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

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

  ---

  Explanation/Reference:

  According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:

  A. changing the root password

  E. configuring secure shell user equivalency for the cellmonitor user

  https://docs.oracle.com/en/engineered-systems/exadata-database- machine/dbmso/exadata-introduction.html

• Question 8:

  A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3- phase 15kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU.

  Which statement is correct?

  A. The installation can go ahead, no change is required.
  B. The installation cannot proceed until two power feeds are available per PDU.
  C. A splitter cable can be used to provide power to all PDU cables.
  D. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
  A. The installation can go ahead, no change is required.

  ---

  Explanation/Reference:

  According to the Oracle Exadata Database Machine X9M-2 Data Sheet1, each PDU has two power input cables that can be connected to separate power sources for redundancy. However, if only one power source is available per PDU, then a single cable can be used to provide sufficient power for normal operation. https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf

• Question 9:

  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?

  A. Copy and execute the script on all storage servers using the EXACLI command.
  B. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
  C. Copy and execute the script on all storage servers using the dcli command.
  D. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
  E. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
  C. Copy and execute the script on all storage servers using the dcli command.

  ---

  Explanation/Reference:

  According to Oracle's documentation1, the Cell Control Command-Line Interface (CellCLI) utility is the command-line administration tool for Oracle Exadata System Software. It can be used to perform various tasks on Exadata Storage Servers, such as creating and managing objects, monitoring performance, and configuring alerts. To run CELLCLI commands on multiple cells simultaneously, you can use the Distributed Command-Line Interface (dcli) utility2. The dcli utility allows you to execute commands or scripts on a group of cells or hosts in parallel. You can use the dcli utility to copy files from one cell or host to multiple cells or hosts using the -f option3. You can also use the dcli utility to execute commands or scripts on multiple cells or hosts using the -l option to specify a user name and the -g option to specify a file containing a list of cells or hosts3. Therefore, to achieve your requirement of running a script with several CELLCLI commands on each cell in your Exadata full rack simultaneously, you must: Copy and execute the script on all storage servers using the dcli command.

• Question 10:

  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?

  A. Replace the failed physical disk.
  B. Add the griddisks back into the ASM diskgroup they used to be a member of.
  C. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
  D. Rebalance the data on the effected griddisks before performing a manual drop command.
  E. Create a new celldisk and new griddisks on the replaced physical disk.
  F. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
  A. Replace the failed physical disk.
  C. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.

  ---

  Explanation/Reference:

  Once the physical disk has been replaced, you will need to create a new celldisk and griddisks on the replaced physical disk. After the griddisks have been dropped from the associated ASM diskgroups, you can then add the griddisks back into the ASM diskgroup they used to be a member of and rebalance the data on the effected griddisks. Finally, you should verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.