1Z0-485 Exam Questions

Which two statements are true about troubleshooting failed patching activities?

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

Your customer wants to increase the size of the DATA diskgroup on the Exadata systems. The customer is currently using 600 GB disks. Which two are the best options that you would r...

What are two choices that a customer must make that impact diskgroup creation?

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

Which two statements describe correct network configuration for Exadata Database Machine?

How would you execute CellCLI commands and scripts?

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

Which statement is true about Exadata Storage Servers?

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 exp...

Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?

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

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

When should you use Hybrid Columnar Compression?

When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?

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?

You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O savings as a result of the storage indexes. Which two statements are...

How does partition pruning, a 11g R2 database feature, help to improve performance on an Exadata Database Machine?

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

Which is a best practice for High Availability (HA) in an Exadata environment?

What is the benefit of bonding the client access network configuration?

To guarantee proper cooling, you plan to place perforated floor tiles near your Database Machine. Where, in relation to the cabinet, should they be placed?

You are asked to enable Write Back Flash Cache for one of your customers X3-2 Full Rack in a rolling fashion. Put the following steps in the right order:

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

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 fo...

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

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

After migrating from legacy disk-based configuration, which three approaches would you use to evaluate the efficiency of Exadata Flash Cache?

You are concerned about how recovery from a failed Exadata Storage Server would work. Which statement is true about the Exadata CELLBOOT USB?

Which two migration will result in the least down time for a physical or logical migration of a database with active users during the migration?

If your customer wants to save storage space by compressing tables that are read frequently but rarely updated, which compression technique would you recommend?

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 wh...

Which statement is true about Oracle compression?

Which statement is true about instance caging setup?

Your customer would like to use DBFS in their Exadata environment. They are asking you for the key characteristic of DBFS on Exadata.

What are the three customer options for hosting the Platinum Services Advanced Support Gateway?

Which statement is true about Enterprise Manager 12c for Exadata?

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

A control file tracks the physical components of a database. It is the root file that the database uses to find all the other files used by the database. Because of the importance...

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

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

Which two statements appropriately describe the backup and recovery procedures on Exadata?

Which two actions are permitted with Exadata Database Machine?

Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata?

Which two statements are true about Exadata memory capabilities?

Identify three valid configuration options that can be implemented during the initial configuration process of a new Database Machine by using the Exadata Deployment Assistant

Which two are true about the use of the Integrated Lights Out Manager (ILOM) on the Database Machine?

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

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.