1Z0-485 Real Exam Questions and Verified Answers

Question 1 Single choice

Which statement is true about instance caging setup?

A
Instance caging is the right approach to make sure that database instances are not stealing memory
from each other.
B
The CPU Resource Manager and IORM need to be enabled to make instance caging to work as
expected.
C
Database instances need to be restarted to make changes to cpu_count effective.
D
For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to
prevent oversubscribing
E
The init.org parameter resource_manager_plan should be set.

Show answer and explanation

Correct answer: D

Question 2 Multiple choice

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

Show answer and explanation

Correct answers: A, C, D, G

Question 3 Multiple choice

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 Q&As | 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.

Show answer and explanation

Correct answers: B, C

Question 4 Multiple choice

Which statement is true about Oracle compression?

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

Show answer and explanation

Correct answers: C, D

Question 5 Multiple choice

Consider this CellCLI command: CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;

Which two statements describe what happens when you execute this command?

A
It creates one 423 GB grid disk on the first available cell hard disk.
B
It creates one 423 GB grid disk on each available cell hard disk.
C
It creates grid disks on the outermost 423 GB that is available on each hard disk.
D
It creates grid disks on the innermost 423 GB that is available on each hard disk.
E
It creates an Exadata Smart Flash Cache on all flash drives.

Show answer and explanation

Correct answers: B, C

Question 6 Single choice

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

100% Real Q&As | 100% Real Pass

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
High redundancy speeds up ASM fast mirror resync when a cell is brought back online after patching.
D
Normal redundancy provides the same protection during rolling patching, so High redundancy is not
important in this case

Show answer and explanation

Correct answer: A

Question 7 Single choice

Which is the best location to point your customer to, for finding the latest Exadata patches?

A
owner's guide
B
Patch database in MyOracle Support
C
MyOracle Support note 888828.1
D
MyOracle Support for database patches, ULN for OS patches, and Sun Support for Server and
InfiniBand patches.

Show answer and explanation

Correct answer: B

Question 8 Single choice

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 Exadata should be used wisely,
C
Partition pruning is not a supported option in the 11gR2 database code that runs on an Exadata
Machine, due to issues with Cost Based Optimizer plans.
D
Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within
the individual tables.
E
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.

Show answer and explanation

Correct answer: A

Question 9 Single choice

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

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

Show answer and explanation

Correct answer: B

Question 10 Multiple choice

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 true?

SQL> select count (*) from transmap.mymap_comp
2 where map_id between 400 and 500;
COUNT(*)
---------------------------------------103000
Elapsed: 00:00:00.08

SQL> select b.name, a.value/1024/1024 value
from vSmystat a, vSstatname b,
where b.statistic# = a.statistic#
and b.nafne in (-cell physical IO bytes eligible for predicate offload', -cell physical IO interconnect bytes', -cell physical IO bytes saved by storage index',

100% Real Q&As | 100% Real Pass

-cell physical IO interconnect bytes returned by smart scan') order by 1;

Statistic Value (MB)
--------------------------------------------------------------------------------------------- ----------------- cell physical IO bytes
eligible for predicate offload 2,255 .09 cell physical IO bytes saved by storage index .00
cell physical IO interconnect bytes 1.72
cell physical IO interconnect bytes returned by smart scan 1.68

A
The storage indexes were disabled using the DISABLE_STORAGE_INDEX Parameter.
B
Storage Index data is not on the Cell Server's region index memory structures yet because this
predicate has not been used.
C
Since the database was started, no quires were run against this table with the same predicate.
D
The storage indexes reduced the amount of physical I/O bytes significantly for this query.

Show answer and explanation

Correct answers: B, C