VCEdump

1Z0-485 Oracle Exadata Database Machine

PDF question preview Back to product

Reading controls

Reader tools

Free demo

11 of 71 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice4

Multiple choice7

Oracle · 1Z0-485

Free 1Z0-485 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

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.

Reveal answer details Close answer details

Correct answersB, C

Question 2

Single choice

Identify a recommended configuration to set up Auto Service Request (ASR) for Exadata.

A
Install ASR Manager on Exadata Database Server.
B
Install ASR Manager on Exadata Storage Server.
C
ASR is not recommended for Exadata; the Oracle Configuration Manager is preferred.
D
Install ASR Manager on a Standalone Server.

Reveal answer details Close answer details

Correct answerD

Question 3

Multiple choice

Identify three Exadata Storage Server software processes and their purpose?

A
CELLSRV: The Cell Server is responsible for servicing disk I/O and predicate processing offload.
B
CELLSRV: The Cell Server is responsible for balancing workload to other storage servers.
100% Real Q&As | 100% Real Pass
C
MS: The Management Server is responsible for storage cell management and configuration.
D
MS: The Management Server is responsible for starting a local Enterprise Manager agent.
E
RS: The Restart Server is responsible for Automatic Storage Management (ASM) instance restart.
F
RS: The Restart Server is responsible for CELLSRV and MS monitoring and restart.

Reveal answer details Close answer details

Correct answersA, C, F

Question 4

Multiple choice

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

Reveal answer details Close answer details

Correct answersA, C

Question 5

Multiple choice

When running OS Watcher, which two data outputs are valid for Exadata storage cell performance analysis?
Select the two correct choices that apply?

A
lostat
B
mpstat
C
netstat
D
pkginfo
E
label

Reveal answer details Close answer details

Correct answersA, C

Question 6

Multiple choice

Which two actions are permitted with Exadata Database Machine?

A
replacing the Ethernet switch with an equivalent 1U 48-port Gigabit Ethernet switch
B
installing a second Ethernet switch in the Exadata rack for client access network connectivity
C
replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand Gateway Switch
D
configuring a Linux active-active channel bonding on the database servers by using two 10-Gigabit
Ethernet port
E
configuring a Fibre Channel over Ethernet (FCoE) protocol on database servers

Reveal answer details Close answer details

Correct answersA, C

Question 7

Multiple choice

Which three statements accurately describe update of software on Exadata Database Machine?

A
The Oracle Database patchset software (for example, 11.2.0.3) requires the Exadata-specific version.
B
Rolling patching is faster than non-rolling patching, but database down time is longer.
C
The Oracle Database software on Exadata is updated using standard OPatch and the Oracle Universal
Installer.
D
Running Exadata with different storage server software versions is supported, but should be minimized
to rolling patching scenarios.
E
The database server operating system software (other than kernel and OFED) may be installed or
updated from non-Exadata sources
F
Storage server updates require access to an Unbreakable Linux Network (ULN) based repository.

Reveal answer details Close answer details

Correct answersC, D, F

Question 8

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.

Reveal answer details Close answer details

Correct answerD

Question 9

Single choice

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

A
Enable Smart Flash Log.
B
Execute alter table ... cell_flash_cache=keep on heavily scanned tables.
C
Enable Write Back Flash Cache.
D
Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.

Reveal answer details Close answer details

Correct answerB

Question 10

Multiple choice

Which two statements are true about enabling write-back flash cache?

A
When enabling write-back flash cache in a non rolling manner, it is important to ensure that
asmdeactivatonoutcome is set to YES and asmModestatus is set to ONLINE for all grid disks.
B
Before using write-back flash cache, you need to verify the minimum required versions.
C
Before write back-flash cache is enabled, you need to drop the Flash Cache first.
D
The setting flashCacheMode should be set to writeback by updating cellinit.ora and restarting cellsrv.
E
When enabling write-back flash cache in a rolling manner, dcli should be used to inactivate the grid
disks on all cells first.

Reveal answer details Close answer details

Correct answersB, C

Question 11

Single choice

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

A
Replace the disk and run MegaCLI to rebuild the degenerate mirror.
B
No manual action is required because Automatic Storage Management (ASM) fast mirror resync is
automatic
C
No manual action is required because ASM rebalancing is automatic.
D
Replace the disk and manually copy the mirror extents to the new drive.
E
Run RMAN REPAIR FAILURE.

Reveal answer details Close answer details

Correct answerC

VOL	TYPE	QUESTIONS
1	Single choice	4
2	Multiple choice	7

Free 1Z0-485 Exam Dumps Preview

Oracle Exadata Database Machine

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11