1Z0-485 Online Practice Questions and Answers

Exadata Database Machine offers an Intelligent Platform Management Interface for the various components in the Exadata product. Which option is true?

A. IPMI can be used to remotely start and stop servers.

B. IPMI can be used to remotely log in to the operating system.

C. IPMI commands can be executed by using SNMP traps.

D. IPMI settings can be secured by backing up the Oracle Linux installation on the storage system.

The mpstat output from OS Watcher shows a database node as being 90% idle on an average. What would you do to get a full picture of CPU utilization on the entire Exadata RAC cluster?

A. Average the mpstat id1 output from all the nodes.

B. Ask application users if they have noticed a slowdown in screen response.

C. Look for an increase in batch job servicing times.

D. A and B above

Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?

A. INSERT

B. INSERT with an APPEND hint

C. UPDATE

D. CREATE TABLE AS SELECT

Which two statements are true about migrating your database to Exadata?

A. Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.

B. Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.

C. ASM and database best practice configuration supplied during Exadata deployment should be retained during and after migration,

D. Logical migration methods allow more flexibility than physical methods to change the database structure for best performance.

E. All indexes should be dropped when migrating to Exadata.

You are concerned about how to recover from a failed Exadata Storage Server. What is the best way to recover from a storage cell failure when content in both system disks is lost?

A. Database Machine Administrators should be prepared by creating a backup using dbserver_backup.sh.

B. Database Machine Administrators should be prepared by creating a backup to an NFS file location as described in the owners guide.

C. Any USB can be plugged in to create a backup.

D. Be sure that you have a backup by running make_cellboot_usb.sh in /opt/oracle.cellos.

E. Use the Exadata Storage Server rescue functionality that Is provided on the CELLBOOT USB flash drive.

F. Re-imaging the cell is the only option.

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

Identify a recommended configuration to set up Auto Service Request (ASR) for Exadata.

A. Install ASR Manager on Exadata Database Server.

B. Install ASR Manager on Exadata Storage Server.

C. ASR is not recommended for Exadata; the Oracle Configuration Manager is preferred.

D. Install ASR Manager on a Standalone Server.