1Z0-485 Online Practice Questions and Answers

Which two statements are true about troubleshooting failed patching activities?

A. Dependency issues found during yum updates require rolling back to a previous release before retrying.

B. Bundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.

C. Failed OS patches on database servers can be rolled back.

D. Failed storage cell patches are rolled back to the previous release automatically.

E. Database server OS updates can be rolled back using opatch auto -rollback.

F. Dependency issues found during yum updates should be ignored using the force option.

Your customer is hesitant to install the Oracle Configuration Manager in their environment. Give them three ways in which it will benefit their Exsdata Database Machine support experience and potentially resolve some of the issues they are having with the length of time it is taking Oracle to process their Exadata Service Requests (SRs).

A. Host information can be gathered and sent to Oracle for license compliance.

B. Potential issues can be addressed before they impact operations.

C. Priority handling can be extended for SRs, with attached configuration.

D. Exadata patching cannot be done successfully without the Oracle Configuration Manager.

E. Root cause analysis can be accelerated.

High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?

A. Enable Write-Back Flash Cache due to heavy DBWR usage.

B. Enable Write-Back Flash Cache due to heavy LGWR usage.

C. Swap hard disks to High Capacity disks.

D. Tune the application to reduce I/O requests. 100% Real QandAs | 100% Real Pass

E. Leverage IORM to give priority to critical workloads.

Storage indexes are unique to the Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:

1.

The Exadata cell services software conducts I/O requests on I MO storage regions.

2.

cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.

3.

The database is started.

4.

Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.

5.

A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.

6.

A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.

7.

MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the I/O request.

A. 3. 7, 5, 2, 1, 6, and 4

B. 3, 7, 1, 5, 6, 2, and 4

C. 3, 6, 1. 7, 2, 5 and 4

D. 3, 5, 1, 7, 6, 2. and 4

Identify four significant changes when a backup of Exadata compute nodes must be performed.

A. application of operating system patches

B. before shutdown to preserve storage indexes

C. application of Oracle patches

D. reconfiguration of significant operating system parameters

E. installation or reconfiguration of significant non-Oracle software

F. storage server rebalancing

G. addition of an Exadata storage expansion rack

What are three ways to be informed of an Exadata Storage Server disk failure?

A. review of the output of LIST ALERTHISTORY

B. review of the output of SELECT STATUS FROM VSDATAFILE

C. review of the ILOM log

D. alert notifications through email when SMTP notification is configured

E. alert notifications in the Enterprise Manager Exadata Plug-In 100% Real QandAs | 100% Real Pass

F. review of database server iostat output

Identify two ways to reduce the risks associated with the software updates that are performed on a production Exadata system.

A. Patch all systems at once instead of one at a time.

B. Test on an Exadata system that is identical to the production system first.

C. Updating an engineered system has no risk.

D. Patch on the standby system first by using Data Guard Standby First Patch Apply.

E. Create a system-wide firmware and software snapshot first.

Which two actions are permitted with Exadata Database Machine?

A. replacing the Ethernet switch with an equivalent 1U 48-port Gigabit Ethernet switch

B. installing a second Ethernet switch in the Exadata rack for client access network connectivity

C. replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand Gateway Switch

D. configuring a Linux active-active channel bonding on the database servers by using two 10-Gigabit Ethernet port

E. configuring a Fibre Channel over Ethernet (FCoE) protocol on database servers

Which three migration options are available when you migrate a database from the Big Endian format system to Exadata?

A. Data Pump Export and Import

B. transportable database

C. transportable tablespaces

D. Data Guard

E. Insert as Select

When running OS Watcher, which two data outputs are valid for Exadata storage cell performance analysis? Select the two correct choices that apply?

A. lostat

B. mpstat

C. netstat

D. pkginfo

E. label