Free Oracle 1z0-485 Exam Dumps Questions & Answers

When should you use Hybrid Columnar Compression?

• A.  on large active tables where deeper compression is desired
• B.  on every table where Advanced Compression is not used
• C.  always
• D.  on tables or partitions that have fairly static data

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

• A.  Provide individual x86 64-Bit gateway hardware.
• B.  Install on Exadata Engineered System.
• C.  Purchase the recommended x86 64-Bit gateway hardware from Oracle.
• D.  Install on Oracle Database Appliance.
• E.  Install in Oracle Virtual Machine with required hardware.

Consider the following setup:
User A1 belongs to resource group High on Database A.
User B2 belongs to resource group Low on Database B.
User C3 is a user on Database C without any DBRM setup.
DBRM setup:
Database A: Resource group High gets 80% and Low gets 20%.
Database B: Resource group High gets 60% and Low gets 40%.
IORM setup:
Database A: Share=20, limit=5
Database B: Share=30, limit=10
Database C: 5 shares
Total number of shares in the IORM setup = 100
What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?

• A.  Al = 33%, B2=33%, and C3=33%
• B.  Al = 36%, B2=18%, and C3=9%
• C.  Al = 8%, B2=12%, and C3=5%
• D.  Al = 5%, B2=10%, andC3=85%
• E.  AI = 10%, B2=5%, and C3=20%

Why is ASM High redundancy an important configuration choice when rolling Exadata Storage Server patching is planned?

• A.  High redundancy protects from partner disk failure while a cell is offline being updated.
• B.  High redundancy forces ASM rebalance before allowing disks to be taken offline.
• C.  Normal redundancy provides the same protection during rolling patching, so High redundancy is not important inthis case
• D.  High redundancy speeds up ASM fast mirror resync when a cell is brought back online after patching.

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 larger I/O operation and therefore, forces the use of the Smart Scan technology.
• 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 much smaller I/O operation and therefore, enables a much faster return of information.
• D.  Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.
• E.  Partition pruning is not a supported option in the11gR2database codethatruns on an Exadata Machine, due to issues with Cost Based Optimizer plans.