Free Oracle 1z1-485 Exam Dumps Questions & Answers

Which statement is true about Oracle compression?

• A.Hybrid Columnar Compression can be defined for a single column.
• B.A partitioned table can define the use of Advanced Compression or HybridColumnar Compression for each partition.
• C.A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.
• D.A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.

When using IORM, which statement accurately describes when redo log file writes take place?

• A.Based on the intradatabase resource plan
• B.Based on the priority of the user
• C.Immediately
• D.Based on the resource group of the user

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

• A.Some space from the CELLBOOT USB is used for cache metadata when write back flash cache is enabled.
• B.Each patch that is performed on Exadata storage servers requires manual resync of the CELLBOOT USB.
• C.Changes to network configuration files are possible without usingipconf.plas long as all relevant files are updated.
• D.Exadata automatically copies OS binaries and configuration files from another cell during patching to sync the internal USB.
• E.Regular Exadata Storage Server patches make sure that the internal USB is updated so that it can be used for recovery.

Identify three best practices for applying asmdeactivationoutcome es on Exadata Database Servers and Exadata Storage Servers?

• A.Before patching cells in a rolling manner, you must check asmdeactivationoutcome amModestatus and make sure that cells on all disks are online and that disks can be deactivated.
• B.It is recommended that Exadata systems with Data Guard configured use the "Standby First" patching approach.
• C.Bundle patches do not require testing before being installed on a production system.
• D.Patching should never be interrupted due to a connection drop. It is therefore recommended that you use VNC or the screen utility.
• E.Backing up database servers and storage cells is not recommended before performing planned maintenance.
• F.Database server updates can be rolled back using the the "yum downgrade" procedure.

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

• A.Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.
• B.Using partition pruning can force the optimizer to use that method instead of Smart Scan.
  Partitioning in Exadatashould be used wisely
• C.Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.
• D.Partition pruning is not a supported option in the11gR2database codethatruns on an Exadata Machine, due to issues with Cost Based Optimizer plans.
• E.Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.