1Z0-485 Online Practice Questions and Answers

You get a Host Unreachable error when you attempt to connect to a server through a network terminal command line. What are two other ways in which you can connect?

100% Real QandAs | 100% Real Pass

A. Use the ILOM Web GUI.

B. Use the dcli command at the root prompt on a database node.

C. Attach a terminal device to the back panel of the server with a serial cable.

D. Connect by using SQL *Plus.

E. Log in as root on the database node using the Net1 IP address.

When would be the best time to run an Exadata health check (exachk)?

100% Real QandAs | 100% Real Pass

A. before patching, before upgrades, before backups, and on a regular basis

B. after patching, after upgrades, and after backups

C. only when advised by Oracle Support

D. before and after patching, when advised by Oracle Support, and on a regular basis

E. only after a hardware failure

F. monthly and after a hardware failure

Identify the three values to which the CELL_FLASH_CACHE attribute can be set.

A. READ

B. WRITE

C. KEEP

D. DEFAULT

E. NONE

Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.

A. Remove the doors of the 1/8th rack. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack.

B. Activate all cores by using a software command. Activate all hard drives and flash drives. Create the grid disks. Expand the Oracle ASM diskgroups. Review the new configuration.

C. Remove the doors of the 1/8th rack. Add an additional Sun Datacenter InfiniBand Switch. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack. Configure the new hardware.

D. Activate all cores by using a software command. Activate all hard drives and flash drives.

100% Real QandAs | 100% Real Pass

Which statement is true about the patching features provided in Platinum Services?

A. Patching services are available for the full software stack up to twice per year.

B. Patching support includes Exadata, Exalogic, and Database Appliance.

C. Rolling window and complete down time approaches are two options to patching.

D. Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

Which table compression technique will not work on Exadata without licensing the Oracle Advanced Compression Option?

A. COMPRESS

B. COMPRESS BASIC

C. COMPRESS FOR OLTP

D. COMPRESS FOR QUERY

E. COMPRESS FOR ARCHIVE

Your customer has purchased their brand new Exadata Database Machine X3-2 Full rack to achieve 20- TB-per-hour backups on their 300 TB database. You have been called to determine why they are not able to achieve even half that rate. Use the information in the image below to identify two reasons their backups are still slow.

100% Real QandAs | 100% Real Pass

A. LVM snapshots are not configured properly on the Database Server.

B. The Media Server to Tape Library transfer is causing a bottleneck.

C. The number of tape drives is causing a bottleneck.

D. Exadata backups are being performed using RMAN over the 10 Gigabit Ethernet network.

E. The number of database servers is causing a bottleneck.

Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.

A. Transformations can be applied directly on the file data using SQL or PL/SQL constructions.

B. External tables allow transparent parallelization inside the database.

C. Parallelizing loads with external tables enables more efficient space management.

D. External tables can take advantage of storage indexes to speed up data loads.

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.

You are calculating the storage capacity that your customer will require on their ZFS Backup Appliance. Identify the set of factors that will affect this calculation.

A. database size, full/incremental cycle, RPO (Recovery Point Objective), and RTO (Recovery Time Objective)

B. database size, retention period, RPO (Recovery Point Objective), and compression

C. database size, full/incremental cycle, compression, and retention period

D. database size, compression, and backup window

E. full/incremental cycle, retention period, and ZFS Backup Appliance model