The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-imaged with an Oracle Support installation image.
Which three tasks must be performed in order to re-image the compute node? (Choose three.)
A. Create a CELLBOOT USB Flash Drive by using an external USB drive.
B. Mount the LVM backup image across the network and recover the system.
C. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
D. Reboot the new server by using a bootable recovery image from the external USB drive.
E. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).
Your customer would like to configure monitoring capabilities alongside ASR on the stand-alone server that was set aside to run ASR Manager.
What configuration would you set up for the customer?
A. Enterprise Manager, SQL Developer Server, and ASR Manager on the stand-alone server because ASR needs SQL Developer to gain SQL access to the database server
B. ASR Manager inside the firewall to ensure that root access to Exadata Database Machine is not compromised
C. ASR Manager with SNMP traps configured to listen for specific alerts triggered by Exadata Database Machine
D. Enterprise Manager (Ops Center) and ASR Manager on the stand-alone server because ASR is not a monitoring tool
You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O sayings as a result of the storage indexes.
Which two statements are true? (Choose two.)
A. The accumulated I/O saved by the storage index is 1.68 MB.
B. The storage indexes reduced the amount of physical I/O bytes significantly for this query.
C. Since the database was started, no queries were run against this table with the same predicate.
D. The storage index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.
E. The storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.
To patch an Exadata cloud instance, you need to run the exadbcpatchmulti command as root from the compute node. exadbcpatchmulti uses the exadbcpatch.cfg file to provide information about the location of files related to patching operations as well as additional parameters related to these operations.
What is the purpose of the sw_bkup_needed=1 parameter that can be set in the exadbcpatch.cfg file?
A. creates a backup of the patch in case of an error in the patching routine
B. performs a backup of each Oracle home directory before a patch is applied
C. forces the software to create a backup of the exadbpatch.cfg file
D. adds a dialog box that prompts for a backup before the patch can be applied
E. creates a backup of the Oracle database data files
Your customer has encountered some system disk issues and has been told that a “storage cell rescue procedure” must be implemented.
What will this procedure accomplish?
A. It will perform a predictive disk failure replacement for cell disks.
B. It will recover the Exadata system volumes by using the internal USB flash disk.
C. It will perform cell flash cache failure replacement.
D. It will perform a complete storage server hardware replacement.
E. It will perform a database server disk replacement.
Consider the following command:
./patchmgr -cells dm01 -patch -rolling
Which two actions does this command perform? (Choose two.)
A. upgrades one or more Exadata Storage Servers simultaneously
B. upgrades one or more Exadata Storage Servers listed in the dm01 file
C. upgrades one or more Exadata Storage Servers, one at a time
D. rolls back one or more Exadata Storage Servers to the previous release
E. upgrades one or more Exadata Storage Servers and InfiniBand Switches
F. upgrades an Exadata Storage Server named dm01
When preparing to install ASR on your customer's Exadata Database Machine, which user account will you use first to configure the Exadata Database Server?
A. asmadmin
B. oracle
C. asruser
D. celladmin
E. root
F. asradmin
Which two statement are true about enabling the write-back flash cache?
A. When enabling the write-back-flash-cache in a rolling manner dbcli should be used to inactivate the grid disks on all cells first.
B. Before write-back-flash-cache is enabled you need to drop the flash cache first.
C. Write back flash cache requires a minimum required software version.
D. When enabling write-back-flash-cache in a non-rolling manners it is important to ensure that asmdeactivationoutcome is set to yes and asmmodestatus is set to online for all grid disks.
E. flashcachemode should be set to write back by updating cellinit.ora and restarting cellsrv.
How do ASM failure group provide redundancy?
A. For external redundancy ASM disk groups are placed in a Raid 1+0 configuration to ensure the no blocks are lost during an outage.
B. They ensure that the ASM disks are accessed via ADB protocol and not physically mounted on the database server.
C. They assign ASM disks to failure groups to ensure that the mirror copies of a block are not in the same failure group.
D. They ensure that the cell disks are sliced into grid disks by using cellsrv processes.
Which statement is true about High Availability (HA) in an Exadata environment?
A. When a standby database is in place, DB_BLOCK_CHECKINGis not required and thus is not recommended.
B. The checksums that are performed on the Exadata Storage Server ensure logical consistency of the block content.
C. Stretched RAC is the best alternative for Exadata that combines both HA and DR into one.
D. Due to the different architecture that Exadata has with storage servers when compared to regular Storage Area Network, DB_LOST_WRITE_PROTECTneed not be set.
E. The Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUMon a database.